September 7, 2006 at 5:17 am
Trying to migrate Test Director 8 to Quality Centre 9 in MSSQL but failing miserably.
Both DB servers are SQL auth, both servers are mixed connectivity and both are connecting with the sa user. I've included Trusted_Connection=true to the connect string but if I try to ping or connect I get the above error.
I can connect to QC9 from TD8 using MSDE. This is slowly driving me nuts.
Any help would be much appreciated.
Bobby
September 7, 2006 at 5:21 am
adding Trusted_Connection=true means it needs to be windows authenticated.
Second, connecting as sa is a very serious security risc. I hope sa has a password.
September 7, 2006 at 6:57 am
The SA account is not a Windows Account so it's also not a Trusted Account. Trusted accounts are Windows logins that are authenticated by a domain controller that the SQL Server also uses.
-SQLBill
September 7, 2006 at 7:23 am
Thanks for your help guys and gals. Removed the trusted connection bit and I'm in, although I'm sure I tried that earlier! Of course, now I'm getting permission errors but at least its a step ahead. jeez, this a a long-drawn affair.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply