help me

Question

Post reply

help me

subbkarth

SSC-Addicted

Points: 448
More actions
September 13, 2010 at 11:56 pm

#145175

i want to create maintenance plan, but it shows the following error
TITLE: Maintenance Plan Wizard Progress
------------------------------
Create maintenance plan failed.
------------------------------
ADDITIONAL INFORMATION:
The connection type "ADO.NET:SQL" specified for connection manager "{CE5FB5CA-60FD-4932-B454-A0368F8F9A2E}" 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 "{CE5FB5CA-60FD-4932-B454-A0368F8F9A2E}" 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)
------------------------------
BUTTONS:
OK
------------------------------
plzzzzzzzzzzz help me
thankssssssss

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

What are you trying to accomplish and what are the steps you are doing to accomplish that?

When do you get this error message (at which step)?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

subbkarth SSC-Addicted Points: 448 More actions · Answer 2

subbkarth

SSC-Addicted

Points: 448

September 14, 2010 at 6:27 am

#1220620

first step of the maintenance plan gets that error.

steveb. SSC-Forever Points: 46733 More actions · Answer 3

what sort of maintainence plan are you trying to create?

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 4

steveb. (9/14/2010)
what sort of maintainence plan are you trying to create?

I wonder if that matters here. It errors on the first step of the wizard according to the OP. Any idea what would cause that?

My thinking is that maybe the OP doesn't have the privs to run the wizard so it gives a connection error. Dunno for sure, though.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

steveb. SSC-Forever Points: 46733 More actions · Answer 5

I must have missed that second post.

It does seem like a permission issue, perhaps with the account IS is running under.

What service pack are you running?

Dave Klug SSCertifiable Points: 5811 More actions · Answer 6

Is SSIS installed on the server? I remember trying to create a plan where is was not and the error was cryptic and had nothing to do with SSIS missing.

subbkarth SSC-Addicted Points: 448 More actions · Answer 7

i already installed ssis but the same problem has occured

steveb. SSC-Forever Points: 46733 More actions · Answer 8

and what service pack are you running?

I have had issues like this prior to installing SP2

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 9

There were lots of fixed in SP2, and there is a hot fix that you need post SP2 for 2005 servers. I would actually recommend SP3 for the server AND client tools.

Does this happen on other workstations for this server? Or for other servers from this workstation?

subbkarth SSC-Addicted Points: 448 More actions · Answer 10

subbkarth

SSC-Addicted

Points: 448

September 15, 2010 at 8:48 am

#1221392

sql server 2005 service pack3

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Do you get any errors in the event logs?

Is the maintenance plan being setup to run against a SQL server, or are you trying to connect it to some other db?

are you editing it directly from SSMS or did you try to create it in BIDS first? (if created in bids, i believe you won't be able to edit it from SSMS)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

chrisph Hall of Fame Points: 3701 More actions · Answer 12

One simple thing to check is what version(s) of MSSQL are you running. I've had problems saving/editing maintenance plans using the 2008 management studio with SQL Server 2005.

You could also try running the management studio directly from the server, though this is not a best practice.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

chrisph (9/15/2010)
One simple thing to check is what version(s) of MSSQL are you running. I've had problems saving/editing maintenance plans using the 2008 management studio with SQL Server 2005.
You could also try running the management studio directly from the server, though this is not a best practice.

Or run it from any different machine. Running it from the server would at least eliminate that variable. Running from another machine removes the question as to whether it is a global or local issue - or if it is an SP issue on the server.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events