Monday, March 26, 2012

Encryption not supported on SQL Server

Hi,
I have a problem with Integration services. When connecting to
Integration services in Management studio and clicking on MSDB, I get
the error:
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
Integration Services
This problem occured after all files were deleted by mistake from:
..\Application Data\Microsoft\Crypto\RSA
SQL Server 2000 client tools(only) were also installed on the box.
There is one package installed in msdb that was working fine before.
Server: sql server 2005 Standard
OS: Windows 2003 Standard
Asim.To add to the post above,
I changed the file:MsDtsSrvr.ini.xml
and replaced the "." with the sql server name for the tag: <ServerName>
Restarted sql, agent and integration services but still get the same
error.
Asim.

No comments:

Post a Comment