SQL Server Performance Forum – Threads Archive
Problem in SQL Server 2005 installationHi every one,
I installed Sql Server 2005 on windows XP,SP2 .it is succeed but when I go to the below path : Control Panel>Administrative Tools>services ,there isn’t any service for sql .
I don’t know what is my problem.If anyone knows please inform me.
Service names are different in SQL 2000 and SQL 2005, in SQL 2005 it is SQL Server (MSSQLSERVER).
Could it be the reason?[:I] ________________________________________________
~* Opinions are like a$$holes, everyone got one. *~
<br />Check for the account/login permission that you used to logon on the windows, to check SQL services. Another, you can start/stop sql services from ‘SQL Server COnfiguration Manager’ and make changes through ‘SQL Server Surface Area configuration’. <br /><br /><br />Below are the services name for MS SQL Server 2005, depends on installation type <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br />————————————<br /><br />SQL Server (MSSQLSERVER)<br />Provides storage, processing and controlled access of data and rapid transaction processing.<br /><br />SQL Server Active Directory Helper<br />Enables integration with Active Directories.<br /><br />SQL Server Agent (MSSQLSERVER)<br />Executes jobs, monitors SQL Server, and fires alerts, and allows automation of some administrative tasks.<br /><br />SQL Server Analysis Services (MSSQLSERVER)<br />Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications.<br /><br />SQL Server Browser<br />Provides SQL Server connection information to client computers.<br /><br />SQL Server FullText Search (MSSQLSERVER)<br />Quickly creates full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data.<br /><br />SQL Server Integration Services<br />Provides management support for SSIS package storage and execution.<br /><br />SQL Server VSS Writer<br />Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.<br /><br /><br /><b>Deepak Kumar</b><br /><font size="1">MVP, MCDBA – SQL Server<br /><br />Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</font id="size1">