Remote connection to SQL Express

[drallabs]

I have attempted to remotely connect to a SQL Express database server via SQL Server Enterpricse Management Studio using windows authentication but I get the following error message:

"an error has occured while establishing to the server. When connection to SQL Server 2005 this failuer may be caused bu the fact 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)(MS SQL Server, error:2)"

I checked the default settings of the remote Express databaes server and the setting permit remote connections, we dont use a fire wall and the browser settings are set to automatic. Is there any additional info I need in order to get this connection established?

Thanks, in advance, for any help.

 

[fxthoth]

Do you have enabled TCP/IP in configuration SQL server? Are you sure port 1433 is not blocked and service is running?

 

[NeoGreen]

I was under the impression that SQL Express only allowed local client computer to connect. But I found this online, I am going to try it to see if it works.

http://start-coding.blogspot.com/2007/11/make-remote-connection-for-ms-sql.html

 

[drallabs]

Yes I have checked the TCP/IP, the firewall is disabled, the service is running and browsing has been enabled.