April 8, 2008 at 7:33 am
Hello guys,
I have developed a stored procedure that create linked server (I need to make some sql statement between different servers). The problem is:
to crearte the linked server I need to pass user and password. How can I pass user and password in a encrypted way.
I think that if the stored proc execute: addlinkedserver procedures with user and password, these are readable to everybody with sniffer or SQL profile.
How can I pass encrypted password to SQL server engine to create a linked server?
Any other solutions is OK instead of using linked server.
Thank
April 8, 2008 at 8:54 am
You can configure connection encryption, look for "encryption [SQL Server], connections" in BOL.
HTH
Piotr
...and your only reply is slàinte mhath
April 23, 2008 at 9:14 am
Hello,
I read the article on BOL, but it says about SSL that is enabled only when certificate is done.
A sort of encryption is provided by Micrsoft but only for client.
But in the case of a procedure the password is passed in readable text.
April 23, 2008 at 9:29 am
Does this server have to be created each time you execute the procedure? Perhaps you could create it once, and then the password is not dicplayed.
Piotr
...and your only reply is slàinte mhath
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply