home articles news code blog links search

			SQL 2005 Service Manager Author Jasper Smith Hits 36235 Create Date 15-09-2004 Last Updated 15-08-2008 Versions SQL2000, SQL2005, SQL2008     Overview With the lack of an equivalent in SQL2005 or SQL 2008 for the SQL Server Service Manager that comes with SQL2000, I've decided to write one myself. It's behaviour should be familiar to you if you've used SQL2000. If you have suggestions or want to report a bug email smbugs or you can use the feedback mechanisms on the associated SQL 2005 Service Manager Codeplex site where the full source code is also available. ** Update August 2007 ** If you are running Windows Vista, there is a new version available specifically designed for Vista and UAC (User Account Control) requirements. This Vista version enables the tool to run without administrative privileges by using a helper windows service to perform actions that require administrative rights on behalf of the client. There is no new functionality in this version so existing users running Windows XP/2003 do not need to download this new version. Only Vista users require it. As new functionality is incorporated into the tool it will be added to both versions. ** Update August 2008 ** SQL 2005 Service Manager is now fully compatible with SQL Server 2008 however the name will remain the same.   Features    Manage SQL Server, SQL Agent, Analysis Services, Full Text Search, MSDTC,SSIS and Reporting Services    Supports all SQL2008, SQL2005 and SQL2000 Editions    Manage and monitor local services from the system tray Requirements    Microsoft .NET Framework 2.0.50727 Downloads    Download SQL2005 Service Manager (1.0.0.14) for Windows XP/2003/2008    Download SQL2005 Service Manager (2.0.0.6) for Windows Vista    Download SQL2005 Service Manager source code from Codeplex Using SQL2005 Service Manager To use SQL2005 Service Manager simply unzip the downloaded file into a folder and double click on SQL2005 Service Manager Setup.msi to install. For the Windows Vista version, please read the Install Instructions in the zip file and ensure the SQLServiceManager service is started before using the application. The behaviour of SQL2005 Service Manager is very similar to that of the SQL Server Service Manager that is part of Microsoft SQL Server 2000, one exception being that it will always start minimized in the system tray. Another is that the tool only manages local instances. The system tray icon has a right click menu allowing service and instance selection and control of the currently selected service. Double clicking on the icon or choosing Open SQL2005 Service Manager from the menu will bring up the familiar user interface allowing instance and service selection and control of the selected service. The installer adds a shortcut to your Startup folder so if you don't want it to start automatically simply delete the shortcut. Revision History Author Date Version Description Jasper Smith 15-09-2004 1.0.0.1 Initial beta release Jasper Smith 17-09-2004 1.0.0.2 Fixed issue with service polling interval Jasper Smith 17-09-2005 1.0.0.3 Updated for SQL2005 September CTP Jasper Smith 02-11-2005 1.0.0.4 Updated for SQL2005 RTM Jasper Smith 10-11-2005 1.0.0.5 Fixed two minor UI issues when a service is paused Jasper Smith 12-11-2005 1.0.0.6 Added new menu item for quickly changing instances Jasper Smith 26-11-2005 1.0.0.7 Fixed issue with overlapping service actions Jasper Smith 30-11-2005 1.0.0.8 Added ability to manage SSIS Service Jasper Smith 29-08-2006 1.0.0.9 Added SQL Browser and SQL2000 Full Text Search support and prevented application from running more than once in a session Jasper Smith 17-09-2006 1.0.0.10 Added option to specify default instance Jasper Smith 29-11-2007 1.0.0.11 Added SQL2008 and Windows 2008 compatability Jasper Smith 13-03-2008 1.0.0.12 Added fix for Analysis Services and SSIS not being discovered Jasper Smith 30-06-2008 1.0.0.13 Added compatability for SQL 2008 RC0 and filtered SQL 2008 Express SQL Agent service Jasper Smith 15-08-2008 1.0.0.14 Fixed issue with duplicate SSIS service when SQL 2005 and 2008 are both installed Author Date Version Description Jasper Smith 01-08-2007 2.0.0.0 Initial beta release of Vista specific version Jasper Smith 08-08-2007 2.0.0.1 Initial Public release of Vista specific version Jasper Smith 29-11-2007 2.0.0.2 Added SQL2008 compatability Jasper Smith 13-03-2008 2.0.0.3 Added fix for Analysis Services and SSIS not being discovered Jasper Smith 15-05-2008 2.0.0.4 Added fix for localisation issue for SQLServiceManager service Jasper Smith 02-07-2008 2.0.0.5 Added compatability for SQL 2008 RC0 and filtered SQL 2008 Express SQL Agent service Jasper Smith 15-08-2008 2.0.0.6 Fixed issue with duplicate SSIS service when SQL 2005 and 2008 are both installed Download SQL2005 Service Manager (1.0.0.14) for Windows XP/2003/2008 Download SQL2005 Service Manager (2.0.0.6) for Windows Vista Download SQL2005 Service Manager source code from Codeplex Related Articles    SM0 2005 - Populating a list of SQL Servers    GettingStarted with SMO in SQL 2005   Print this page   Email this article   Add to Favourites

© Copyright sqldbatips Ltd 2008. Contact webmaster

home | news | articles | code | blog | links | search