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

osql unable to connect to default instance when explicitly stated Expand / Collapse
Author
Message
Posted Friday, October 12, 2007 8:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 2:36 AM
Points: 7, Visits: 27
When connecting to the default instance using osql on the server :
1. this works
osql -S localhost -U sa -P password
2. this fails
osql -S localhost\mssqlserver -U sa -P password
([DBNETLIB]Sql server does not exist or access denied

In practice I can miss out the -S setting but I wonder what I'm doing wrong as regards specifying the instance.

Ewan
Post #410033
Posted Friday, October 12, 2007 8:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 9:50 AM
Points: 5,367, Visits: 9,913
Ewan

Are you saying you have two instances on the same computer: a default instance and a named instance called mssqlserver?

John
Post #410042
Posted Friday, October 12, 2007 9:27 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:16 AM
Points: 1,626, Visits: 478
Ewan,

The default instance of SQL Server is always referred to as the server name, not server\service (localhost\mssqlserver). You can also refer to it by network name. Only named instances are referred to by servername\instancename.

Hope this helps.
Post #410075
Posted Thursday, October 18, 2007 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 2:36 AM
Points: 7, Visits: 27
John
Apologies in delay in getting back. No, I only have the 1 instance. I assumed that the syntax should be the same for the default as for other instance but this does not appear to be the case - see post from Rich.
Thanks for response.
Ewan
Post #412312
Posted Thursday, October 18, 2007 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 2:36 AM
Points: 7, Visits: 27
Rich
Thanks for the answer.
Ewan
Post #412314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse