April 6, 2010 at 3:28 pm
Hi,
We have a SQL Server 2005 Standard edition x86 SSRS installation on Server A and it's databases on Server B. First time, We used SSL while installing SSRS
BNow we want to install another SSRS instance on same Server Server A and can we use the same SSL for the 2nd instance too or do we need to have separate SSL for 2nd instance of SSRS?
Thanks
April 7, 2010 at 1:02 am
It depends on what url you are wanting to use and what ssl cert you have. No matter what you can use the same ssl so long as the virtual directory name is different.
ex.
https://reports.mycompany.com/reports
https://reports.mycompany.com/reports_secondinstance
However you could also use the same ssl if it is a wildcart cert which works for any *.mycompany.com domain.
The one time you would need a second cert is if the existing cert is for reports.mycompany.com and you want the second instance to be accessible as reports_secondinstance.mycompany.com.
-Jeremy
April 7, 2010 at 9:42 am
However you could also use the same ssl if it is a wildcart cert which works for any *.mycompany.com domain.
On my server, SSL certificate is already there. So where can I see to know whether it's wildcard cert or not?
thanks
April 7, 2010 at 5:05 pm
1.) Open MMC
2.) Add Remove/Snapin
3.) Add Certificates
4.) Select Computer Account
5.) Expand Certificates
6.) Expand Personal
You should see the certificate in there and the name it was issued to. It's been awhile since I have seen a wildcard cert but I believe the issued to will be in the form of *.mycompany.com. If it specifically says something like reports.mycompany.com then it is not a wildcard.
-Jeremy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply