wmi provider error 0x800742a2 :: MSSQL instance can not start
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
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.SQL Server component | Corresponding domain group |
---|---|
SQL Server Analysis Services (InstanceName) | SQLServerMSASUser$ComputerName$InstanceName |
SQL Server Integration Services | SQLServerDTSUser$ComputerName |
SQL Server Browser | SQLServer2005SQLBrowserUser$ComputerName |
To do this, follow these steps:
- Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
- In the Active Directory Users and Computers snap-in, click Users.
- Double-click the corresponding domain group.
- In the Properties dialog box, click the Members tab.
- On the Members tab, click Add.
- 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.
- In the Properties dialog box, click OK.
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:
- Click Start, point to Administrative Tools, and then click Active Directory Users and Computers.
- In the Active Directory Users and Computers snap-in, click Users.
- Double-click SQLServer2005MSSQLUser$ComputerName$InstanceName.
- In the Properties dialog box, click the Members tab.
- On the Members tab, click Add.
- 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.
- 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- Fails to Start: PMON (ospid: nnnn): terminating the instance due to error 481AIError
- Start Study MSSQL 2005SQL
- LSNRCTL start error!Error
- Failed to start Master instance in admin modeAIAST
- Oracle dbconsole can't startOracle
- mysql can't start dues to the disk space is fullMySql
- EF:The provider did not return a ProviderManifest instanceIDE
- Extract or Replicat Fail to Start (Don't Start) With No Error MessagesAIError
- Large result cache can cause sessions to spin -instance to hangSession
- Angular 錯誤訊息:ERROR Error NullInjectorError No provider for XXAngularErrorNullIDE
- "alter system kill session" can crash the instance if IO slaves usedSession
- 【MySQL】ERROR 1093 You canMySqlError
- Error: The action can not be performed because ...could not be locked?ErrorORM
- CRS can not Start After Node Reboot (文件 ID 733260.1)boot
- MySQL不能啟動 Can't start server : Bind on unix sockeMySqlServer
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- wireshark error: There are no interfaces on which a capture can be done.ErrorAPT
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- Angular 依賴注入錯誤訊息:ERROR Error NullInjectorError No provider for XXAngular依賴注入ErrorNullIDE
- RAC Instance Crashes During Startup Due To Error 495Error
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- 【RAC】PMON: terminating the instance due to error 481Error
- android studio Error:Unable to start the daemon process【轉】AndroidError
- MYSQL ERROR 2003 (HY000) CanMySqlError
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- Error: The action can not be performed because the selected records are not eligibleErrorORM
- mysql can't connect error about privilege----not root userMySqlError
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- Can't debug c++ project because unable to static library start program *.libC++Project
- 緊急 - InvalidOperationException: Internal .Net Framework Data Provider error 30ExceptionFrameworkIDEError
- ?Error: Can't locate /etc/centreon/conf.pm in @INC (@INError
- error:'Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(2)'ErrorMySqlServer
- SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]SQLServerIDE
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython