Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted May 24, 1999

SQL Server Registry Hacks Top 10

By Guy van den Berg

*WARNING* all these tips need edits to be made to the registry. DO NOT TRY THIS ON A LIVE SYSTEM!! ALSO these are 6.5 specific unless otherwise noted.

Unless you now exactly what you are doing these are for info purposes only!

  1. SA Password is stored in the registry. HKLM(or HKCU)\SOFTWARE\MICROSOFT\MSSQLSERVER\SQLEW\REGISTERED SERVERS. Then View / Display Binary data. The password is offset 64 in the data, terminated by 0x00.
  2. Rebuilding the 6.5 registry settings can be done with this command:
    cd \mssql\dll
    ..\binn\setup /t RegistryRebuild = On
  3. Performance Monitor counters not to be found? Check that Administrator has full control of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer.
  4. Alerts To stop frequent errors firing an alert add the number to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLExecutive\NonAlertableErrors. By default 1204 and 4002 are already there.
  5. Version Using the HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup\ProductSuite key you can determine the version of SQL Server you are running.
    SQL Server 6.x standard versions = No entry (There should be NO ProductSuite key)
    SQL 6.5 Enterprise Edition = Enterprise
    Small Business Server = SBS
  6. SQLTrace To allow non administrators to view and save filters grant read access to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\SecurePipeServers\Winreg
  7. SQL Server Keys the keys SQL Server uses are as follows:
    Generic to all versions:
    • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
    • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
    Specific to 6.0
    • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC
    • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLExecutive
    Specific to 7.0
    • HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent
    • HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server 7
    • HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServ65
  8. SQL Executive has a limit on the number of active SQL Server connections running at any one time. Adding MaxDBProcesses Value Name to:
    HKEY_LOCAL_MACHINE: SOFTWARE\Microsoft\MSSQLServer\SQLExecutive
    The value should be added as a Data Type of REG_DWORD. Possible values are from 10 to 255 (Decimal). The actual number of concurrent tasks allowed will be three less than the number you specify to allow for SQLExecutive overhead.

Copyright ) 1998-99 G.h.van den Berg. All rights reserved.
These pages may not be resold or redistributed without prior written permission from Guy van den Berg



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM