Getting Exception While Creating Management Plan

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

SSIS and Import/Export (2005)

Getting Exception While Creating Management Plan

Author

Topic

raaz
Starting Member

1 Post

Posted - 2007-08-01 : 01:28:17

Getting error while creating a management plan

Creating maintenance plan "MaintenancePlan" (Error)

Messages

Create maintenance plan failed.

------------------------------
ADDITIONAL INFORMATION:

The connection type "ADO.NET:SQL" specified for connection manager "{2E6B9A84-F728-409D-8F0A-0159956C54AD}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(MaintenancePlan)

------------------------------

The connection type "ADO.NET:SQL" specified for connection manager "{2E6B9A84-F728-409D-8F0A-0159956C54AD}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(MaintenancePla

Can Any body help on this?

Thanks In Advance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-01 : 11:42:29

On which step? What do you have in the plan? How did you set connections? What's sql edition and sp level?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources