绿色SQL Server原理（3）注册表

大家可以看下面的注册表文件

 

Windows Registry Editor Version 5.00

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name]

"Version"=" 1.0.0 "

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer]

"ListenOn"=hex(7):53,00,53,00,4d,00,53,00,53,00,48,00,37,00,30,00,00,00,53,00,/

  53,00,4e,00,45,00,54,00, 4c ,00,49,00,42,00,00,00,00,00

"SetHostName"=dword:00000000

"AuditLevel"=dword:00000000

"LoginMode"=dword:00000002

"Tapeloadwaittime"=dword:ffffffff

"DefaultLogin"="guest"

"Map_"="//"

"Map#"="-"

"Map$"=""

"DefaultCollationName"="Chinese_PRC_CI_AS"

"uptime_pid"=dword: 00000a 98

"uptime_time_utc"=hex: 0a ,3d, 1f ,b9,d0,83,c6,01

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/CurrentVersion]

"checksum"=hex:38,34,32,32,63,31,35,38,61,65,37,64,34,63,64,37,35,30,64,61,30,/

  33,34,62,37,64,63,32,30,38,32,65,62,62,36,31,61,62,33,38,63,65,61,61,31,32,/

  36,66,34,30,31,61,34,61,61,36,39,30,64,62,61,39,31,63,36,31,63,66,32,35,64,/

  32,35,38,65,62,63,61,37,63,61,31,32,38,33,33,38,37,63,38,36,63,34,62,38,36,/

  33,62,34,38,36,39,31,33,38,62,65,37,39,31,32,35,66,66,30,61,61,31,32,32,36,/

  37,65,32,32,38,38,37,35,62,66,33,65,63,37,64,63,38,61,63,37,62,38,37,61,32,/

  33,63,36,39,63,38,31,61,33,63,31,62,38,31,34,65,32,39,37,64,34,62,66,64,00

"RegisteredOwner"=""

"SerialNumber"=dword: 82a 10040

"CurrentVersion"="8.00.194"

"Language"=dword:00000804

"CSDVersionNumber"=dword:00000300

"CSDVersion"="8.00.761"

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/Parameters]

"SQLArg0"="-d.//..//data//master.mdf"

"SQLArg1"="-e.//..//log//log.txt"

"SQLArg2"="-l.//..//data//mastlog.ldf"

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/RPCNetLib]

"Security"=""

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/SuperSocketNetLib]

"ProtocolList"=hex(7):74,00,63,00,70,00,00,00,6e,00,70,00,00,00,00,00

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/SuperSocketNetLib/Np]

"PipeName"=".//pipe//MSSQL$$instance_name//sql//query"

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/MSSQLServer/SuperSocketNetLib/Tcp]

"TcpHideFlag"=dword:00000000

"TcpPort"="$listen_port"

"TcpDynamicPorts"=""

 

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$instance_name/Setup]

"FeatureName"="SqlRun"

"firststart"=dword:00000000

"ProductCode"="{E09B48B5-E141 -427A -AB 0C -D 3605127224A }"

"SQLPath"=".//..//"

"SQLDataRoot"=".//..//"

 

这是注册一个Sql Server实例所要使用的注册表，把里面的$instance_name，$listen_port替换成你定义的实例名，当前程序所有路径，监听端口，然后导入注册表就可以了。