cannot connect to server with encrypt on

fatherjack2 · February 13, 2009 8:30AM

Hi,

I have a server (Server C) at our DR location that we are looking to use as the warm standby for log shipping. I have installed SQL Backup remotely over the same connection that will support the data transfer. Backup history and activity has been imported so the connection is working fine. However, when I select Edit | Options | Encrypt Connection the server gets a red cross on its icon and the timeline shows no further refreshes.

Server B is on our local network and has had SQL Backup installed and working for months. Some of these backups use encryption and full compression to transport a copy of the backup up the a file share on Server C. These jobs work without fail.

I have not yet registered the SQL Backup installation on Server C, is encryption disabled until the software is activated? If not, can you please advise what might be preventing me from enabling encryption on the actual server connection please?

regards

Jonathan

Eddie D · February 16, 2009 10:41AM

Thank you for your post into the forum.

When you edit the server connection properties, (Right Click the Server, Select Edit ->Select the Options Tab), have tried increasing the Connection time-out setting from the default of 15 seconds?

Also have you tried specifying a Network protocol?

Many Thanks
Eddie

fatherjack2 · February 17, 2009 5:09AM

I have set the timeout to 45s and fixed the protocol to TCP/IP and the red cross icon appears immediately after the Edit SQL Server dialog is closed when the Encrypt connection checkbox is checked.

As an aside, is it a known issue that F5 doesnt refresh the server connection, it has to be selected from the View menu?

Eddie D · February 18, 2009 3:21PM

Thank you for your reply.

What is the exact error message you receiving when attempting to connect after enabling the 'Encrypt connection' option?

If you mouse click on the 'red box' with the 'white X', another dialog type box will appear giving an explanation for the connection failure.

Many Thanks
Eddie

fatherjack2 · February 19, 2009 4:25AM

Hi Eddie,

Thanks for the further enquiry. I have the situation now where its all working so I cant tell you what happens when I click the red cross icon! Maybe we had network conditions that were causing the connection some problems..?

If the issue comes back then I'll get back in touch.

Thanks

Jonathan

fatherjack2 · February 19, 2009 6:33AM

OK, a little later in the day and the red cross is back...

the error message is :

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

I look forward to further advice.

Jonathan

Eddie D · February 20, 2009 11:30AM

Thank you for your reply.

If the SQL Server you are attempting to connect to is SQL Server 2000

Can you please try the following:

Start-->Programs-->Microsoft SQL Server-->Client Network Utility

Is the "Force Protocol Encryption" option disabled or unchecked?

If SQL Server 2005:

Check the following setup:
Protocols:
Share Memory Enabled
Named Pipes Disabled
TCP/IP: Enabled, Keep Alive: 30000, Listen All: Yes, No Delay: No,
Dynamic Ports are disabled
VIA: Disabled
Also ensure SQLBrowser service is up and running.

Many Thanks
Eddie

cannot connect to server with encrypt on

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk