121 reputation
2
bio website
location
age
visits member for 1 year, 8 months
seen Nov 28 '12 at 17:32

Nov
28
comment SQL Server 2008 encrypted connection using multiple server names
Yes, the client trusts CA. The certificate was generated using Web Server template. Other filled entries are mentioned in the question.
Nov
20
comment SQL Server 2008 encrypted connection using multiple server names
The certificate is generated by local CA on domain server. SQL Server trusts this CA.
Nov
19
comment SQL Server 2008 encrypted connection using multiple server names
I tried to generate a new certificate with multiple CN entries but I wasn't able to connect to the server using any of the defined names in CN entries. :(
Nov
19
comment SQL Server 2008 encrypted connection using multiple server names
As I said, I can only assign one certificate to a single SQL Server Instance, so I have to use one certificate for each accessible server name. And if I could assign different certificate for local connection I can use proper certificate signed by trusted CA instead of self-signed certificate.
Nov
19
comment SQL Server 2008 encrypted connection using multiple server names
No, just one certificate per SQL Server Instance (as far as I know).
Nov
19
comment SQL Server 2008 encrypted connection using multiple server names
Applications that are using Windows Integrated security are connecting to the server using it's local address because from the Internet only the SQL Logins are enabled.
Nov
19
awarded  Student
Nov
19
asked SQL Server 2008 encrypted connection using multiple server names
Aug
12
awarded  Supporter