Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Login SA

Author  Topic 

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-10 : 11:16:14
I perform a new MSDE install OK, giving a strong sa password. I can login using Trusted authentication and the original login I was using for the install - as you might expect - but I can't login using sa which i suppose is not trusted.
If you have an NT login called sa, would it be trusted?
Anyway, I change to "Mixed Authentication" thru the registry, but I still can't login using sa. I've tried three installs and I'm getting the same results. Am I missing something?

silas2
Yak Posting Veteran

65 Posts

Posted - 2005-08-10 : 11:47:30
Sorry! Cancel that, I think I found the answer - I was using a semi-colon in the pwd, i think it was breaking up the connect string. I got it working now.
Go to Top of Page
   

- Advertisement -