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|
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.
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
- Click Start > Run and type cmd.
- At the command prompt, type the following commands:
setup INSTANCENAME="SAVRPT" SECURITYMODE=SQL SAPWD="
" /L*v C:\MSDELog.log
with the password for the "sa" account.
- When the installation is complete, restart the computer.
To check the MSDE Authentication Mode
- In the Registry Editor, go to HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\
- The value for LoginMode should be 2. If the value is not correct, change it to 2 and close the registry editor.
- Click Start > Run and type services.msc.
- Restart the service named MSSQL$SAVRPT.
Note: Before you install Reporting Server, make sure that IIS is installed.
To install Symantec Reporting Server
- From the CD, run Setup.exe.
- Click Install Symantec Client Security > Install Reporting Server.
- 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.
- Click Install Reporting Server using a database on this machine.
- For the Administrator user name, type the following: sa
- Type the password that you used in the command line when you installed the second instance of MSDE.
- Under Select which instance to use, click SAVRPT.
- Click Install to allow the installation to complete.
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.
Article URL http://www.symantec.com/docs/TECH101809