This has probably been answered before, but...
I have a local SQL Server 2005 instance running, and I would like to
have another user on my network connect to this instance. However,
when he tries to connect, he always receives the same error message:
"An error has occured 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
doesnt' support requested protocol)"
So, I checked the properties for the server, and under the connections
tab the allow remote connection box is checked.
Any clue where to look next?
Thanks In Advance
chris.teter@.gmail.com wrote:
> This has probably been answered before, but...
> I have a local SQL Server 2005 instance running, and I would like to
> have another user on my network connect to this instance. However,
> when he tries to connect, he always receives the same error message:
> "An error has occured 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
> doesnt' support requested protocol)"
> So, I checked the properties for the server, and under the connections
> tab the allow remote connection box is checked.
> Any clue where to look next?
> Thanks In Advance
>
is tcp and/or named pipes enabled - they are disabled by default
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment