for some reason the td user did not get created in my prod install
Question ID: 108615

Very odd,

I felt I did a new install the same way as I always have but the td account does not exist in SQL and the installation works fine, just no td account is found and worry about the difference having an issue down the road.

Can I just add it? My SQL engine uses the sa account for actions (just like it is in my other instances) Thoughts? td user has what rights typically?

Marked as spam
Posted by (Questions: 91, Answers: 5)
Asked on September 14, 2018 6:21 pm
Answers (1)
Private answer

if QC is working as normal AND you are certain you specified ''SQL-Server Authentication'' during install, it MUST be using the SQL-Server user called ''td''.

Perhaps your user that you use to get into SQL-Server Management Studio is limited, are you using ''sa'' or similar account?

Another thing you can try is to login to SQL-Server Management Studio (or a new ODBC DSN) as ''td'' with your td password or the default (''tdtdtd'') and see if you can login. If so, the user exists. Nothing to worry about.

You can create it ahead of time - Create a Login (with SQL-Server management Studio) called ''td'', he just has ''public'' role and nothing else. Take note of what password you used, then use that in your installation.

Marked as spam
Posted by (Questions: 4, Answers: 509)
Answered on September 14, 2018 6:36 pm
D'oh! It was my user i SQL-Server that would not allow me to see the td user.
( at September 14, 2018 6:37 pm)

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top