MSSQL 設定伺服器進行 SQL 驗證。使用使用者名稱和密碼登入 MSSQL

In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select Properties. On the Security page, under Server authentication, select ‘SQL and Windows authentication mode’, and then select OK. You have to restart the server.

You can try to access the Database from command line with:

sqlcmd -S server -d database -U username -P password

例子:

sqlcmd -S SQLEXPRESS -d OFFICE_DB -U vs4 -P 123456qAz!

发表回复