SQL 2005 Connection Encryption

[mrdenny]

Has anyone ever gotten Connection Encryption working on SQL 2005?

Note that I'm not talking about encrypting data, but encrypting the actual connection from the client to the server over the wire.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

We haven't played with it yet. Are you talking the encryption to the Database Engine connection or IS connection or all of the above?

Or are you talking the encryption of the SSIS packages connecting to the Server?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

I'm talking about encrypting the connecting from the web server to the database server, so that the network traffic between the web server and the database server can not be sniffed by any one.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Okay. I'll check that out. Let you know what I find out.

Are you using ASP?


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Yep.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

Using either the SQL 2000, or SQL 2005 drivers (SQL Native Client).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Denny,

Unfortunately, I just found out that I can't test this and that we don't use it. We have a middle-tier app server which holds all our web related data and then does a nightly sync with our production DB. The web server and the DB server never talk to each other and there are tons of firewalls and a foundry between the two.

Sorry. Wish I could help more, but they won't let me put up a play site to test this. @=/



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Humgph...

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com