CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Kyrgyzstan
    Posts
    181

    Question SQL Server problem

    I have a domain
    SQL Server installed on the server
    and I have the following problem:
    Every time I change the domain admin password the SQL Server Service fails to start, and I need to reinstall the SQL Server.
    how to solve this?

    thanx.

  2. #2
    Join Date
    Apr 2003
    Location
    Hayes, VA
    Posts
    15

    Hope this helps......

    I got this from the MSDN library. Let me know if you need more info on it.

    When using Windows NT integrated security with SQL Server, the SQL Server login information must be identical to the Windows NT account information. Therefore, if you change the Windows NT password of the domain account that the SQL Server is logged on with, then you also must update the password in the following SQL Server services: MSSQLServer, SQLServerAgent, MSDTC, and the MODTBAD Office Developer DCOM component.

    If you change a password, it must be updated on the server, the developer workstation, and the client computers. If the password is not updated for the SQL Server Agent, Access Workflow Designer cannot start and stop the agent automatically. Access Workflow Designer also uses the agent to manage time-out events for team solutions, so it is critical this service be set up properly.

  3. #3
    Join Date
    Dec 2002
    Location
    Kyrgyzstan
    Posts
    181

    Re: Hope this helps......

    Thanx.
    I got it.
    Best regards
    Exceter.

  4. #4
    Join Date
    Jan 2003
    Location
    North Carolina
    Posts
    309
    If you SQL Server service setup to run under the Domain Admin as opposed to Local System account (which is the normal way) Then you need to open the services Control Panel and find the MS Sql Server then open the service properties and on the Logon tab set the correct password you just changed to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured