Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connecting to named instance through SQLCMD Expand / Collapse
Author
Message
Posted Wednesday, January 25, 2012 5:39 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 13, 2014 8:13 AM
Points: 1,588, Visits: 1,556
Hi,
I am trying to connect to a named instance instance3 using the below command from the same server.

sqlcmd -s .\instance3
But it gets connected to default instance. I am not able to connect to instance3 anyway.
Please advice.
I checked the below link
http://msdn.microsoft.com/en-us/library/ms188247.aspx


Ryan
//All our dreams can come true, if we have the courage to pursue them//
Post #1241480
Posted Wednesday, January 25, 2012 6:02 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 4,903, Visits: 8,585
Case matters. Use sqlcmd -S.\instance3 instead (uppercase s).

--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1241487
Posted Wednesday, January 25, 2012 6:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, February 13, 2014 8:13 AM
Points: 1,588, Visits: 1,556
Gianluca Sartori, thank you very much. It worked now.

Ryan
//All our dreams can come true, if we have the courage to pursue them//
Post #1241507
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse