sql server
1) SQL Server Management Studio
Security-->Logins, 新建或查看user时,注意user的General里的authentication,必须是SQL Server authentication
2) SQL Server Management Studio
点击 左边面板的Object Explorer的根目录,选择属性,查看Security,必须选中SQL Server and Windows Authentication Mode
3) SQL Server Configuration Manager
(Menu: Microsoft SQL Server 2005-->Configuration Tools)
click: SQL Server 2005 Network Configuration-->Protocols for MSSQLSERVER
enable TCP/IP, 在TCP/IP属性中,enable 127.0.0.1 和 1433端口
1) SQL Server Management Studio
Security-->Logins, 新建或查看user时,注意user的General里的authentication,必须是SQL Server authentication
2) SQL Server Management Studio
点击 左边面板的Object Explorer的根目录,选择属性,查看Security,必须选中SQL Server and Windows Authentication Mode
3) SQL Server Configuration Manager
(Menu: Microsoft SQL Server 2005-->Configuration Tools)
click: SQL Server 2005 Network Configuration-->Protocols for MSSQLSERVER
enable TCP/IP, 在TCP/IP属性中,enable 127.0.0.1 和 1433端口