0x851c0001 – the credentials you provided for the ‘SQLSERVERAGENT’ service is invalid.

We always install SQL Server with configuration.ini files to be sure that each and every server looks like the other. Today we received the error message:

(01) 2016-11-29 14:23:47 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.InputSettingValidationException
(01) 2016-11-29 14:23:47 Slp: Message: 
(01) 2016-11-29 14:23:47 Slp: The credentials you provided for the 'SQLSERVERAGENT' service is invalid.
(01) 2016-11-29 14:23:47 Slp: HResult : 0x851c0001
(01) 2016-11-29 14:23:47 Slp: FacilityCode : 1308 (51c)
(01) 2016-11-29 14:23:47 Slp: ErrorCode : 1 (0001)

#1 – Special characters

Sometimes it’s just this simple:
The password generator added a “&” somewhere in the password for the Service Account:

a1B2c3D&4e5F6gH

Following the Password Policy in MSDN, you will find that “&” is not on the whitelist, just

  • ! – exclamation point
  • $ – dollar sign
  • # – number sign
  • % – percent

is allowed.

#2 – Leading character

You maybe will find that even following the rule mentioned under the first heading still is not enough. Then please doublecheck if you have a leading character e.g. “a” in front of your password. SQL Server does not accept passwords beginning with an integer.

#3 – Active Directory Account locked

Even if you followed the rules mentioned under the first two headings, you still might get the error message. Then consult your domain admins and ask if your service user’s account might be locked. Let them unlock the account and try it again.

#Works4me

Happy pa$$w0rding to all of you 🙂

Thank you for reading,
CMS

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

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