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 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 – 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?
Same issues as above, when logged in as local admin trying to add that local admin, chose a run as service account and it picked right up.
I had same issue and the problem was with the account being in sub domain where as the machine was joined on root domain. Here is the detailed description
http://kashifnizam.wordpress.com/2012/05/28/the-specified-credentials-for-the-sql-server-service-are-not-valid-to-continue-provide-a-valid-account-and-password-for-the-sql-server-service/
Hope this helps someone!
@Kashif
The link you posted is the exact same situation and solution as the original post.
SOLUTION IS : use the DOMAIN ADMIN account NOT the local admin account to install.
Thanks guys!
Thank you!
i had the same problem to I changed the account name to NT AUTHORITY\SYSTEM and the errors were gone. got the install working fine now.
Thank you Abi, I changed account name to NT AUTHORITY\SYSTEM and It works perfectly
Thanks a lot Abi, I changed account name to NT AUTHORITY\SYSTEM and It works fine to me too!
yeah..never thought that it is easy as chaging the acc to nt autority/system..
i get me 2 day to install this sql server..
plz microsoft..be more user friendly..
I ran into an issue where the service account kept changing the password ( I thought). B/c when I changed it to the known password it would run. Try checking your domain gpo or dc gpo if need be and be sure the service acct is allowed log in as service right. best j
just restart and login with ur local account that means try to login using the credentials username :example\administrator
password:xxxxxxxxxxxxxxxxxx. u will overcome with this error enjoy..
Hi
i Faced the same error. resolved by changing user name to NT AUTHORITY\SYSTEM in user name account.. and password empty as it was my case. but you have to enter your password i guess.
[…] Here’s the simple solution: http://www.jadota.com/2009/01/the-credentials-you-provided-during-sql-server-2008-install-are-invali… […]
in Server configuration portion Select AUTHORITY/SYSTEM Account name for every component for which the error apears….
I changed account name to NT AUTHORITY\SYSTEM and It works perfectly