wmi provider error 0x800742a2 :: MSSQL instance can not start

oo0yuki0oo發表於2011-11-07

the issue is appeared afer we install the wintel os VTM

and our REG dba found the DB cannot be accessed

I login the server find that the MSSQL service si shutdown

I try to startup the service with serivce account , but it show error

initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

follow the error message, I check the service account privilege on log file.

it have the full control.

hence eems the issue is not caused by filesystem privilege

check next errormessage:

wmi provider error 0x800742a2

after google i found the followgin solution

On a Windows 2008 domain controller, when you try to use SQL Server Configuration Manager to change the service account of some Microsoft SQL Server 2008 components or of the SQL Server service to a domain user account that is not a domain administrator, you receive one of the following error messages:

Error message 1

The service did not start due to a logon failure. [0x8007042d]

You receive this error message if install one or more of the following SQL Server 2008 components, and then you change the service account of the components:

  • SQL Server 2008 Analysis Services
  • SQL Server 2008 Integration Services
  • SQL Server Browser

To work around this problem, see Workaround 1.

Workaround 1

To work around this problem, add the domain user account to the corresponding domain group for the specific SQL Server component according to the following table.

Collapse this tableExpand this table
SQL Server componentCorresponding domain group
SQL Server Analysis Services (InstanceName)SQLServerMSASUser$ComputerName$InstanceName
SQL Server Integration ServicesSQLServerDTSUser$ComputerName
SQL Server BrowserSQLServer2005SQLBrowserUser$ComputerName

To do this, follow these steps:

  1. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
  2. In the Active Directory Users and Computers snap-in, click Users.
  3. Double-click the corresponding domain group.
  4. In the Properties dialog box, click the Members tab.
  5. On the Members tab, click Add.
  6. In the Select Users, Contacts, Computers, or Groups dialog box, type the user in the DomainNameUserName format under Enter the object names to select, and then click OK.
  7. In the Properties dialog box, click OK.
Error message 2
WMI Provider Error [call to WMI Provider returned error code: 0x800742a2]

You receive this error message if you upgrade a named instance of SQL Server from SQL Server 2005 to SQL Server 2008, and then you change the service account of the SQL Server service.

To work around this problem, see Workaround 2.

Workaround 2

To work around this problem, add the domain user account to the SQLServer2005MSSQLUser$ComputerName$InstanceName domain group.

To do this, follow these steps:
  1. Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
  2. In the Active Directory Users and Computers snap-in, click Users.
  3. Double-click SQLServer2005MSSQLUser$ComputerName$InstanceName.
  4. In the Properties dialog box, click the Members tab.
  5. On the Members tab, click Add.
  6. In the Select Users, Contacts, Computers, or Groups dialog box, type the user in the DomainNameUserName format under Enter the object names to select, and then click OK.
  7. In the Properties dialog box, click OK.

Seems the new guy from Wintel team change the domain group, ORZ....

SQLServer2005MSSQLUser$ComputerName$InstanceName

after I add the service account into the group , it work

I think I'd better stand by if the new guy install the VTM on PRD DB server.

T_T |||

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8337095/viewspace-1056198/,如需轉載,請註明出處,否則將追究法律責任。

相關文章