Does anyone know how to bind to SQL server 2008 sertificate that doesn't issued to the server local name?
I need to connect to a data-base from other domain over ssl. the SQL server 2008 server has an inner name inside the domain (private name) and name for accessing it from the outer network, WAN (outer name).
I am trying to install a certificate issued with the outer name (the name for access the server from the WAN) and i can't bind the certificate to the sql server (it doesn't presented).
I tried issueing certificate to the local computer name the sql server can bind the certificate.
in the mean while i am using self signed certificate, or certificate sign by CA in the trusted CA.
I tried to issue the private name of the SQL server and adding the private name of the server as an alies to the client. the client reach the server but the ssl didn't work becouse of the certificate.
does anyone have an idea about what can i try more?