Connecting to sql server
-
lundi 26 mars 2012 19:32
I can use Servername. or Servername\ to connect to a servername. I always thought it is just Servername.
Why can I connect to a Servername using Servername. (Servername and a dot) or Servername\(Servername and a slash)?
Toutes les réponses
-
lundi 26 mars 2012 21:32
Will have to admit these two are new to me.SERVERNAME\ is logical, since the syntax for a named instance is
SERVERNAME\INSTANCE So only SERVERNAME\ would mean the default instance.But SERVERNAME followed by a dot beats me. SERVERNAME.INSTANCE does not work.
A single dot is legal, this denotes the local instance. Maybe there is some connection.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se- Proposé comme réponse Eshani Rao mardi 27 mars 2012 05:01
- Marqué comme réponse Kalman TothMicrosoft Community Contributor, Moderator dimanche 1 avril 2012 20:51
-
mardi 27 mars 2012 00:00
Hi
You have to use SERVERNAME to connect to the default instance
if the server host a second instance or a named instance you have to use SERVERNAME\INSTANCENAME
Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/
Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you- Proposé comme réponse Eshani Rao mardi 27 mars 2012 05:01
- Marqué comme réponse Kalman TothMicrosoft Community Contributor, Moderator dimanche 1 avril 2012 20:51
.png)
