SQL Server Express Edition with Advanced Series 2008

Question

Unattended Silent Installation-
Can we give custom port number(such as 8086) for reporting services instead of assuming 8080 or 80 depending upon OS.
We are installing single custom instance(such as SQLTest) for database and reporting services. Both are installed at one time during silent installation.

Answer 1

hi,
AFAIK, there's no way to specify a particular network protocol port at installation time.. you can just enable the network protocols with the predefined parameter.. for SQL Server service, installing a default instance, this result in the 1433 predefined and IANA assigned tcp/ip port, where a named instance installation will default to a dynamically assigned port requiring the SQLBrowser service to resolve port assignement at run time..
regards

---

http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools

Answer 2

I am looking for how to specify SSRS port number with silent installation- reporting services port number such as http:/localhost:8080/ReportServer_SQLTest.

I do not want to change SQL Server port number 1433 in silent installation.

Answer 3

I don't think there is a way to change this during sql install , may be you should try to achieve this on the IIS part where sql reporting services websites and directories are created.

---

Thanks, Leks

Answer 4

I am using SQL Server 2008 Express Edition which is not using IIS as webserver.

Answer 5

Hi Vigro,

As sais earlier , that might not be changed during installation.
Have you checked the option in REPORTING SERVICES CONFIGURATION tool? Try changing the default port 8080 to desired port in the web service URL page.
Have a look at the link and check to see if this is helpful - http://technet.microsoft.com/en-us/library/ms188133.aspx

---

Thanks, Leks

Answer 6

If I am doing fresh installation of SQL Server with reporting services and then use Reporting services configuration tool. This involves two steps, I am looking for one step where in command line I could mention port number, url for reporting services.

Answer 7

Is there a command line utility to change port and url for Reporting Service, if I follow two steps to install SQL server with Reporting services.

Answer 8

Resolved it using 2nd step with httpcfg command.