x

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].

more ▼

asked Jan 14, 2015 at 10:58 AM in Default

avatar image

ahmedtamseer
11 1 1 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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....

more ▼

answered Jan 14, 2015 at 11:10 AM

avatar image

Kev Riley ♦♦
66.2k 48 65 81

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.

Jan 14, 2015 at 06:32 PM Tom Staab ♦

@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.

Jan 14, 2015 at 08:59 PM Oleg
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2197
x783
x108
x16

asked: Jan 14, 2015 at 10:58 AM

Seen: 3131 times

Last Updated: Jan 18, 2015 at 03:25 PM

Copyright 2018 Redgate Software. Privacy Policy