Please make sure all the pre-requisties are installed.
- The important componnet IIS Feature to be installed, with all the relevent components.click on start --- server manager ---- roles --- add roles.if IIS is intalled and to need the required components please click on Web services IIS --- go to Role services --- add roles.Make sure the follow compnents are added.
- Web Management Tools
- IIS 6 Management Compatibility
- IIS 6 WMI Compatibility IIS Metabase and
- IIS 6 configuration compatibility
- World Wide Web Services
- Application Development .NET Extensibility
- ASP.NET
- ISAPI Extensions
- ISAPI Filters Common
- HTTP Features
- Default Document Directory Browsing
- HTTP Redirection Static Content Security Windows Authentication
2. Now insert the CD and click on setup if autorun does not run.
3. Please clikc next and go through the normal installation.
4. When you get the window system configuration check make sure there is no warning message.
5. If there is message on IIS do not continue make sure the IIS component is completed or if there is warning message on Edition change, note there is a existing sql 2005 installed on this system.
6. To install another version start the cd from the command prompt. type in D:\setup.exe SKUUPGRADE=1
7. Now when there is no warning message click next, select the components you want to install.
8. Enter the instance name for example : MSSQL1
9. Now use the domain account to set up. for example username : vijay password : vijay domain : DOM
10. Select the authentication mode windows mode or mixed mode. This can be changed to mixed mode later as well.
11. Make all the selected components are installed successfully.
To check the installed components, let us first check sql server services.
1. Open sql management studio and select database services and enter username and password based on your authentication selection either windows or sql authentication.
2. When connected you have successful sql database services installed.
3. If not click on sql server configuration manager and start the sql server service.
To check Analysis services
1. Open sql management studio and select analysis services, this is opened through windows authentication.
2. When connected you have successful analysis services installed.
3. If not click on sql server configuration manager and start the analysis services.
To check Reporting services1. Open sql management studio and select reporting services, this is opened through windows authentication.
2. When connected you have successful reporting services installed.
3. If not click on sql server configuration manager and start the reporting services.
4. Click on Reporting services configureation make sure the following is on.
- Server status --- running
- Report virtual directory --- name : reportserver --- website : default website
- Report manager virtual directory --- name : reports --- website : default website
- Windows services Identity --- service name : reportserver$MSSQL1 --- service account : localsystem builtin account : local system please note in this example MSQL1 is the sql instance name
- Web services Identity --- asp.net service account : NT Authority\NetworkService --- report server: reportserver$MSSQL1 --- report manager : reportserver$MSSQL1
- Database setup ---- server name : local(MSSQL1) --- database name : reportserver --- credential type : windows credentials --- account name ---- DOM\vijay ( please note the user name you had given earlier for installation)
- email setting : sender name : emailid (or any other company email id) --- current delivery method --- user smtp server ---- smtp server ---- enter the ip address of smtp server.
If there is still error on the reporting services
Fix / workaround solution
please go to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager
open the RSWebapplicaton file on the notepad and check the following.
1.ReportServerUrl>
2.reportServerVirtualDirectory>ReportServer ( this is the name on the virtual directory of the report server configuration.
3.
No comments:
Post a Comment