SQL Server 18452登录错误

 SQL Server 18452登录错误 SQL Server 18452登录错误 无法连接到服务器   服务器：消息18452，   级别16，状态1   [Microsoft][ODBC   SQL   Server   Driver][SQL   Server]用户‘sa’登陆失败。原因：未与信任SQL   Server连接相关联    该错误产生的原因是由于SQL   Server使用了"仅   Windows"的身份验证方式，因此用户无法使用SQL   Server的登录帐户（例如   sa )进行连接，解决方法如下       设置允许SQL   Server身份登录   (基本上这个很有用)  操作步骤：   1。在企业管理器中，展开"SQL   Server组"，鼠标右键点击SQL   Server服务器的名称      2。选择"属性"      3。再选择"安全性"选项卡      4。在"身份验证"下，选择"SQL   Server和   Windows"  5。确定,并重新启动SQL   Server服务。   

 Microsoft SQL Server Error 18452: Login failed ... not associated with a trusted SQL server connection Microsoft SQL Server 2005中改变登录方式和2000中几乎一样，只是Management Studio和以前的EM界面有一些区别：

Microsoft SQL Server 2000:

Open The SQL Server Enterprise ManagerStart menu > Programs > Microsoft SQL Server > Enterprise Manager) Expand the tree-control until you can your server Right click on the server name and "SQL Server Properties (Configure)" window will open Select the Security tab For "Authentication", select "SQL Server and Windows"

Microsoft SQL Server 2005:

1. Open the SQL Server Management Studio

2. Right click on the server name and select "Properties", the "Server Properties" window will open

3. Select the Security tab

4. For "Server authentication", select "SQL Server and Windows authentication mode"

注意要启用用户：

1. Open the SQL Server Management Studio

2. Select Security -> Logins

3. Right click user name and select "Properties", the "Login Properties - username" window will open

4. Click the Status tab

5. For "Permission to contect to database engine", select "Grant"

6. For "Login", select "Enabled" and "OK"最后Restart实例.