ql server does not allow remote connections

hi,

sql server 2005 express is installed on comp1. my client application is installed on comp2 and comp3. all comps have win xp. when i run my application, it can't connect to sql server express. i got the following message:

an error has occured while establishing a connection to the server. when connecting to sql server 2005, the failure may be caused by the fact that under the default settings sql server does not allow remote connections. (provider: sql network interfaces, error 26 - error locating server/instance specified)

so, how can i solve this problem, to connect to the server?

hi,

SQLExpress installs by default disabling network protocols so that only local connections are available..

you have to run the SQL Server Surface Area Configuration (for services and connections) and enable remote connections..

then run SQL Server Configuration Manager and, in the SQL Server 2005 Network Configuration, enable the desired/required protocol(s) for the instance you are interested with...

additionally, you have to configure firewall exceptions on the pc hosting SQLExpress..

regards

|||

These articles will help walk you through Andrea's suggestions:

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||thanx a lot both !