Installation Guides › Policy Server Installation Guide › Installing Reports › How to Install the Report Server › Gather Information for the Installer › Microsoft SQL Server Report Database

Microsoft SQL Server Report Database

If you are using Microsoft SQL Server to function as the report database, the installer requires specific information. Use the report database installation worksheet to gather the following before starting the installation:

• Data Source Name (DSN)

  The DSN that Report Server is to use to communicate with the report database.

  Note: The Report Server is compiled as 32–bit native binary and is designed to use 32–bit data source middleware connectivity. If you are installing to a Windows 64–bit operating system, be sure to create the DSN using odbcad32.exe. This executable is located at the following location:

  install_home\Windows\SysWOW64.
  

  install_home

  Specifies the installation path of the Windows operating system.

• Login ID

  The name of the report database administrator account. This account must have the default (DBO) account permissions.

• Password

  The password of the report database administrator account.

More information:

Microsoft SQL Server Report Database Worksheet