Home > IT Answers > SQL Server > MSSQL service SQL service icon in the system tray does not have a green arrow on it
SAP Cum IT
35 pts.
 MSSQL service SQL service icon in the system tray does not have a green arrow on it
MSDE, SharePoint, SQL Server installation, Windows 2000 Server
I know Windows Sharepoint services with Windows Server 2000 installs SQL MSDE by default and the installation of same occurred successfully but how come afterwards the SQL service icon in the system tray does not have a green arrow on it instead it has a white filled-in circle and when I launch it the server and services drop-down menus are blank? When I try to start it a message comes up and says "This service control action cannot be completed as no service has been selected".

Software/Hardware used:
ASKED: July 24, 2008  5:30 AM
UPDATED: July 24, 2008  7:21 PM
RELATED QUESTIONS
Answer Wiki:
In the Server dropdown you need to select the named instance of MSDE which was installed. I believe that when Sharepoint installs MSDE it installs it as a named instance which won't show up by default in the server manager. It's a known issue with the server manager that comes with SQL 2000. I would recommend using the Services icon in the Administrative Tools window to start and stop the services. The server manager is removed starting with SQL Server 2005.
Last Wiki Answer Submitted:  July 24, 2008  7:20 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I know Windows Sharepoint services with Windows Server 2003 installs SQL
MSDE by default and the installation of same occurred successfully but
how come afterwards the SQL service icon in the system tray does not
have a green arrow on it instead it has a white filled-in circle and
when I launch it the server and services drop-down menus are blank?
When I try to start it a message comes up and says “This service control
action cannot be completed as no service has been selected”.

K.K.

SAP Cum IT
 35 pts.
 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.