The credentials you provided during SQL Server 2008 install are invalid.
Filed Under (SQL Server 2008) by Just An Admin on 31-01-2009
When installing SQL Server 2008 you are at one point asked to provide the service accounts and passwords for the SQL services and agents. When providing these service accounts and passwords you might encounter one of the following error messages, which prevents you from continuing the installation:
- 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 don’t know if this is a common problem, but it seems that logging on as the Local Administrator is the root cause for these errors, at least in my case. Logging on as domain admin, not a local admin and i could enter the service accounts with passwords and continue the install without any problem.
Incoming search terms:
- - the credentials you provided for the sql server agent service are invalid - the credentials you provided for the sql - the specified credentials for the sql server service are not valid - the credentials you provided for the sql server agent - 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 service are not valid - The specified credentials for the SQL Server service are not valid To continue provide a valid account and password for the SQL Server service - The specified credentials that were provided for the SQL Server service are not valid To continue provide a valid account and password for the SQL Server service
Also, one way to get arount this so that you dont have to start the process over is to just set the local administrator account to the service account and then change the service account after the install.
-Mike
I just had the same error trying to install SQL 2008 R2, changed from domain account to local admin and it worked.
Thanks.
How do you logon as domain admin? I only see an administrators group for my machine. What is a service account?
thanks it works
if you are building a cluster you are required to use domain accounts. i am trying to add a node to the cluster and am getting this error. SQL Agent is blank and greyed out, but is requiring a password. it fails b/c it doesnt know what account to use. Any ideas on how to fix?
The accounts used for the services have to be allowed to run as a service, run rsop.mscand look at
“computer config > windows settings > security settings > local policies > user rights assignment” go to policy “log on as a service” and add the accounts/group here.
If you cannot edit the local policy it´s probably because your server is in a domain and this is set by a GPO and then you will have to edit it or add a new GPO to override this setting.
I’m running XP pro on my home PC, so I have no domain (I assume my wireless-broadband ISP doesn’t count – anyway, I don’t have any domain options when I log in on my PC). “Log on as a service” shows as “not defined”. How can I “define” this option?
Also not sure what “Mike” was trying to convey – would that be to set SQL up under the admin account, or give the “service account” (which one?) admin privileges?
I had the same problem even though the credential I provided for all services was valid. The user I was running the installer as was a local administrator. Fixed the problem by rebooting the server and restarting the installation.
I also had the same problem with the credentials. The problem was solved by rebooting the machine and running the setup again.
I’m having the same issue. I have installed Active Directory Domain Services, and logged in as the domain admin (webserver/administrator), but I’m still getting the not valid credential message. What went wrong?