Zakaria Marrah
Zakaria Marrah

Reputation: 765

How to connect Sqlcmd to the server?

I just installed SQL Server 2008, and I wanted to use the command editor to execute queries.

To do that I opened the command prompt, and I typed

Sqlcmd -S Serverinstance

but I got an error saying:

Named Pipes Provider: Could not open a connection to SQL Server [53].
Sqlcmd : erreur : Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Sqlcmd : erreur : Microsoft SQL Server Native Client 10.0 : Login timeout expired

What should I do to get it connected to the server so I can proceed?

Upvotes: 38

Views: 87250

Answers (3)

Christian Payne
Christian Payne

Reputation: 7169

(This one is going to sounds silly) my problem was that I wasn't using capital 'S'

Eg:

C:\> SQLCMD -S localhost\sqlexpress

Upvotes: 65

marc_s
marc_s

Reputation: 755217

You need to either use the integrated-security approach of using your Windows credentials to connect to SQL Server by specifying -E as an option:

C:\> SQLCMD -S Serverinstance -E

or then you need to define a user/password set to achieve a SQL Server login:

C:\> SQLCMD -S Serverinstance -U (login in) -P (password)

All the many SQLCMD parameters are well-documented on MSDN SQL Server Books Online!

Upvotes: 13

Ciarán
Ciarán

Reputation: 3057

The server you are specifying cannot be found or is not accessible. so either the server is wrong (have you spelt it correctly) or you are not specifying it correctly or it is not accessible from your machine.

After you've got that right, you will need to specify a username/password or a -E command qualifier for a Trusted Connection. You may also need to specify the database with a -d qualifier.

You can get help by typing

Sqlcmd -?

Upvotes: 0

Related Questions