April 1, 2008 at 9:18 am
My customer has the following security guidelines on SQL Server. My question is, can SSRS 2005 be configured to comply?
1. Database and web server cannot be on the same machine
2. SQL Server Browser Service must be disabled
3. SQL Server service must use a non-default TCP/IP port
The question boils down to this: Does the Report Server really require the Browser Service, or can it be somehow configured to find a statically-specified server/port?
April 1, 2008 at 12:38 pm
I found a solution:
1. Use cliconfg.exe to create an alias that encapsulates the port #
2. Use the alias as the Server Name in Reporting Services Configuration Manager
April 1, 2008 at 7:51 pm
You can also include the port in the connection string in the report data source like this server=192.168.1.43:2500.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply