Introduction
This article provides details about the services configured on installing SQL server 2005.
Following 10 services will get installed in our machine.
• SQL Server agent (SQLAGENT90.exe)
• SQL Server Browser(SQlBrowser.exe)
• Analysis Services(msmdsrv.exe)
• Reporting Services(ReportingServicesService.exe)
• Full text Search (msftesql.exe)
• Integration Services(MsDtsSrvr.exe)
• SQL Server Database services(sqlserve.exe)
• SQL Server Active Directory Helper(sqladhlp90.exe)
• SQL Server writer(SQLWriter.exe)
• Notification Services(NSService.exe)
Instance-Aware Services:
Among these services SQL Server, SQL Server agent, Report Server, Full Text search, Analysis services needs separate installation for each instances and it’s considered as “Instance-aware Services”.
Instance-Unaware Services:
SQL Server Active Directory helper, SQL Server writer, Integration Services, SQL Server Browser, Notification services are installed as a shared component, and works for all the instances created and it can installed only once.
Installing Reporting services:
• After installing reporting services, connect to your server using SQL Server Management Studio and check the below two Reporting Services Databases are created (ReportServer and ReportServerTemp Databases).
• Check your reporting services is running or not. Goto “Run” type services.msc and click enter. Services window will be opened. Check for Microsoft SQL Server Reporting Services status. It should be in started mode. Else right click and start the services.
• Open IIS and check your Default websites, you should have Report Server and ReportServerTemp.
Summary
This article provides the details about the services configured while installing sql server 2005, in addition it provides info about the post installation check for reporting services.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|