SQL server 2008 encrypted connection RRS feed

  • Question

  • My (remote) clients wish to have encrypted connection to my server. We deemed VPN as unnecessary, since SQL server provides secure connections.

    I have a problem though.

    I've created and installed a self-signed certificate test on my Windows 2008 Server. I've set Force Encryption to Yes and set the certificate to test.

    I've exported and sent the test certificate to clients. They've installed it to the Trusted Authority store. They've tried to connect to the SQL server through the SQL Management Studio Express, with theEncrypt connection set. They get the following error:

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)

    Note that they can connect to the server just fine through unencrypted connection and settings.

    I've tried most solutions thrown out by bing about this error, but I don't think any of them dealt with encryption.

    NOTE: I've also tried this(hxxp://www.sqlservercentral.com/Forums/Topic611829-146-1.aspx) method, but I still get the same error.

    NOTE: I don't have the Primary DNS Suffix set, if that has any affect on certificates?

    Monday, October 29, 2012 10:40 AM


All replies