Re: Error when connect to sql server 2005 using remote desktop

Han (Han@xxxxxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SQL server connection problem
    ... I've tried to change the user connections to 0, ... "SQL server connection time out. ... The following message appears when restart the server and before login ... I receive Error message: “A connection could not be established to ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server 2005
    ... procedure to increase the maximum number of concurrent connections. ... When you successfully connect to the instance of SQL Server 2005, ... I have an application that requires an database to be installed on the ...
    (microsoft.public.sqlserver.setup)
  • Re: TCPv4 Counters "Connetions Active" and "Connections Passive" on W2K3 IIS 6 S
    ... Active is the number of connections that are initiated by the system. ... For the SQL server some indications might be: ... values indicates that active queries are waiting for other queries. ... Also database size, queries and indexes can make huge differences. ...
    (microsoft.public.inetserver.iis)
  • Re: Not able to login in Sharepoint 3.0
    ... In Microsoft SQL Server 2000 SP4 or SQL 2005 you must allow remote connections to SQL for form based authentication to work. ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Linked Table Password
    ... Prompt When Opening Linked Table" - ... recreating the links to the SQL Server ... > relationships again after the automated process. ... These connections can be DSN or DSN-less connections, ...
    (microsoft.public.access.security)