使用 SA 賬號連接 SQL Server 2005 Express 提示登錄失敗,Windows 認證正常。
SQL Server Configuration Manager
→ SQL Server 服務
→ 右鍵 SQL Server (SQLEXPRESS) → 重新啟動
-- SSMS 連接
Server name: .\SQLEXPRESS
Authentication: SQL Server Authentication
Login: sa
Password: [剛設置的密碼]
Server=.\SQLEXPRESS;Database=MyDB;User ID=sa;Password=YourPass;
Server=localhost\SQLEXPRESS;Database=MyDB;User ID=sa;Password=YourPass;
Server=192.168.1.100\SQLEXPRESS;Database=MyDB;User ID=sa;Password=YourPass;
@"Server=.\SQLEXPRESS;..." 或雙反斜杠