如何使用"sa"在SQL Server 2005中获得登录名 [英] How to get login in SQL server 2005 using 'sa'
问题描述
亲爱的男士，
我已经安装了Sqlserver 2005和management studio.
我可以使用Windows身份验证登录SQL Server 2005，但是即使我已经在SQL Server中启用"sa"并更改了passowrd，也无法使用"sa"登录.更改密码后，即使我也重新启动服务，但也没有用.
我注意到一件事，即使我已经更改了密码，但是一旦我重新打开SQL Server的"sa"属性，更改的密码就不存在了，但是显示的密码具有不同的(默认)字符长度.
我收到错误用户" sa登录失败.用户未与受信任的SQL Server连接相关联. Erro 18452''
感谢
Dear Gents,
I have installed Sqlserver 2005 and management studio also.
i can login in SQL server 2005 using windows authentication but i m not able to get login using ''sa'' even i have already enables ''sa'' in SQL server and changed its passowrd also. after changing password even i restarted service also but no use.
One thing i have noticed that even i have changed password but once i re-open SQL server ''sa'' properties then that changed password is not there but its showing password with different (default) length of characters.
i m getting error ''Login failed for user ''sa''. user is not associated with trusted SQL server connection. Erro 18452''
thanks
推荐答案
打开SQL Server Management Studio Express，并以具有受信任连接的本地管理员身份登录...
导航到对象浏览器"的安全性"->登录"节点，然后选择sa登录... rx单击->属性...".在状态"选项卡中，确认已设置登录为启用"属性.
open SQL Server Management Studio Express and log in as a local administrator with a trusted connection...
navigate to the Security->Logins node of the Object Browser and select the sa login... rx click-->Properties.... in the Status tab verify the Login is Enabled property has been set.
您需要确保服务器处于混合身份验证模式:
You need to ensure that the server is in Mixed Authentication Mode:
- 在SQL Server Management Studio对象资源管理器中，右键单击服务器，然后单击属性".
- 在安全性"页上的服务器身份验证"下，选择新的服务器身份验证模式，然后单击确定".
- 在"SQL Server Management Studio"对话框中，单击确定"以确认重新启动SQL Server的要求.
从此处取消的说明 [
Instructions lifted from here[^]
这篇关于如何使用"sa"在SQL Server 2005中获得登录名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
