Monday, March 12, 2012

Error when connect to sql server 2005 using remote desktop

Hi all,
I am trying to connect to SQL Server 2005 from my computer using Remote
Desktop but keep getting this 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: SQL Network Interfaces, error: 28 - Server doesn't support
requested protocol) (Microsoft SQL Server, Error: -1)"
I checked the server settings, and it is allow remote connections. Anything
that I missed here?
Thank a lot in advance for any help.
Han,Han
Check if SQL Server Browser is running
"Han" <Han@.discussions.microsoft.com> wrote in message
news:4434BDA9-305C-49A5-813D-C42C0EEAF82B@.microsoft.com...
> Hi all,
> I am trying to connect to SQL Server 2005 from my computer using Remote
> Desktop but keep getting this 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: SQL Network Interfaces, error: 28 - Server doesn't support
> requested protocol) (Microsoft SQL Server, Error: -1)"
> I checked the server settings, and it is allow remote connections.
> Anything
> that I missed here?
> Thank a lot in advance for any help.
> Han,
>
>|||Hi Uri,
I checked, it is running.
Han,
"Uri Dimant" wrote:

> Han
> Check if SQL Server Browser is running
> "Han" <Han@.discussions.microsoft.com> wrote in message
> news:4434BDA9-305C-49A5-813D-C42C0EEAF82B@.microsoft.com...
>
>|||Han (Han@.discussions.microsoft.com) writes:
> I am trying to connect to SQL Server 2005 from my computer using Remote
> Desktop but keep getting this 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: SQL Network Interfaces, error: 28 - Server
> doesn't support requested protocol) (Microsoft SQL Server, Error: -1)"
> I checked the server settings, and it is allow remote connections.
> Anything that I missed here?
Is the server running?
Do you specify the correct instance name?
Also, it could help if you could clarify the machines involved here. You
said that you are using Remote Desktop. That is, you do not run Mgmt
Studio or whatever you are trying to connect with from your own computer?
Is SQL Server running on the machine you connect to with Remote Desktop,
or is it on a third machine?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment