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.
| Author |
Topic |
|
keaian
Starting Member
7 Posts |
 Posted - 2007-11-16 : 10:57:15
|
| when i right click to create a new maintenance plan. (no maintenance plans exist yet). I get this error. The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server Component that is not installed on the remote computer. To Proceed, install SQL Server 2005 Management Tools on the remote computer and try again.What am i missing. |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 11:05:57
|
| did you follow the error advice "install SQL Server 2005 Management Tools on the remote computer and try again"? |
 |
|
|
keaian
Starting Member
7 Posts |
Posted - 2007-11-16 : 11:18:01
|
| yes.. it is installed. |
|
|
|
keaian
Starting Member
7 Posts |
Posted - 2007-11-16 : 11:26:54
|
| double checking myself here. I go to add/remove. Click the SQL Server 2005. Went to change and then selected workstation components. Everything there is installed except for the Documentation, Sample data and such. I see the managment tools installed under the client components. Do you think it might be a bugged install? Should i remove it and reinstall and re-service pack? |
|
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 11:33:03
|
| you are logged into the sql server locally? if so, launch SSMS and right click maintenance plans and choose maintenance plan wizard, then what happens? |
|
|
|
keaian
Starting Member
7 Posts |
Posted - 2007-11-16 : 11:36:44
|
| yes, i am logged in locally on the server. when i launch SSMS and go to add a maintenance plan that's when the error happens. |
|
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 11:50:29
|
| it does sound like you want to reapply your latest service pack. if it is not production machine, that would be the next step. |
|
|
|
keaian
Starting Member
7 Posts |
Posted - 2007-11-16 : 11:59:05
|
| yup.. that did it. I was able to take the server offline for 10 minutes while i applied the update. Works now. Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:48:20
|
| Prior to sql2k5 sp1, you need ssis installed to create maintenance plan. |
|
|
|
|
|
|
Creating new database maintenance plan