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

| Leave a comment

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.

 

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 )

Connecting to %s

Follow

Get every new post delivered to your Inbox.