Encrypted Connection

Hi all,
If this is not the correct groups to post this, please redirect me.
I have a .NET application and SQL Server 2005 Express running on a Windows
Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
running on Windows 2000.
SQL Server Express 2005 has the 2000 server set up as a linked server.
What are my options for encrypting the connections to the SQL Server 2000?
For the .NET app, I assume that I can use multiprotocol. Correct? Other
suggestions?
What about the SQL Server 2005 linked server to 2000?
TIA
AG
Email: discuss at adhdata dot comSQL Server supports SSL encryption for connections. See the following
articles:
http://support.microsoft.com/kb/276553
http://msdn2.microsoft.com/en-us/library/ms189067.aspx
http://msdn2.microsoft.com/en-us/library/ms191192.aspx
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> If this is not the correct groups to post this, please redirect me.
> I have a .NET application and SQL Server 2005 Express running on a Windows
> Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
> running on Windows 2000.
> SQL Server Express 2005 has the 2000 server set up as a linked server.
> What are my options for encrypting the connections to the SQL Server 2000?
> For the .NET app, I assume that I can use multiprotocol. Correct? Other
> suggestions?
> What about the SQL Server 2005 linked server to 2000?
> TIA
> --
> AG
> Email: discuss at adhdata dot com
>
>|||Thanks for the quick response Plamen,
That all requires a SSL cert, which the 2000 server does not have.
Is there some way to use multiprotocol with the linked server?
The current setup is using a VPN, but we are moving to a new server and
there may be a problem setting up a VPN.
AG
Email: discuss at adhdata dot com
"Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
> SQL Server supports SSL encryption for connections. See the following
> articles:
> http://support.microsoft.com/kb/276553
> http://msdn2.microsoft.com/en-us/library/ms189067.aspx
> http://msdn2.microsoft.com/en-us/library/ms191192.aspx
> Regards,
> Plamen Ratchev
> http://www.SQLStudio.com
>
> "AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
> news:%23JeihNoKHHA.960@.TK2MSFTNGP04.phx.gbl...
>|||The multiprotocol has been depreciated in SQL Server 2005. See this post for
details (look under the Changes section):
http://blogs.msdn.com/sql_protocols.../22/473111.aspx
If you do not have a local Certificate Server you can always purchase a
third-party certificate.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
"AG" <NOSPAMa-giam@.newsgroups.nospam> wrote in message
news:%23kAVctpKHHA.4384@.TK2MSFTNGP03.phx.gbl...
> Thanks for the quick response Plamen,
> That all requires a SSL cert, which the 2000 server does not have.
> Is there some way to use multiprotocol with the linked server?
> The current setup is using a VPN, but we are moving to a new server and
> there may be a problem setting up a VPN.
> --
> AG
> Email: discuss at adhdata dot com
>
> "Plamen Ratchev" <Plamen@.SQLStudio.com> wrote in message
> news:Oyn6mApKHHA.4992@.TK2MSFTNGP04.phx.gbl...
>|||Hello AG,
I agree with Plamen that you could use a third party certificate if
necessary.
Also, you may consider configure IPsec between the servers so that all IP
traffic is protected between them. Pleas esee the following articles for
more details:
TechNet Support WebCast: How to use IPSec to help secure network traffic
http://support.microsoft.com/default.aspx?kbid=888266
IPsec
http://www.microsoft.com/technet/ne...ec/default.mspx
If you have further comments or feedback, please feel free to let's know.
Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Peter,
Sorry, I did not get back to you sooner. I wanted to get the client's
networking person involved and that will happen today.
IPsec looks like it might do the job.
AG
Email: discuss at adhdata dot com
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:Jj1YdPvKHHA.2304@.TK2MSFTNGHUB02.phx.gbl...
> Hello AG,
> I agree with Plamen that you could use a third party certificate if
> necessary.
> Also, you may consider configure IPsec between the servers so that all IP
> traffic is protected between them. Pleas esee the following articles for
> more details:
> technet Support WebCast: How to use IPSec to help secure network traffic
> http://support.microsoft.com/default.aspx?kbid=888266
> IPsec
> http://www.microsoft.com/technet/ne...ec/default.mspx
> If you have further comments or feedback, please feel free to let's know.
> Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>