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.
Showing posts with label clicking. Show all posts
Showing posts with label clicking. Show all posts
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.
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.
Labels:
clicking,
connecting,
database,
encryption,
error,
integration,
management,
microsoft,
msdb,
mysql,
oracle,
server,
services,
sql,
studio
Subscribe to:
Posts (Atom)