>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

The 'No such host is known' part sounds like you are having DNS issues. Are you trying to connect by IP address or host name? I suggest trying IP address first.

You may also have a firewall issue. Make sure the firewall on the SQL server is allowing TCP port 1433 to pass both ways.