Mittwoch, 23. Juni 2010

MS SQL Server: Registry Keys für einige SQL Dienste

SQL Server Dienst:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER

SQL Server Agent:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT

MSDTC:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC

SQL Server Analysis Services (MSSQLSERVER):
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerOLAPService

SQL Server Reporting Services (MSSQLSERVER):
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ReportServer

SQL Server Browser:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBrowser

Startwerte: Start REG_DWORD

0 - Boot: Loaded by kernel loader
1 - System: Loaded by I/O subsystem
2 - Automatic: Service is loaded or started automatically.
3 - Manual:. The service does not start until the user starts it manually.
4 - Disabled: Specifies that the service should not be started.

Keine Kommentare: