sql 2005 server error

Question

pace59 0 Junior Poster in Training

15 Years Ago

Help Please!

I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
(Microsoft.SqlServer.MaintenancePlanTasksUI)

I am unable to create maintenance plan. I am on sp2, and applied a critical hotfix from the microsoft website. I thought maybe it was client tools, but isn't that the microsoft management studio? How about integration services....would that have anything to do with it? I am on windows xp.

Any help is greatly appreciated. What could the error above potentially effect besides the maintenance plan? I am also backing up my database through backup exec.

mssql

2 Contributors
27 Replies
172 Views
1 Day Discussion Span
Latest Post 15 Years Ago Latest Post by Ramy Mahrous

All 27 Replies

Ramy Mahrous 401 Postaholic

15 Years Ago

Integration services work fine? and check if Agent service running or not.

Ramy Mahrous 401 Postaholic

15 Years Ago

Integration services from Start->Microsoft SQL Server 2005->SQL Server Business Intelligence Development Studio try to create new Integration services project
To check Agent Service you'll find it in SQL Server Management Studio SQL Server Agent

Ramy Mahrous 401 Postaholic

15 Years Ago

OK, I don't need you to develop something with Integration service, red X because you're missing something (don't care about that right now) you didn't tell me. Does Service Agent work?
Second take a screen shot to the error, and attach it here.

Ramy Mahrous 401 Postaholic

15 Years Ago

Try to ask in Microsoft SQL Server forum there's may be a hotfix or trick..

Ramy Mahrous 401 Postaholic

15 Years Ago

From your last reply I see something like that before at http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/7e5da9e1-3520-492c-bbe1-3516f0ccecaa/

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pace59 0 Junior Poster in Training · Answer 1 · 2009-01-27T17:01:10+00:00

Is the only way to valid that integration and agent services are installed correctly or started is through the dos prompt or can it be done through the server?

I am sorry........I am new at this.

pace59 0 Junior Poster in Training · Answer 2 · 2009-01-28T00:45:54+00:00

Integration services from Start->Microsoft SQL Server 2005->SQL Server Business Intelligence Development Studio try to create new Integration services project
To check Agent Service you'll find it in SQL Server Management Studio SQL Server Agent

I did the first part...integration services the way you suggested. I was able to get in, but over on the right where it shows connections, there is a red x through the database. When I click on the connection, i get the following error..connection successfully established with the server, but error occurred during logon process(shared memory...) Help!! Please

I tried installing sp2 from remotely, should it have been done right on the server? I am desperate, in case you cannot tell.

pace59 0 Junior Poster in Training · Answer 3 · 2009-01-28T01:09:33+00:00

Ok. I went into sql server management studio and the sql server agent has the green arrow and i am able to move around and do different things. The main thing that I am concerned with right now is doing the maintenance plan. I am unable to do that. The error when trying to create maintenance plan is
TITLE: Microsoft SQL Server Management Studio
------------------------------

Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)

And....for the error on the integration services with the red x....I was only trying to create something there to test it. My maintenance plan is not working...that's where I am hurting. However the error from the x on the integration services is:

A connection was successfully established with the server, but an error occurred during logon process. (provider shared memory provider 0-no process is on the other end of the pipe

pace59 0 Junior Poster in Training · Answer 4 · 2009-01-28T01:18:44+00:00

Also.....when I do select @@version is shows 9.00.3050.00 and when I go to help it states the studio version is 9.00.1399.00.

pace59 0 Junior Poster in Training · Answer 5 · 2009-01-28T02:25:22+00:00

Please tell me that when I look at the server configuration manager that the analysis services should be running as well as everything else, meaning integration, full text, analysis, server, reporting, agent and browser services should all be running.

As if you cannot already tell....I am very new to this.

Analysis services and reporting was stopped. Could that be causing my problem?

Ramy Mahrous 401 Postaholic Featured Poster · Answer 6 · 2009-01-28T02:30:27+00:00

Analysis and Reporting doesn't mean anything, but it's important to know the cause, did you look to the URL?

pace59 0 Junior Poster in Training · Answer 7 · 2009-01-28T02:40:37+00:00

Yes. I have downloaded sp2 earlier today and still no change to the ssms (which is the client tools right)?

I am wondering: Could it be because I was doing remote desktop to the server?
or
When the file downloads, is it automatic to update or do I need to double click on the file and then setup occurs?

If so, will the options come up to choose what I want to apply sp2 to?

Ramy Mahrous 401 Postaholic Featured Poster · Answer 8 · 2009-01-28T02:43:53+00:00

Sure you must upgrade the server not the client :) read the URL content again they solved the problem.

pace59 0 Junior Poster in Training · Answer 9 · 2009-01-28T02:49:38+00:00

so i need to be actually on the server, not remote? That stinks, but if it fixes....

Ramy Mahrous 401 Postaholic Featured Poster · Answer 10 · 2009-01-28T07:05:57+00:00

Ramy Mahrous 401 Postaholic

15 Years Ago

Keep me up-to-date...

pace59 0 Junior Poster in Training · Answer 11 · 2009-01-28T18:48:35+00:00

Keep me up-to-date...

ok applied the update again........and now get the following error message...

hotfix.exe is a valid file, but just not for this type of machine.

I am using windows server 2003 r2....now what

Ramy Mahrous 401 Postaholic Featured Poster · Answer 12 · 2009-01-28T19:22:42+00:00

Ramy Mahrous 401 Postaholic

15 Years Ago

x86 or x64??

pace59 0 Junior Poster in Training · Answer 13 · 2009-01-28T19:33:03+00:00

x86 or x64??

x64

The log from the update is telling me that the only thing not being updated is the tool/workstations because it wasn't upgraded to prereq 3042. I can try the update to sp2 again?

Ramy Mahrous 401 Postaholic Featured Poster · Answer 14 · 2009-01-28T20:11:40+00:00

Ramy Mahrous 401 Postaholic

15 Years Ago

Try, be sure the SP2 is also x64

pace59 0 Junior Poster in Training · Answer 15 · 2009-01-28T20:15:29+00:00

Try, be sure the SP2 is also x64

Well maybe I didn't check the type of server correctly........can you refresh my mind.

Should I be checking the main server or the sql server......i know it sounds silly, but the sql server is on a windows 2003 r2 server. Which one would you like me to check, and how?

Ramy Mahrous 401 Postaholic Featured Poster · Answer 16 · 2009-01-28T20:27:21+00:00

Ramy Mahrous 401 Postaholic

15 Years Ago

The SQL Server. Contact the administrator.

pace59 0 Junior Poster in Training · Answer 17 · 2009-01-28T20:34:31+00:00

The SQL Server. Contact the administrator.

Ok my processor is a x86 family model etc, so I should try downloading the other file.

I know that when I tried doing the x86 sp2 it is telling me that the hotfix worked but not for this type of machine. So now what to do?

Ramy Mahrous 401 Postaholic Featured Poster · Answer 18 · 2009-01-28T20:45:27+00:00

So you need to install SP for x86, iff the server which SQL Server not client tools resides in is x86.
See SP2 help file for the instructions.

pace59 0 Junior Poster in Training · Answer 19 · 2009-01-28T20:47:17+00:00

pace59 0 Junior Poster in Training

15 Years Ago

what are client components

Ramy Mahrous 401 Postaholic Featured Poster · Answer 20 · 2009-01-28T20:52:43+00:00

Ramy Mahrous 401 Postaholic

15 Years Ago

Update SP2 on the server machine

pace59 0 Junior Poster in Training · Answer 21 · 2009-01-28T20:55:09+00:00

Update SP2 on the server machine

Oh my gosh!!!! I have to give you a huge thank You for everything you have done. I am able to create maintenance plans.

Like I said, and I am sure you can tell....I am new at this, but it just saved me a headache down the road.

Thank you you resolved my issue!!!!

Ramy Mahrous 401 Postaholic Featured Poster · Answer 22 · 2009-01-28T21:15:46+00:00

I am happy more than you because your problem solved :)
Please mark it as solved, and feel free to come here again to ask, and share your knowledge :)

sql 2005 server error

Recommended Answers Collapse Answers

All 27 Replies

Recommended Answers