Wednesday, February 15, 2012

Error saving package to msdb (IA64 - April CTP)

When attempting to save a copy of my .dtsx package (from BI Dev Studio), I get the following error. Any one have any ideas? - note: This is an IA64 machine running W2k3 Server (SP1). If I select * from msdb.dbo.sysdtspackages90 I get no rows.

Thanks!
=============================================

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.
(Microsoft Visual Studio)

-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

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

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.


-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.ExistsOnSQLServer(String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)

Additional Info: I've been checking the public newsgroups and this error appears with SQL2000, too. Most proposed solutions relate to certificates being installed. I've checked the various places (xyz\certificates\personal) where the problem certificates might be and have found none, so uninstalling these certificates is not a solution.

Any other ideas? Any would be appreciated!

Thanks!|||I just blogged about this:
http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/09/15772.aspx
Basically, with earlier CTP releases you have two options, supply a self signed cert to the server or upgrade to the June CTP.
Thanks,
K

No comments:

Post a Comment