Maintanance Plan

in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin.

any idea how i can solve that issue? below you find the details of the exception i get.

thanks in advance,

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

Exception has been thrown by the target of an invocation. (mscorlib)

Program Location:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.GetExistingPackageNames(String serverName, String userName, SqlSecureString securePassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

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

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

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

An OLE DB error 0x80004005 (Client unable to establish connection) occurred while enumerating packages. A SQL statement was issued and failed.

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetPackageInfos(String bstrPackageFolder, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.GetPackageInfos(String strFolder, String serverName, String serverUserName, String serverPassword)

kind regards,

roni schuetz

Are you trying to execute these in code? or is this some unhandled exception you're getting back from the UI.

Otherwise try looking at the History of the jobs in question. You can right click on the maintenance plans node and view the history from within Management Studio.

--Mike|||

that is what i receive from the UI when i try to create a job

|||I have the same exact problem .... any suggestions on how to fix this issue? Thanks!|||

To resolve this problem, install the SSIS service
1. After the System Configuration Check is complete, click Next.
2. Enter a Name, enter a Company, and then click Next.
3. Click the Integration Services check box, and then click Next.
4. Click Next, and then click Install.
5. When the installation is complete, click Next, and then click Finish.

SQL Server Integration Services (SSIS)
http://msdn2.microsoft.com/en-us/library/ms141026.aspx
How to create a Maintenance Plan
http://msdn2.microsoft.com/en-us/library/ms189953.aspx

Thanks

|||

We already have installed SSIS service. Still having the same issue?

Dev

|||

I got this solution from Google groups.

1. Go to C:\Documents and Settings\"sql startup account"\Application
Data\Microsoft\Crypto\RSA\S-1-5-21......
(where "sql startup account" should be the name of your startup account
for sql server")

2 Backup and then delete any files in the S-1-5-21etcetc folder. (but
don't delete the folder)

3. Restart SQL Server.