all groups > sql server programming > september 2006 >
You're in the

sql server programming

group:

SQL instance


SQL instance Wasim
9/30/2006 11:56:02 AM
sql server programming:
I am trying to connect my laptopname,which has various SQL server 2005
databases on it by using Query Analyzer & Mgt. Studio but it gives me an
error as follws:

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) (.Net SqlClient Data Provider)"

but when i am trying to connect my laptopname\instancename ,it works.How
can i connect to laptopname instead of providing instance name ?

Please advice me in this issue.
Wasim
Re: SQL instance oj
9/30/2006 1:10:55 PM
This is by design. When you provide only the servername, you're connecting
to a default instance which is not the same as a named instance. You will
have to provide the instance name if you want to connect to a named
instance.

--
-oj



[quoted text, click to view]

Re: SQL instance Wasim
9/30/2006 2:30:01 PM
Hi,oj,

I am not able to connect at all by providing servername only & getting
this error.Yeas i can able to connect with servername\instancename.

Wasim

[quoted text, click to view]
Re: SQL instance oj
9/30/2006 8:56:12 PM
Wasim,

You shouldn't be able to connect to a named instance with just the
servername. You _have_ to provide both servername & instancename. This is by
design.

--
-oj



[quoted text, click to view]

AddThis Social Bookmark Button