Error when trying to create maintenance plans

I've an issue when trying to create maintenance plans on the management studio (new one or using the wizard)

I Received the Folowwing error:

Exception has been thrown by the target of an invocation. (mscorlib)

Additional information:

An OLE DB error 0x80004005 (Client unable to stablish connection) occurred while enumerating packages. A SQL statement issued and failed.

An OLE DB error 0x80004005 (Client unable to stablish connection) occurred while enumerating packages. A SQL statement issued and failed.

There is no service pack installed on the server.

Any help will be greatly appreciated.

Thanks in advance for the help.

Regards.

Hello Frivas,

I have a few questions that I hope will help narrow down your issue.

- Are you running SQL 2005 RTM, SP1 or SP2? I presume 2005 RTM since you said there is no service pack installed on the server, although perhaps you mean Windows service packs?

- When does the error occur? At the end of the wizard, at the end of saving the maintenance plan in the Designer UI? Or somewhere in the process?

- Does the login you're using to connect to the SQL Server have the sysadmin role, or some other roles?

- If the error dialog that comes up includes the small icon for additional details, can you please reproduce the problem and copy and paste the stack trace here?

James

|||..In addition to above I would like to know what is the reason for not having any service packs. You may know that SP2 has all the latest fixes for maintenance plans & ssis issue in this regard. http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm fyi.|||

I don't understand what is the use of these kind of replys. If you don't know the answer just shut the mouth. Looks like just writing something to increase number of posts.

Everybody working in this field know the importance of installing the service packs.