SQL Server 2008

Question

Post reply

SQL Server 2008

jagannath_podder

SSC Rookie

Points: 34
More actions
September 7, 2010 at 12:06 am

#229069

Hi,
I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message:
"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: 53)"
Just to inform you, I have OS Win7. And I want to establish local connections only on my laptop for my SQL Projects.
Jagannath

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Stupeo Hall of Fame Points: 3067 More actions · Answer 1

You might need to use the SQL Server configuration tool to enable named pipe connections.

Try connecting via 127.0.0.1 instead.

Varinder Sandhu Mr or Mrs. 500 Points: 559 More actions · Answer 2

Dear Friend,

Once we install SQL Server it ask Instance Name ....

if you use default name ....that mean your SQL server Name = Your Machine Name

if use any specific name for your SQL Server Instance that you have try as below

Machine Name\Instance Name

Refer Below URL :

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/ff29a976-8dcc-4dde-8d1b-14e7f50e57a8/#d17960df-6e4a-4de6-a313-a0e639462156

Varinder Sandhu,
http://www.varindersandhu.in/

jagannath_podder SSC Rookie Points: 34 More actions · Answer 3

Thanks! But still could not manage to start SQL Service. I am getting the same error

TITLE: Connect to Server

------------------------------

Cannot connect to 127.0.0.1.

------------------------------

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)

Varinder Sandhu Mr or Mrs. 500 Points: 559 More actions · Answer 4

Dear Friends,

I have few question with you

Are you try to access thru network ?

Did you setup the SQL Server Client Network Utility ?

Did you try as above suggested ?

Varinder Sandhu,
http://www.varindersandhu.in/

gurunadha.dba Newbie Points: 5 More actions · Answer 5

TRY THIS,

enable named pipes and TCP/IP for Microsoft SQL Server 2005:

Click Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.

Under SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER:

Double-click the protocol name TCP/IP and set the property ENABLED to Yes.

Double-click the protocol name Named Pipes and set the property ENABLED to Yes.

restart MS SQL 2005 service, run the following commands in the command prompt

net stop mssqlserver

net start mssqlserver

---guru