Installing Reporting Server on a second instance of MSDE

Article:TECH101809  |  Created: 2006-01-21  |  Updated: 2006-01-17  |  Article URL http://www.symantec.com/docs/TECH101809
Article Type
Technical Solution


Environment

Issue



You want to install Reporting Server on a computer that already has MSDE installed. When you run the Reporting Server installation, it recognizes the current instance of MSDE and does not allow you to create a database within it.


Solution



In order to use Reporting Server with MSDE already installed, install a second instance of MSDE specifically for Reporting Server.

To install a second instance of MSDE
  1. Click Start > Run and type cmd.
  2. At the command prompt, type the following commands:

    cd \Reporting\MSDE\
    setup INSTANCENAME="SAVRPT" SECURITYMODE=SQL SAPWD="" /L*v C:\MSDELog.log

    Replace with the password for the "sa" account.
  3. When the installation is complete, restart the computer.

To check the MSDE Authentication Mode
  1. In the Registry Editor, go to HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\\MSSQLServer\.
  2. The value for LoginMode should be 2. If the value is not correct, change it to 2 and close the registry editor.
  3. Click Start > Run and type services.msc.
  4. Restart the service named MSSQL$SAVRPT.


Note: Before you install Reporting Server, make sure that IIS is installed.



To install Symantec Reporting Server
  1. From the CD, run Setup.exe.
  2. Click Install Symantec Client Security > Install Reporting Server.
  3. After accepting the license enter the password you would like for the administrator account.
    This password is used when you log on to the Web interface.
  4. Click Install Reporting Server using a database on this machine.
  5. For the Administrator user name, type the following: sa
  6. Type the password that you used in the command line when you installed the second instance of MSDE.
  7. Under Select which instance to use, click SAVRPT.
  8. Click Install to allow the installation to complete.




Technical Information
If the first instance of MSDE has been installed in Mixed mode (securitymode=sql) the Reporting Server database can be installed into this instance. However, MSDE does not install in Mixed mode by default.





Legacy ID



2006042114361048


Article URL http://www.symantec.com/docs/TECH101809


Terms of use for this information are found in Legal Notices