sql server connect: SQL Express Connection Error -- sql server connect

SQL Express Connection Error

Michael
12/17/2006 3:11:01 PM

sql server connect:

I am making a local connection to an instance of SQL Express on XP SP2. I
get the following error message:

"Microsoft SQL Native Client: 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."

Despite the fact that I am not making a remote connection, I have made the
changes recommended by KB 914277 using Surface Area Configuration for
Services and Connections tool. After rebooting I am still getting the same
error.

Re: SQL Express Connection Error

Plamen Ratchev
12/17/2006 10:22:49 PM

For local connections you can check a few things:

1. Your connection string should be something like this:
"Provider=SQLNCLI;Server=<MachineName>\SQLEXPRESS;Initial
Catalog=master;Integrated Security=SSPI "
In the above <MachineName> could be ".", "(local)","localhost", or
"<localhostname>".
2. Check if the Shared Memory protocol is enabled

You can see detailed troubleshooting steps here:
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx

Regards,

Plamen Ratchev
http://www.SQLStudio.com

[quoted text, click to view]