Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2004-05-04 : 09:44:30
|
Let me start by saying everyone here has been very helpful with my questions. I really don't know what I'd do without the excellent support from everyone that's helped me in the past. This site is an excellent resource for beginners and those with a backround in SQL looking for an excellent reference library. :-)Now the nitty gritty  I'm having some trouble configuring SSL for my SQL 2000 (SP3a) server running on Windows 2000 SP3. I installed a wildcard SSL on the server just as Microsoft references on their site. However, I have customers who want to use the "encryption" method in their ODBC or ADO connection strings. I thought after configuring the SSL I would only need to select the "force protocol encryption" in "Server Network Utility" console. We're I have TCP/IP, Named Pipes and Multiprotocol enabled protocols. However, after checking and restarting SQL the service fails to start. If I remove the force protocol encryption SQL will start. I want users to be able to define whether or not they want to use the SSL or not. I don't want to block customers who are not using the secure SSL from connecting. It's primarlly for ODBC/AOD connection strings, but could be used for Enterprise Manager. If anyone could provide some insite I would greatly appreciate it. If you need anymore information from me I'll be happy to provide. Just one more thing, we are providing the certificate for those who want to use the SSL. Do we need to also install the cert on the server they're connecting from? Jim |
|
|
|
|
|
Configuring SSL SQL 2000