×

Loading...

Topic

This topic has been archived. It cannot be replied.
  • 工作学习 / IT技术讨论 / SQL7安装在2000server上,选用的是SQL/NT混合模式,更改NT admin密码后,SQL启动失败,就不能对其作任何设置。先改SQL启动密码好像也不对。
    请问,如何更合理地修改SQL和NT的密码?SQL7好像与2000搭配的不是很好?修改NT密码后,SQL不会自动更新用新密码启动服务?
    • Come in.
      If your SQL Service is set up to start under the NT ADmin, when you change the password for that NT Admin, you have to go to service->mssqlserver to modify the correspondent password ,otherwise your SQL Service won't be up.
    • right click you server in sql enterprices mmc, choose properties, goto security tab, make sure the service start account and its password both are correct. if you use muilt-domain, use [domain name]\[account] format
      • 多谢。我知道要修改SQL的登录密码。可你们没有发现问题?我在2000中装SQL7,更改2000的密码,再更改SQL登录密码。重新启动后,SQL报1069错误。在NT4中很容易的,现在居然成了问题。