Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot connect to SQL from terminal server session.
Message
De
07/02/2006 19:04:01
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
Cannot connect to SQL from terminal server session.
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01094505
Message ID:
01094505
Vues:
72
Computer SQL2 (Windows Server 2003 Enterprise SP1) has SQL 2005 installed.
Computer POYTS3 (Windows Server 2003 Standard SP1) has Microsoft SQL Server Management Studio installed.

I login to POYTS3 remotely using Remote Desktop Connection and start Management Studio. Trying to connect to SQL2. Getting the following error:

TITLE: Connect to Server
------------------------------
Cannot connect to SQL2.
------------------------------
ADDITIONAL INFORMATION:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

If it is because I login remotely then how to change default settings to allow remote connections?
If not then what else should I look for?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform