Can't setup a domain account for SQL Server service

  • Hi,

    I've installed SQL Server 2005 RTM version using local system account for SQL Server services. Later I've reconfigured it to use domain account for both SQL Server services and SQL Agent Service (separate accounts)

    After this I've tried to install SP3, but could not until I've setup SQL Server server to run under local system account. Since then, I can't make it work under a domain account, getting the below messages.

    Any ideas?

    Thanks.

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 15466

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    An error occurred during decryption.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 6a 3c 00 00 10 00 00 00 j<......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 07 00 00 00 5.......

    0028: 6d 00 61 00 73 00 74 00 m.a.s.t.

    0030: 65 00 72 00 00 00 e.r...

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 17190

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    FallBack certificate initialization failed with error code: 1.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 26 43 00 00 10 00 00 00 &C......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

    Event Type: Information

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 26017

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: a1 65 00 00 0a 00 00 00 ¡e......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 17182

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    TDSSNIClient initialization failed with error 0x80092004, status code 0x80.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 1e 43 00 00 10 00 00 00 .C......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 17182

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    TDSSNIClient initialization failed with error 0x80092004, status code 0x1.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 1e 43 00 00 10 00 00 00 .C......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 17826

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: a2 45 00 00 12 00 00 00 ¢E......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

    Event Type: Error

    Event Source: MSSQLSERVER

    Event Category: (2)

    Event ID: 17120

    Date: 8/31/2010

    Time: 10:49:22 PM

    User: N/A

    Computer: IP-0A3D0005

    Description:

    SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: e0 42 00 00 10 00 00 00 àB......

    0008: 0c 00 00 00 49 00 50 00 ....I.P.

    0010: 2d 00 30 00 41 00 33 00 -.0.A.3.

    0018: 44 00 30 00 30 00 30 00 D.0.0.0.

    0020: 35 00 00 00 00 00 00 00 5.......

  • Was the service account changed through Services rather than through SQL Server Configuration Manager? If so that's probably the cause of the problem. Search BOL for Service Master Key for an explanation of why. The ALTER SERVICE MASTER KEY syntax should help you sort things out.

    Cheers,

    Cath

  • Ran this:

    ALTER SERVICE MASTER KEY REGENERATE

    Changed the service account to the domain account using SQL Server configuration tool, but the SQL Server service would not start.

    Any ideas?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply