January 27, 2009 at 1:22 pm
ok. I am a dummy at this stuff. Can someone please help me? i am not able to do maintenance plans on sql server 2005. my version is 9.0.305 when I do select @@version. But when I do help the version comes up as 9.0.1399. However, I did notice in the services that the analysis services is not started. Please tell me that I am a big dummy and that should have been started, then applied sp2 and all would be well. Or ??
I am desperate at this point.
January 27, 2009 at 2:09 pm
What error did you see when you tried to create a maintenance plan?
How did you try to create the plan?
January 27, 2009 at 2:24 pm
If you are on version 9.0.1399 (which is RTM) you need to have integration services installed an running to create maintenance plans. If you upgrade your server to Service pack 2 or higher you do not need Integration services. My recommendation would be to update to at least SP2 barring any restriction from vendor application.
January 27, 2009 at 2:55 pm
Make sure you update both your server and client tools to the same level as well. Different levels should cause issues.
January 27, 2009 at 3:48 pm
The error I received when I tried to create a maintenance plan was
TITLE: Microsoft SQL Server Management Studio
------------------------------
Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI)
So my questions are:
1. the integration services....isn't that the business intelligence development
2. i should be doing the download directly on the server and not from a remote desktop connection
3. once the download completes, do i have to do a setup or is it automatic once the download is finished.
4. what are the client tools (just to make sure i haven't completely lost my mind)
I am not understanding why the sp2 is not working for everything only the server. I think i probably need to click on an exe once the download completes?
Please help....i'm desperate.
January 28, 2009 at 7:55 am
1. the integration services....isn't that the business intelligence development
Analysis services is business intelligence, integration services is for ETL(Extract,Transform,Load) which can be used for BI but is not exclusive to BI.
2. i should be doing the download directly on the server and not from a remote desktop connection
you can download the file from anywhere you like but you will have to copy the downloaded file to the server that SQL Server is installed on and run on that server.
http://msdn.microsoft.com/en-us/library/aa545440.aspx
3. once the download completes, do i have to do a setup or is it automatic once the download is finished.
see URL provided above
4. what are the client tools (just to make sure i haven't completely lost my mind)
Client tools are SQL Server Management Studio.
January 28, 2009 at 8:43 am
In SQL Server 2005 and 2008 Integration Services and the SQL Server Agent are disabled by default so go to configuration manager and right click and enable the services both services. The reason most tasks in Integration services uses the SQL Server Agent so it is good to run both services.
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply