Password mismatch error for 'sa' when executing maintenance plans


In our server fleet we use a mixture of SQL 2005 and SQL 2008. All our SQL 2005 servers have always used maintenance plans from an MSX server and they run fine. We are now trying to set up a SQL 2008 MSX for the SQL 2008 servers to connect to.

Rather than set up a new server for this, we installed an additional SQL 2008 instance on the same server that has the 2005 MSX instance and set it up as an MSX.

I can join the 2008 servers to the 2008 MSX instance with no problems. I have created maintenance plans on the 2008 MSX and pushed them to the 2008 servers. However, when I try to execute any maintenance plan, I get:

Job 'xxxxx Primary Backup.Subplan_1 (Multi-Server)' failed. (SqlManagerUI)

I checked the SQL Server Logs and I have the following:

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: local machine] Error: 18456, Severity: 14, State: 8.

State 8 means a password mismatch, but I don't see how this is possible. We use the same sa password for our entire server fleet. In fact, I don't even know where in the maintenance plan you would type the sa password. I've created numerous maintenance plans before both using the wizard and manually and have never had to enter the sa password. I'm also able to log into SSMS using the sa login with no problems. Just to double check, I have retyped the sa password on both MSX and TSX.

The MSX server instances are 32-bit, whilst the TSX is 64-bit. All SQL databases are installed using Mixed Mode. We use the same domain service account for all 'SQL Server' and 'SQL Server Agent' services.

Any help with this one would be greatly appreciated.

more ▼

asked Mar 24, 2010 at 04:51 AM in Default

avatar image

1 2 2 2

Anyone have any ideas? I have completely reinstalled SQL 2008 on the MSX server and reconfigured everything, but ran into the same problem.

Mar 25, 2010 at 02:16 AM SQL_noob
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Me too, ever figure out what it was? It's only happening on my two MSX's.

more ▼

answered Aug 22, 2012 at 06:54 PM

avatar image

12 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 24, 2010 at 04:51 AM

Seen: 3863 times

Last Updated: Aug 22, 2012 at 06:54 PM

Copyright 2018 Redgate Software. Privacy Policy