question

ahmedtamseer avatar image
ahmedtamseer asked

how can i come out from error during login?

i am using sql server 2008 from one year. but when i logged in, today, i got following error. TITLE: Connect to Server ------------------------------ Cannot connect to vaio. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ can any one please explain me how to get out it? [the database contains many important data. i didn't even kept a back up copy].
sql-server-2008sql-server-2008-r2loginsql-server-log
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
That's a general connection error. Is the SQL Server machine powered on? Is the SQL Server service running? Is the SQL browser service running? (in case of named instances) Can you ping the server? What changes have happened? Network? Firewall? Lots to check, just work through simple steps....
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image Tom Staab ♦ commented ·
I agree with Kev's list of things to check. Good luck. You mentioned you have no backup. If/when you can reconnect, I strongly recommend you make one ASAP.
1 Like 1 ·
Oleg avatar image Oleg commented ·
@ahmedtamseer From the description in your question, it looks like you are trying to connect to the SQL Server instance located on the same laptop. If this is the case and the SQL Server service is configured to run as your local user account then the service will not start if you recently changed the password. As @Kev Riley suggested in his answer, check whether the SQL Server service is running or not. If it is not then try to start it. If it does not start then you get the error message telling you why it could not start, but the odds are that the password change is the issue.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.