Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2003-12-24 : 09:32:46
|
| My maintenance plan keep failing since I changed the SQLSERVER and SQLAGENT login. The error is as follows:Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18456: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RESEARCH\SQLADM'.Any ideas. The new account is local admin so i cannot understnad.All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-27 : 21:07:53
|
| Have you checked to see if you have the correct password for the services?Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-12-27 : 21:30:36
|
| Check the owner of the jobs that the maintenance plan created. Change them to the appropriate user.-ec |
|
|
|
rohans
Posting Yak Master
194 Posts |
Posted - 2003-12-29 : 08:23:56
|
| I have no idea what happened over the Christmas. It seemed Santa passed thru as the jobs are now working and I have changed nothing. Any idea what I can check to find out what was causing the error. Eyechart:I check the jobs and they belonged to 'sa'.All help appreciated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-05 : 12:20:56
|
| Did you check the passwords for the SQL services? Did someone change the password back? The SQL Server Error Log will have the error, but it will probaby be the same error that you have already posted.Tara |
|
|
|
|
|
|
Failing maintenance plan