>I have installed SQL 2005 Express on the server. When I try to connect from my workstation, I get:
>
>
>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: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)
>
>
>Can someone shed some light please?
Kevin,
Most likely you have a wrong connection string (even spaces around = matter) or it may be that your server is not really configured to be accessed from a remote location and firewall settigns are not done.
Check this:
http://support.microsoft.com/kb/914277Cetin