dbagurus
II-Sung,
Let me explain what I am doing and my settings.
Objective: I am trying to connect over the internet to a remote SQL Server in which I have been able to do in the past. I found out that the remote SQL Server has added a Verisign certificate and I do not seem to be able to connect through SQL Server Management Studio's. My objective is to setup replication between the 2 instances of SQL Server.
There is no application involved besides SQL Server Management Studios.
Client-side Settings:
When looking from the client-side (my laptop) in "SQL Server configuration manager | SQL Server 2005 Network configuration | and right-clicking on Protocols for SQL2005 | Properties" under the Flag tab, "Force encryption" is set to "NO", "hide instance" is set to "No" . When going under the Certificate tab there is no certificate selected. I have also tried it with the certificate in the dropdown as well, still no worky. I am not sure if I can go in the registry to see if it is set there and simply not updating the screen, not sure.
I am also not sure where to set the TrustServerCertificate setting within SQL Server Management Studios. I can tell you that in the "Connect to Server" dialogue "Encrypt connection" is not checked.
I have also tried to send my certificate from my laptop to the remote server and imported it into the "Trusted Root Certification Authority" and the "Trusted People". Still no worky.
Remote SQL Server:
When terminal servicing into the remote SQL Server and checking "SQL Server configuration manager | SQL Server 2005 Network configuration | and right-clicking on Protocols for MSSQLSERVER | Properties" under the Flag tab, "Force encryption" is set to "NO", "hide instance" is set to "No" . When going under the Certificate tab there is no certificate selected.
I am coming close to a deadline and not sure what to do, let me know where I am going wrong. I have taken all of your advise, not sure what else to do here, please advise.
John