>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?
SQL Server 2005 by default refuses remote connections.
Go into the SQL Server Surface Area Configuration tool (that is in the SQL Server 2005/Configuration Tools off the Start menu) and you can change it.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________