Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Establishing secure encrypted link between linked servers

 
   Database Forums (Home) -> Security RSS
Next:  MDX Query - Help needed from experienced  
Author Message
mag1kus

External


Since: Aug 19, 2005
Posts: 1



(Msg. 1) Posted: Tue Mar 28, 2006 6:52 pm
Post subject: Establishing secure encrypted link between linked servers
Archived from groups: microsoft>public>sqlserver>security (more info?)

Hi everyone - hoping someone can help me.

I am wanting to send data from our local sql server residing within the
corporate intranet, across to a remote sql server. I have set them up
as linked servers using both the sp_addlinkedserver and
sp_addlinkedsrvlogin stored procedures. All works.. but...

What I would like to establish is the security of the session. How
secure are the login/password credentials as expressed via the
sp_addlinkedsrvlogin stored proc? Are these credentials being sent as
clear text across to the internet sql server? What about the parameters
i am passing in my user stored procedures? Are they being delivered as
clear text?

I would like to have all encrypted somehow.

Would anyone have any suggestions?

Any help most appreciated!

cheers,
peter

 >> Stay informed about: Establishing secure encrypted link between linked servers 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Linked Servers - Hello, I am having trouble with creating a linked server (as simple as it should be). My Setup: Server A: runs under a specific account, the account can be delegated, I have used setspn on this machine (as per BOL), I have also created a linked serve...

Linked SQL Servers - Trying to link 2 servers via: SELECT * from OPENROWSET('SQLOLEDB','Server=SERVER;uid=uid;pwd=pwd; Trusted_Connection=yes;', 'SELECT * FROM Web_Configurator.dbo.MC_WS_Countries') -or- select * from krusty.Web_Configurator.dbo.MC_WS_Countries Keep..

SQL 2005 - Apartment Threaded Linked Servers - I have an apartment threaded OLE DB provider that works as a linked server in SQL Server 2000. But the same provider gives an error msg of "Cannot create an instance of OLE DB provider" with SQL 2005. Does SQL 2005 support apartment thread...

Windows authenication and linked servers - Is there a way to link servers together using windows authentication when you are not logged into the server? I would like to run queries between servers from a local server. I am logged on serv1 as myself with win auth. I am "SA" on all 3...

INSERT Permission & Linked Servers - We are in the process of upgrading from SQL2000 to SQL2005. We discovered one odd behavior in our testing and I've been unable to determine if this is by design. We have two servers (A and B). A table (X) exists in a database on server A. A stored..
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]