March 9, 2010 at 8:34 pm
i use sql server 2005 express edition.
i have to install SQL SERVER 2005 express
SQL Server 2005 Management
i have problem about login because when i login it doesn't ask password
i don't know how to fix it.
when i install SQL Server 2005 Express i choose Mixed Mod
and key my password.
but when i login it's not ask password.
How to fix it?
March 9, 2010 at 8:42 pm
It won't ask password if you are logging in as windows authentication it will inherit the windows account password from OS, change to Sql Server authentication mode to login as SA role then you have to enter SA password which you entered at the time of install.
March 9, 2010 at 9:08 pm
GTR is correct.
One addendum. Avoid using the SA account where possible. You will typically setup an SA account password during installation. Upon completion, I would create an alternate SQL account to use for login.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply