Kashif Nizam Qureshi

The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service

2 Comments

Alright, the other day I was installing SQL Server 2008 R2 (same problem occurred in 2008 as well), when I reached the point Server Configuration and supplied Service Account’s account name and password, I encountered the following errors for both SQL Server and Agent service.

  • The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service
  • The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service

I tried all the solutions available and none worked for me. For instance, changing the password to complex etc.

Solution:

The problem was, the machine on which I was installing SQL Server was joined to the root domain (xxx.gov) and the user accounts I was using to install SQL Server was created on sub.xxx.gov. I don’t know what can be done to use those accounts but soon after creating an account on the root with the same permission, eureka! it worked flawlessly.

 

2 thoughts on “The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service

  1. Well I have been battling to understand why, when at the Account section of the installation of a second node, the system will not accept the password I used to log in. I have been scratching my head – reading every post under the sun all to no avail.

    I did notice that some service accounts were given as service.instname.instno@FDNdomain.com and others were given as DOMAIN\service.instname.instno (the latter being the Win2000 version)

    I also noticed comments about strength of password so I thought – I can do that so I changed the password to a much higher strength and RDC in to the server – with new password and thought – best to update the services on the existing node first. I stopped the service, clicked on password and pasted in from the clipboard – (can’t go wrong eh?) ha ha says Windows.. Got ya.. it wouldn’t accept the password – that I just logged in with. I clicked on browse to select the service account and VOILA! the account name changed to the DOMAIN\user version and readily accepted the password. I then repeated the exercise on the other service. I then found that the node installation would continue (after backing up and forward through the process) to pick up the new name format and accepted the passwords without complaint.

    WHY WHY miss Windows WHY ?????

    I hope my experience saves someone else the pain I went through.

    Still Confused

  2. @confused searched entire world and yes your fix helped me to solve the problem…… thanks a lot

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.