Hi

I have set up a remote SQL 2005 express on a windows 2003 server, it all seems to be working fine locally but if I try to connect to it remotely I get the following error.

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: TCP Provider, error: 0 - No such host is known.) 
(Microsoft SQL Server, Error: 11001)

I have set it to local and remote connections

TIA

Stuart