jump to navigation

M$ SQL 2005 Express trouble shooting September 10, 2007

Posted by TSAI HONG-BIN in Diary.

Well, there is a Chinese idiom says, “重做馮婦.” It means one goes back to do something, usually low, that he was good at.

I picked up M$-series (vs 2005, mssql 2005 … blah, blah) again to help create a website, and suffered from the unfriendliness of M$SQL 2005 Express. I saw this.

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)

Dude, can you figure out what to do next to fix this?? Geeh, you always have to read between the lines especially when it comes from M$.

Most of times, this err implies that “your sql server does not accept network login.” Please go to

Start –> All Programs –> Microsoft SQL Server 2005 –> Configuration Tools –> SQL Server Configuration Manager

and you’ll see this window:

SQL Config Manager

Plz check out the

SQL Server 2005 Network Configuration –> Protocol for SQLEXPRESS

On the right side, you should see “Named Pipes” “TCP/IP” and “VIA” disabled. Please double-click to open and enable them.

While configuring TCP/IP properties, please take a close look at its IP Addresses tab


You should fill in 1433 (default) or whatever you assigned to your sql server at IPAll->TCP Dynamic Ports.

Now restart sql service and see if you need to come back to me ;).

If you need more log to know what’s going on, plz do not use “SQL Server Management Studio Express,” becuase it does not work at all. Go to

C:\program files\microsoft sql server\mssql.1\mssql\log\ERRORLOG

and use your favorite text editor/viewer to see what it has to say about itself. good luck.



No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: