If you're installing your application on the server for the first time, and if you're using Reporting Services, you can opt to set it up after installing SQL on the server, even if you haven't installed the application at workstations.
To configure Reporting Services for your instance of SQL:
- On the application server, click the Windows Start menu, and select .
- Click Connect.
- In the left pane, click Service Account.
- Select the Use built-in account option button.
- In the Use built-in account field, click
and select Local System. - In the left pane, click Web Service URL.
- Do the following:
- In the Virtual Directory field, enter
ReportServer_PCMX. - In the IP Address field, click
and select All Assigned (Recommended). - In the TCP Port field, enter
8080.
Note: If port 8080 is already used, enter a different port number.
- In the SSL Certificate field, click
and select (Not Selected). - Leave the SSL Port field blank.
- Click Apply.
- In the left pane, click Database.
- Click Change Database.
- Select the Create a new report server database option button.
- Click Next.
- Do the following:
- In the Server Name field, enter the name of the server.
- In the Authentication Type field, click
and select Current User - Integrated Security. - Click Test Connection.
- When you get a Test Connection Succeeded message, click OK.
Note: If the test connection is unsuccessful, double-check your settings.
- Click Next.
- Do the following:
- In the Database Name field, enter
ReportServer$PCMX. - In the Language field, click
and select English (United States). - Select the Native Mode option button.
- Click Next.
- In the Authentication Type field, click
and select Service Credentials. - Click Next.
- Review the settings and click Next.
- When the process is complete, click Finish.
- In the left pane, click Report Manager URL.
- In the Virtual Directory field, enter
Reports_PCMX. - In the URLs field, click the link.
- Close or minimize the browser window.
- On the Reporting Services Configuration Manager window, click Exit.