how do in login to aremote sql server from command prompt

Question

question

sumit.prs5 asked Aug 8, '13

If i have server IP address, database name, user id and password..

sql-server-2008-r2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-08-08T07:41:44Z

raadee answered Aug 8, '13

First you should download and install SQLCMD (if you do not have it installed already, write SQLCMD in command prompt to verify. [Download link for SQLCMD][1] Then go to command prompt and type: sqlcmd -S ipaddress -U user -P password [Instructions on how to use SQLCMD][2] [1]: http://www.microsoft.com/en-us/download/details.aspx?id=36433 [2]: http://technet.microsoft.com/en-us/library/ms180944.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2013-08-08T09:43:18Z

Grant Fritchey answered Aug 8, '13

Most modern servers have PowerShell available. You can use that connect to SQL Server. Here's a [tip on how to manage it.][1] [1]: http://www.mssqltips.com/sqlservertip/1947/connect-to-sql-server-via-windows-powershell-with-sql-server-authentication/

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.