SQL Server (MSSQL) client Tools two command-line logon methods for logging into the database

After we have installed the SQL Server servers and the server client tools, you can log in to the database using two command-line methods:

>sqlwb-s servername or Ip-e #使用当前windows系统的账户登录sqlserver服务器

Such as:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/79/68/wKiom1aQfTaT1dS7AADo5sJ4YSk344.png "style=" float: none; "title=" QQ picture 20160109112137.png "alt=" Wkiom1aqftat1ds7aado5sj4ysk344.png "/>

>sqlwb-s servername or ip-u username-p password #使用数据库账户和密码登录sqlserver服务器

Such as:

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/79/68/wKiom1aQfTeDAUdRAAD7Fy0Va9Q974.png "title=" QQ picture 20160109112243.png "style=" Float:none; "alt=" Wkiom1aqftedaudraad7fy0va9q974.png "/>

PS: After installing the SQL Server database, the default SA account cannot log on, and the database service configuration needs to be adjusted. If you do not know the configuration, you can find the way on the Internet (online information is very miscellaneous); I will also publish my configuration in a later blog.

This article is from "Love the Pig" blog, please be sure to keep this source http://ifconfig007.blog.51cto.com/11026101/1733186

SQL Server (MSSQL) client Tools two command-line logon methods for logging into the database