asp.net Website can't connect to SQL server - login error

Question

out of the blue i am getting intermittent error from my website saying:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"}

any suggestion on what might be wrong? seems like the connection to the db can't be established but i don't understand why it would be complaining about the login process

You might want to check that TCP/IP is enabled in SQL Server Configuration Manager — Neil Knight
– Neil Knight, Commented Jan 4, 2011 at 6:54
He said intermittent errors, how is your userid password setup..looks like there is some code somewhere (possibly hardcoded) that connects with a wrong user id and password..do you have a stack trace as to "where" in the code your this error occurs..? — Mahesh
– Mahesh, Commented Jan 4, 2011 at 7:23

ashish.chotalia · Accepted Answer · 2011-01-04 06:52:48Z

2

Please try following and let me know if you find it useful.

Login with windows authentication.
Right click on the Instance name - Server Properties
Security page
Set the Server Authentication - 'SQL Server and Windows Authentication mode'
Restart the SQL Service.

Then close the sqlserver and restart. It should work.

if the above steps donot work then try thebelow ones: Make sure the user is not disabled 1. Login as an Administrator into the SqL Server

Expand Security/ Logins folder
Right Click on the particular user and go to properties
Click Status Permission: Granted

Login : Enabled

SQL configuration wizard and make sured that TCP/IP and named pipes are enabled and that they are set to priorities 1 and 2.

answered Jan 4, 2011 at 6:52

ashish.chotalia

3,73630 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

asp.net Website can't connect to SQL server - login error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related