Hi Guys, How to connect ms sql server from cmd for default,named instance in windows authentication ,sql authentication.

1 year ago 1 Replies

Kris Kris 6 years ago

Hi Guys,
How to connect ms sql server from cmd for default,named instance in windows authentication ,sql authentication.
pls provide syntax separately.Tq All

3 Likes

Replies

Mohsin Khan 6 years ago

Syntax can be found here: and here: https://docs.microsoft.com/en-us/sql/relational-databases/scripting/sqlcmd-use-the-utility https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility

1 Like

Relate Discussions

• but the problem is when I tried to do the Udl test throwing DBNETLIB open connection open. 1 Replies

• Hi All, SQL clustered instance is not connecting through DAC neither from SSMS nor from cmd, 3 Replies

• I am using SQLCMD to connect SQL server which no SQL DBA having access. 9 Replies

• Hi All, Connect SQL server named instance without specifying port number. 16 Replies

• I am trying to connect the SQL server default instance of machine2 from machine1 through the SQL odbc tool.i can not access the SQL with using server name as ip address. 3 Replies

• I am able to access all instace on VM ware but not able to connect when tried to login. 18 Replies

• Now how can i make these two things get installed?. 11 Replies

• My issue is with Always on AG instance--> Whenever I'm trying to connect through Listener, it is connecting to Logshipping instance instead of AG databases. 13 Replies

• Hi experts, I'm trying to add new Windows authentication user on sql server 2008 r2. 22 Replies

• Hi Dba's pls help us on the below question 1)Login failed. 1 Replies