I can not connect to my SQL Server 2005

Question

0.00/5 (No votes)

See more:

I can not connect to my SQL Server 2005
this message appears:

CSS

TITLE: Connect to Database Engine
------------------------------

Cannot connect to CHANGEME.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not 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
------------------------------

Posted 3-Jun-10 0:39am

MrLonely_2

Add a Solution

Comments

Sandeep Mewara 3-Jun-10 7:30am

Don't spam. Keep patience. People will respond only when they have time.

Smithers-Jones 3-Jun-10 7:34am

I gave you the answer, that it might be your server not being started. Just google for how to restart the server, if you don't know how to do, damnit. Also vanchi gave you the answer to check your connection string (in case your server is running. You didn't tell us, but just post an error message without any more details). So you got an answer. But you prefer to come back and behave like a chield, that doesn't get its candy immediately. This decreases your chances of getting an answer dramatically. Stop it right now and behave like a grown up. Or bugger off! - Ah I just see that you deleted your fake answer.

6 solutions

Solution 1

hello pls check the connection string.

Posted 3-Jun-10 0:45am

vanchi050585

Solution 2

And did you click on the link to Microsoft, that is mentioned in this error message?

There you wil get this information:

"Explanation

SQL Server did not respond to the client request because the server is probably not started.

User Action

Make sure that the server is started."

Did you try that? You didn't give us any other information, so you you probably won't get a better answer.

Posted 3-Jun-10 0:48am

Smithers-Jones

Solution 6

Thanks every body
The problem is solved..........

SQL

On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

In SQL Server Configuration Manager, in the left pane, click SQL Server.

In the details pane, right-click the named instance of SQL Server, and then click Start.

Posted 3-Jun-10 9:25am

MrLonely_2

Solution 3

I try to connect by :
start---- all programs----- sql server 2005
It is the first time i run it after set up
and i do not know how to start the server?
please help me
thanks every one

Posted 3-Jun-10 0:53am

MrLonely_2

Comments

Sandeep Mewara 3-Jun-10 7:28am

If needed:
1. Use comment feature to respond an answer.
2. Update question to provide more information.

Ankur^\m/ 3-Jun-10 7:29am

Reason for my vote of 1
not an answer.

Smithers-Jones 3-Jun-10 7:35am

Reason for my vote of 1
"and i do not know how to start the server?" Google it.

Solution 7

My solution(note - I use sqlServer 2008):
Step1: Start -> All Programs -> Microsoft SQL Server 2008
-> Configurations Tool
-> SQL Server Configurations Manager
-> click SQL Server Services(It 's First row in left pane)
-> you look right pane and select First row
(click SQL Server(SQLEXPRESS) - here I use SQLEXPRESS)
Step2: After finish Step1 you will look 1 new windown.
-> you find and click Start(Start is element of item Service Status)
-> click OK
ok problem your fixed successful ^^!
I'm newbie.
I from VietNammese!
I love Viet Nam!
I love Viet Nam!
^^!
Viet Nam -> Bac Ninh ->...-> Tao Hoa -> myFamily ^^!

Posted 8-Oct-12 1:57am

timeleft

Updated 8-Oct-12 2:06am

v2

Comments

bbirajdar 8-Oct-12 8:05am

The question was posted more than 2 years ago and already marked solved...

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2010-06-03T01:30:00

Solution 5

Most basic reason could be surface area configuration. Though follow the link below for all possible reasons and how to resolve it:
SQL SERVER – FIX : ERROR : (provider: Named Pipes ....[^]

Posted 3-Jun-10 1:30am

Sandeep Mewara