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
 General SQL Server Forums
 New to SQL Server Programming
 Cannot login to sql server 2005 (new setup)

Author  Topic 

cripto9t
Starting Member

2 Posts

Posted - 2007-10-18 : 15:15:36
I just set it up on my laptop, its the express edition.
During setup I specified both auth (windows and login) and wrote down the username and password. I can connect through Management Studio with windows auth but not with the login.

I want to find the username and password. What do I need to do?

Thanks

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-18 : 22:56:21
When logging into Management studio w/ Windows Auth. expand security and then click on logins, you should see the login that you created there, you can change the password in the properties there also.





Future guru in the making.
Go to Top of Page

cripto9t
Starting Member

2 Posts

Posted - 2007-10-19 : 09:23:48
Thanks for the directions Zoroaster. The login I created during setup wasn't listed there. I created a new one and all is good.
Thanks again
Go to Top of Page

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-19 : 10:34:53
No problem, during setup though as I recall it doesn't let you create a login, it just has you set a password for the SA login.



Future guru in the making.
Go to Top of Page
   

- Advertisement -