Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Error trying to change SQL Server service

Author  Topic 

sir_sql
Starting Member

3 Posts

Posted - 2012-01-16 : 17:01:59
Hello,

I'm trying to change the logon account for SQL Server service from local to a domain account but I receive the following error:
---------------------------
WMI Provider Error
---------------------------
The parameter is incorrect. [0x80070057]
---------------------------
OK
---------------------------
I'm using SQL Server Configuration Manager. I have also tried on services.msc but the same error. I have to start the service (as it stays stopped) with the local account.
There is no other error reported on the event viewer or SQL log.
The SQL installed is 2008 R2 with SP1 installed on a Win 2008 R2 Ent Ed.

Any suggestion?

Thanks in advanced for your help!


Sir_SQL doesn't like to be in a place where he can stand

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2012-01-16 : 18:03:07
you should change the logon account through Configuration Manager and restart the services for the new account to come into effect...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2012-01-16 : 22:45:36
You will have to kill the service.Run the following in command prompt.

sc queryex sqlservicename
taskkill /PID "o/p of sc queryex"/F


After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page

sir_sql
Starting Member

3 Posts

Posted - 2012-01-17 : 11:00:15
I'm doing from Configuration Manager and this tools actually tries to restart the services. I have done manually but still the same problem.


quote:
Originally posted by dinakar

you should change the logon account through Configuration Manager and restart the services for the new account to come into effect...

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/



Sir_SQL doesn't like to be in a place where he can stand
Go to Top of Page

sir_sql
Starting Member

3 Posts

Posted - 2012-01-17 : 11:01:57
This didn't work.

quote:
Originally posted by Sachin.Nand

You will have to kill the service.Run the following in command prompt.

sc queryex sqlservicename
taskkill /PID "o/p of sc queryex"/F


After Monday and Tuesday even the calendar says W T F ....



Sir_SQL doesn't like to be in a place where he can stand
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2012-01-17 : 23:35:46
By which name is your sql service running?

After Monday and Tuesday even the calendar says W T F ....
Go to Top of Page
   

- Advertisement -