MSSQL service SQL service icon in the system tray does not have a green arrow on it

35 pts.
Tags:
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".

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SAP Cum IT
    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.
    35 pointsBadges:
    report
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following