Error when saving a Maintenance Plan via wizard 1

[stla]

Good day,

I have successfully activated the agent,started the wizard and planned my strategy (Full back up of database every weekday).

All went well until I wanted to save the maintenance plan; the wizard accepted all of my entries but failed when trying to save the plan.

I have checked all my entries going as far as to accept the suggested values and paths from the wizard to no avail.

The wizard informs me that there is an error when saving.

I have appended (and translated) the text below.

Any ideas where I might be going wrong?

Best regards

===================================

Fehler beim Speichern des Wartungsplanes.
(Error when saving the maintenance plan.)

===================================

Mindestens ein Argument ist ungültig.
(At least one argument is invalid.)


------------------------------
Speicherort des Programms:
(Save location of programme

bei Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
bei Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
bei Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()

 

[mrdenny]

Make sure that you have SQL Server Integration Services installed on the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[stla]

Hi,

I've checked the SQL Server Configuration window.

Under SQL Server 2005-Services I have running:

SQL Server-FullText search (MSSQLSERVER)
SQL Server (MSSQLSERVER)
SQL Server Reporting Services(MSSQLSERVER)
SQL Server-Browser (MSSQLSERVER)
SQL Server-Server-Agent (MSSQLSERVER)

This would imply I need to install the SQL Integration Services.

I have the CD at hand and would like to post-install via the wizard.

Is this easy to do?

Do you believe it will reolve the issue with saving the maintenance plans?

Best regards

 

[stla]

As far as I can see, SQL integration services are installed:

PAGINA-SERVER
Die folgenden Komponenten sind auf diesem Server installiert

Any ideas?`

Best regards

MSSQLSERVER
Datenbankmodul
[Version: 9.00.1399.06 Edition: Workgroup Edition Patchebene: 9.00.1399.06 Sprache: Deutsch (Deutschland)]
Reporting Services
[Version: 9.00.1399.06 Edition: Workgroup Edition Patchebene: 9.00.1399.06 Sprache: Deutsch (Deutschland)]

Gemeinsame Komponenten
Arbeitsstationskomponenten
[Version: 9.00.1399.06 Edition: Workgroup Edition Patchebene: 9.00.1399.06 Sprache: Deutsch (Deutschland)]
Integration Services
[Version: 9.00.1399.06 Edition: Workgroup Edition Patchebene: 9.00.1399.06 Sprache: Deutsch (Deutschland)]

 

[mrdenny]

SQL Server 2005 Workgroup Edition doesn't include SSIS. You won't be able to schedule maintenance plans.

You'll need to either run them manually, or schedule the T/SQL commands directly.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[stla]

I have managed to resolve the issue by installing SP2; apparently it was a bug! Further, authentication had to be at Windows level.

Thanks for your help