SQL Server 2008 R2 - Invalid Parameter error when changing SQL Server Service account

Question

Hi,

Our SQL 2008 R2 server is on Windows 2008 R2.  When I tried to change the service accounts using SQL Server Configuration Manager, I always got the error "Invalid Parameter", and does not let me save the change.

However, I can change the service account using the Windows Service Snap-in and restart the service fine.  The problem is that I tend to get SSPI context error frequently.

Have anyone run into such error?  Any help is appreciated.

M.

Answer 1

Hi,

Our SQL 2008 R2 server is on Windows 2008 R2.  When I tried to change the service accounts using SQL Server Configuration Manager, I always got the error "Invalid Parameter", and does not let me save the change.

However, I can change the service account using the Windows Service Snap-in and restart the service fine.  The problem is that I tend to get SSPI context error frequently.

Have anyone run into such error?  Any help is appreciated.

M.

Answer 2

Hello,

Make sure the SQL Server box has WINS and DNS settings well configured. The SSPI context error is mostly related to a problem trying to authenticate against the AD.

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 3

Hello,

Try to not use the “Browse” button and just type the account name and password. Please see the following resources:

http://social.msdn.microsoft.com/Forums/is/sqldensetup/thread/63f68611-2905-49d4-a3ae-5b0f05608d65

https://connect.microsoft.com/SQLServer/feedback/details/680877/configuration-manager-cant-select-default-of-nt-service-mssqlserver-again

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Exact error message would help.
Are you getting below

WMI Provider Error
---------------------------
The parameter is incorrect. [0x80070057]
---------------------------
OK

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter

Answer 5

Thanks all for your help.

Yes, the exact error was:

WMI Provider Error
---------------------------
The parameter is incorrect. [0x80070057]
---------------------------

I have no problem in changing the service account to a Windows domain account or Local System.  However, if I set it to NT SERVICE\MSSQLSERVER, that's where I got the above. 

The solution suggested by Alberto works only on SQL Server 2012, but it did not work for me under Windows 2008 or Windows R2.  I've searching online, but so far I have not been able to find a work-around for it.

Any suggestion on anything else that I should try?

M.

---

Muschika

Answer 6

I got the same error when I used the SQL Server Configuration Manager to change the service account. But when I used 'Start', 'Administrative Tools', 'Services', to change the service account: no problems!

Good luck!

Answer 7

Can you try this?

Open Server manager and go to server manager->configuration->wmi controls->properties->microsoft->sql server-> security Go to advanced, uncheck the inheritance option and then checked it again and then restart the server and see if this resolves the issue.