none
FCS 6 Servers - Reporting Server Database - Databases locations?

    질문

  • Hello,

    Anyway to install the Reporting Server Database on another drive than C:(http://technet.microsoft.com/en-us/library/bb404240.aspx)... do I need to install with a small size on C: and then move the files mdf and ldf to E: where I have space?

    To install Client Security on the reporting database server

    1. Using an account that has local administrator privileges on all of the Client Security servers, log on to the reporting database server, insert the Client Security CD, and run the Setup wizard again.

    2. On the Component Installation page, select the Reporting server and reporting database check box, clear all the other check boxes, and then click Next. As part of installing the reporting server components, Client Security will remotely configure the reporting server components on the reporting server.

    3. On the Collection Database page, do the following:

      1. In the Collection database box, enter the collection database server and, if necessary, the SQL Server instance. The default value is not correct for this topology.
      2. In the Reporting account box, enter the user name and password for the reporting account you set up. It is recommended that you use the same account as the DAS account. Make sure to use a domain user account, and then click Next.
    4. On the Reporting Database page, do the following:

      1. In the Reporting database box, enter the reporting database server (the default value) and, if necessary, the SQL Server instance.
      2. In the Database size box, enter the appropriate size for the reporting database. (If you specify a database size that exceeds the available disk space, the installation will fail.)
      3. In the DTS account box, enter the user name and password for the DTS account you set up. It is recommended that you use the same account as the DAS account. Make sure to use a domain user account, and then click Next.
    5. On the Reporting Server page, do the following:

      1. In the Reporting server box, enter the name of the reporting server. The default value is not correct for this topology.
      2. In the URL for Report Server and URL for Report Manager boxes, ensure the default values are entered, and then click Next.
    6. On the Install Location page, enter the location where you want the Setup wizard to install Client Security files. Database files associated with Client Security will be installed in the location you specified when installing SQL Server.

    7. On the Verifying Settings and Requirements page, verify your system requirements, and then click Next.

    8. On the Completing Setup page, verify that you have successfully installed Client Security, and then click Close.

    9. Thanks,

    10. Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
    2011년 1월 26일 수요일 오후 11:28

모든 응답

  • Hi,

    Have you installed/configured SQL Reprorting Services/SRS database on a different partition than c: before to install the FCS reporting role ?


    Bechir Gharbi | http://myitforum.com/cs2/blogs/bgharbi/
    2011년 1월 28일 금요일 오전 9:29
  • Hello,

    Yes it is kind of different partition as it is on another server...
    The collection database is on SDB1
    The SRS database is on SRS1 (only DB no SRS, is it correct?)
    the SRS Service is on VRS1

    Three different servers.

    Thanks,
    Dom


    System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
    2011년 1월 28일 금요일 오후 2:33