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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 mainten plans won't work after changing sys passwo

Author  Topic 

hespinoza
Starting Member

5 Posts

Posted - 2009-09-17 : 09:43:38
I changed the Administrator's password and after this the maintenance plans stopped working. I deleted them and tried to generating them again but I'm getting an error. I have to backup my dbs manually which it's ok for now. But how do I fix this problem? Any ideas?

Here's the error message that is in the log:

"The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-09-17 : 21:44:33
Is your service packs upto date? Check this:

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15459.aspx
Go to Top of Page

hespinoza
Starting Member

5 Posts

Posted - 2009-09-21 : 09:25:07
No, we do not have the latest service pack 3 and I'm kind of nervous about installing it because according to the documentation once installed and you wish to remove it you have to start pretty much start all over again.

Also, I would like to read more about what is "Crypto\RSA" any suggestion on where I can read about it before I delete them? What they for?

Go to Top of Page
   

- Advertisement -