Sql Server Login Problems

Hi all,

Today i created a new Sql Server  user on my development machine , permission grant correctly, user created ,but my asp.net page won’t login to database ……….. so i searched sql server error log :

Error :18456, Severity:14, State:58 .

 

searching the net i found that state 58 is a only Windows authentication mode login problem , changed it to mixed mode and everything is fine .

 

these are the valid resources i found :

http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

http://msdn.microsoft.com/en-us/library/ms188670.aspx

see you

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s