SQL服务启动必须文件
binn/opends60.dll
binn/sqlboot.dll
binn/sqldata.dll
binn/sqlservr.exe
binn/sqlsort.dll
binn/ssnetlib.dll
binn/ums.dll
binn/ssmslpcn.dll
binn/dll/opends60.pdb
binn/dll/ums.pdb
binn/exe/sqlservr.pdb
binn/Resources/2052/sqlevn70.rll
必须系统数据库文件
MASTER.MDF
MASTLOG.LDF
MODEL.MDF
MODELLOG.LDF
MSDBDATA.MDF
MSDBLOG.LDF
TEMPDB.MDF
TEMPLOG.LDF
启动SQL服务的参数
sqlservr.exe -c -sDATASERVER -d./../data/master.mdf -l./../data/mastlog.ldf -e./../Log/log.txt
用到的注册表
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name]
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name/MSSQLServer]
"AuditLevel"=dword:00000000
"DefaultLogin"="guest"
"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
"LoginMode"=dword:00000000
"Map_"="//"
"Map#"="-"
"Map$"=""
"SetHostName"=dword:00000000
"Tapeloadwaittime"=dword:ffffffff
"uptime_pid"=dword:00001044
"uptime_time_utc"=hex:26,57,c8,b3,fb,bb,c5,01
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name/MSSQLServer/CurrentVersion]
"CurrentVersion"="8.00.194"
"RegisteredOwner"=""
"SerialNumber"=""
"CSDVersionNumber"=dword:00000300
"CSDVersion"="8.00.761"
"Language"=dword:00000804
"checksum"=hex:37,35,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,61,36,36,39,37,62,34,61,35,65,36,63,66,62,61,38,37,/
39,36,37,31,66,33,39,61,36,65,35,64,30,33,37,36,37,65,64,36,33,30,61,39,63,/
36,66,37,36,30,35,65,32,66,34,66,31,33,63,39,33,63,34,66,62,66,34,66,64,38,/
64,65,36,64,35,34,37,33,35,39,35,32,36,63,61,32,36,63,33,32,64,34,36,33,65,/
36,39,34,30,65,61,37,64,35,30,61,66,34,64,32,66,38,37,36,30,61,39,64,30,61,/
32,36,64,65,66,66,00
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name/MSSQLServer/Parameters]
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$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/$name/MSSQLServer/SuperSocketNetLib/Np]
"PipeName"="////.//pipe//MSSQL$$name//sql//query"
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name/MSSQLServer/SuperSocketNetLib/Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"="$port"
"TcpPort"="$port"
[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/$name/Setup]
"FeatureName"="SqlRun"
"FirstStart"=dword:00000000
"ProductCode"="{E09B48B5-E141-427A-AB0C-D3605127224A}"
"SQLDataRoot"="$path"
"SQLPath"="$path"
$name 实例名
$port 端口
$path 路径
连接使用 计算机名/实例名 或 IP/实例名
例:
Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=sa;Initial Catalog=master;Data Source=192.168.1.10/DATASERVER