Using encryption
From: Dencom (Dencom_at_discussions.microsoft.com)
Date: 06/20/05
- Next message: Hari Prasad: "Re: Select SPROC Permissions"
- Previous message: Nick: "Select SPROC Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 20 Jun 2005 11:25:05 -0700
Hi, I have a sql server 2000 (sp3) (say A). I have installed a verisign cert
on it. I can access this server through a vb client by using "Use Encryption
for Data=True" in the connection string. Now, I want to do the same thing for
a sql server (B) which accesses A using linked server route. Basically B is
acting as a client of A. Where do I specify the encryption parameter so that
data flow between B and A is encrypted?? I tried using this, but does not
work:
exec sp_addlinkedserver
@server='test',
@datasrc=XXX.XXX.XXX.XXX,
@provider='SQLOLEDB',
@srvproduct='SQLServer OLEDB Provider',
@provstr='Use Encryption for Data=True'
GO
I use a sniffer to see my net traffic. The traffic in not encrypted. Thanks.
- Next message: Hari Prasad: "Re: Select SPROC Permissions"
- Previous message: Nick: "Select SPROC Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
