Sql server 2008 screwing with me ?? and help

SUNIL GUTTA

13y1.7k

Hi fellas

1) Well it weird problem . from last 2 days i was unable to open sqlserver ... i am trying to give right credentials but its just showing me some stupid error i.e

TITLE: Connect to Server

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

Cannot connect to (local).

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

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)

2) Well as some Google browsed pages suggested i tried to open SQL SERVER CONFIGURATION MANAGER . i am getting COULD NOT CONNECT TO WMI ??

So please help me .. feeling only option left is to re-install ??

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Accepted answer
hi ,

try this

GO START -> ALL PROGRAMS -> SQL SERVER 2008/2005/2008 R2
->CONFIGURATION TOOLS->
->SELECT SQL SERVER CONFIGURATION MANAGER
->SELECT SQL SERVER NETWORK CONFIGURATION
->SELECT PROTOCOLS FOR MSSQLSERVER(YOUR INSTANT NAME)
->IN RIGHT TASK PANEL
->MAKE SURE MENTION BELOW:

DISABLE SHARED MEMORY AND VIA
ENABLE NAMED PIPE AND TCP/IP

—-MAKE SAME THING IN
->SQL NATIVE CLIENT 10.0(SERVER VERSION) CONFIGURATION – CLIENT PROTOCOLS

RESTART SQL SERVER(MSSQLSERVER [YOUR INSTANT NAME]) SERVICE

or refer to this link

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
SUNIL GUTTA13y ago
Humm modified MOF file and finally entered into CONFIGURATION MANAGER .. BUT SQLSERVER(MSSQL SERVER ) is not starting :) oooh crap one after other .. i hate this
SUNIL GUTTA13y ago
Well TY for reply friends

The link provided states that we have to initaially open SQL SERVER CONFIGURATION .. in my above question i specified for me thos this is also not getting open .. giving me a stupid error i.e

SERVER IS UNREACHABLE , COUDNT CONNECT TO WMI PROVIDER & CLASS NOT FOUND [0X80041010] ..

oooh gosh such errors take a toll of time :(
Iftikar Hussain13y ago
Hi,
Please refer the below link

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

Regards,
Iftikar