Secure connection to MS SQL Server

[Jenny]

Hi

I'm using the following connection string at the moment
which is working fine:

"Data Source=XXX.XXX.XXX.XXX,1433;Network
Library=DBMSSOCN;Initial Catalog=Test;User
ID=User;Password=Testpass;"

With the aim of a secure connection I added SSPI:

"Data Source=XXX.XXX.XXX.XXX,1433;Network
Library=DBMSSOCN;Initial Catalog=Test;User
ID=User;Password=Testpass;Integrated Security=SSPI;"

But I'm getting an error message with this string. Is there
something to change in MS SQL Server to allow secure
connection? How can find the reason for the error?

Thanks for all help
Jenny

 

[Miha Markic]

Hi Jenny,

I am afraid that is not that easy.
Integrated security means that client is using windows account to log on on
sql server - only the logon is secure and not the communication itself.

To secure the "line" you should use VPN or SSL.
VPN is probably easier.

If you go with SSL though you might read the "Net-Library Encryption"
SqlSErver2000 help topic.
Check out also:
228991 How to Create and Install an SSL Certificate in Internet Information
http://support.microsoft.com/?id=228991