问题描述
亲爱的男士,
我已经安装了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对象资源管理器中,右键单击服务器,然后单击属性".
- 在安全性"页上的服务器身份验证"下,选择新的服务器身份验证模式,然后单击确定".
- 在"SQL Server Management Studio"对话框中,单击确定"以确认重新启动SQL Server的要求.
Instructions lifted from here[^]
这篇关于如何使用"sa"在SQL Server 2005中获得登录名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!