SQLSERVER2005的安装目录结构（上） 下篇的地址： http://www.cnblogs.com/lyhabc/archive/2013/05/26/3099363.html 我觉得每个软件，如果是绿色的话，那么就可以认为不写注册表的，如果不是绿色的话，那么应该是写注册表的 SQLSERVER2005不是绿色软件，当然
下篇的地址：http://www.cnblogs.com/lyhabc/archive/2013/05/26/3099363.html
我觉得每个软件，如果是绿色的话，那么就可以认为不写注册表的，如果不是绿色的话，那么应该是写注册表的
SQLSERVER2005不是绿色软件，当然要写注册表，当然要先卸载再重新安装才能用，虽然SQLSERVER2005安装完毕之后就只会在
安装目录下产生一个文件夹
安装完毕之后，只会产生一个Microsoft SQL Server这个文件夹，当然不是把这个文件夹copy出来就可以使用的，因为
SQLSERVER2005还写注册表的
这篇文章就分注册表跟安装目录这两个结构来说吧
下篇的地址：http://www.cnblogs.com/lyhabc/archive/2013/05/26/3099363.html
-------------------------------------------------------华丽的分割线-------------------------------------------------
注册表
在以下三个路径找到有SQLSERVER或者和SQLSERVER有关系的，现在我把他们导出来
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist]
Windows Registry Editor Version <span>5.00</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\2052</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\BOL\2052\CurrentVersion</span><span>]</span><span>
"Version"</span><span>=</span>"<span>9.00</span>.<span>1399.06</span><span>"
"CSDVersionNumber"</span><span>=</span>dword:<span>00000000</span><span>
"PatchLevel"</span><span>=</span>"<span>9.00</span>.<span>1399.06</span><span>"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SNAC</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SNAC\2052</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SNAC\2052\CurrentVersion</span><span>]</span><span>
"Version"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
"CSDVersionNumber"</span><span>=</span>dword:<span>00000000</span><span>
"PatchLevel"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter\2052</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter\2052\CurrentVersion</span><span>]</span><span>
"Version"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
"CSDVersionNumber"</span><span>=</span>dword:<span>00000000</span><span>
"PatchLevel"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist\SqlWriter\MSIRefCount</span><span>]</span><span>
"Uninstall"</span><span>=</span>"{<span>11111111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>111111111111</span>},{81707DCE<span>-</span><span>3920</span><span>-</span>430A<span>-</span>815A<span>-</span>B2EAC53CAAEC},{0C1BF107<span>-</span>437C<span>-</span>4A09<span>-</span>A0FE<span>-</span>9495334201F0}"[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client]
Windows Registry Editor Version <span>5.00</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion</span><span>]</span><span>
"PatchLevel"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
"Version"</span><span>=</span>"<span>9.00</span>.<span>5000.00</span><span>"
"SP"</span><span>=</span>dword:<span>00000000</span><span>
"LCID"</span><span>=</span>dword:<span>00000804</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Native Client\MSIRefCount</span><span>]</span><span>
"Uninstall"</span><span>=</span>"{<span>11111111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>111111111111</span>}"[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]
Windows Registry Editor Version <span>5.00</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server</span><span>]</span><span>
"IsListenerActive"</span><span>=</span><span>"Yes"
"SsrpActiveServer"</span><span>=</span><span>""
"InstalledInstances"</span><span>=</span>hex(<span>7</span>):4d,<span>00</span>,<span>53</span>,<span>00</span>,<span>53</span>,<span>00</span>,<span>51</span>,<span>00</span>,4c,<span>00</span>,<span>53</span>,<span>00</span>,<span>45</span>,<span>00</span>,<span>52</span>,<span>00</span>,<span>56</span><span>,\
</span><span>00</span>,<span>45</span>,<span>00</span>,<span>52</span>,<span>00</span>,<span>00</span>,<span>00</span>,<span>53</span>,<span>00</span>,<span>51</span>,<span>00</span>,4c,<span>00</span>,<span>45</span>,<span>00</span>,<span>58</span>,<span>00</span>,<span>50</span>,<span>00</span>,<span>52</span>,<span>00</span>,<span>45</span>,<span>00</span>,<span>53</span>,<span>00</span><span>,\
</span><span>53</span>,<span>00</span>,<span>00</span>,<span>00</span>,<span>00</span>,<span>00</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100</span><span>]</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools</span><span>]</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell</span><span>]</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\AddIns</span><span>]</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\AddIns\RedGate.SQLPrompt.SSMSUI</span><span>]</span><span>
"FriendlyName"</span><span>=</span>"SQL Prompt <span>5.3</span><span>"
"Description"</span><span>=</span>"SQL Prompt <span>5.3</span> Write, edit, <span>and</span><span> explore SQL effortlessly"
"LoadBehavior"</span><span>=</span>dword:<span>00000001</span><span>
"CommandPreload"</span><span>=</span>dword:<span>00000001</span><span>
"SatelliteDllName"</span><span>=</span><span>"SqlPromptTopMenuDecoration.dll"
"SatelliteDllPath"</span><span>=</span>"C:\\Program Files\\Red Gate\\SQL Prompt <span>5</span><span>\\"
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Shell\PreloadAddInState</span><span>]</span><span>
"RedGate.SQLPrompt.SSMSUI"</span><span>=</span>dword:<span>00000001</span><span>
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup</span><span>]</span><span>
"SQLPath"</span><span>=</span>"C:\\Program Files\\Microsoft SQL Server\\<span>80</span><span>\\Tools"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90</span><span>]</span><span>
"SharedCode"</span><span>=</span>"C:\\Program Files\\Microsoft SQL Server\\<span>90</span><span>\\Shared\\"
"VerSpecificRootDir"</span><span>=</span>"C:\\Program Files\\Microsoft SQL Server\\<span>90</span><span>\\"
"EnableErrorReporting"</span><span>=</span>dword:<span>00000000</span><span>
"ErrorReportingDir"</span><span>=</span>"C:\\Program Files\\Microsoft SQL Server\\<span>90</span><span>\\Shared\\ErrorDumps\\"
"CustomerFeedback"</span><span>=</span>dword:<span>00000000</span><span>
"TimeOfReporting"</span><span>=</span><span>dword:000000f0
"CollectorParameters"</span><span>=</span><span>""
@</span><span>=</span><span>""
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap</span><span>]</span><span>
"BootstrapDir"</span><span>=</span>"C:\\Program Files\\Microsoft SQL Server\\<span>90</span><span>\\Setup Bootstrap\\"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount</span><span>]</span><span>
"Uninstall"</span><span>=</span>"{<span>11111111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>1111</span><span>-</span><span>111111111111</span>},{CFD46495<span>-</span>A02E<span>-</span>459D<span>-</span><span>8548</span><span>-</span>CEBC8084B779},{32D60EB4<span>-</span>911D<span>-</span>4BA2<span>-</span>A64A<span>-</span>C925180B61A6},{<span>72902785</span><span>-</span>0CDC<span>-</span>471A<span>-</span>AA41<span>-</span>64D30F6821D1},{81707DCE<span>-</span><span>3920</span><span>-</span>430A<span>-</span>815A<span>-</span>B2EAC53CAAEC},{FA0DF4A2<span>-</span>C888<span>-</span>4C1C<span>-</span>91A9<span>-</span>574E93DBB374},{0C1BF107<span>-</span>437C<span>-</span>4A09<span>-</span>A0FE<span>-</span>9495334201F0},{D0A48F7C<span>-</span>6A57<span>-</span>4B98<span>-</span>AD44<span>-</span><span>FF36C1833324}"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\Setup</span><span>]</span><span>
"PatchLevel"</span><span>=</span>"<span>9.4</span>.<span>5000</span><span>"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Cost</span><span>]</span><span>
"MSXML6"</span><span>=</span>"<span>15728640</span><span>"
"DTSSetup"</span><span>=</span>"<span>4194304</span><span>"
"SQLSetup"</span><span>=</span>"<span>8388608</span><span>"
"owc11"</span><span>=</span>"<span>4194304</span><span>"
"ASSetup"</span><span>=</span>"<span>2097152</span><span>"
"sqlxml4"</span><span>=</span>"<span>8388608</span><span>"
"NSSetup"</span><span>=</span>"<span>4194304</span><span>"
"ToolsSetup"</span><span>=</span>"<span>26214400</span><span>"
"PPESku"</span><span>=</span>"<span>157286400</span><span>"
"bol"</span><span>=</span>"<span>178257920</span><span>"
</span><span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS</span><span>]</span>
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup</span><span>]</span><span>
"Version"</span><span>=</span>"<span>9.4</span>.<span>5000.00</span><span>"
"Language"</span><span>=</span>dword:<span>00000804</span><span>
"ProductCode"</span><span>=</span>"{32D60EB4<span>-</span>911D<span>-</span>4BA2<span>-</span>A64A<span>-</span><span>C925180B61A6}"
"FeatureList"</span><span>=</span>"SQL_DTS<span>=</span><span>3</span><span>"
"PatchLevel"</span><span>=</span>"<span>9.4</span>.<span>5000</span><span>"
"SQLPath"</span><span>=</span>"c:\\Program Files\\Microsoft SQL Server\\<span>90</span><span>\\DTS\\"
"checksum"</span><span>=</span>hex:<span>38</span>,<span>34</span>,<span>33</span>,<span>66</span>,<span>66</span>,<span>66</span>,<span>30</span>,<span>65</span>,<span>62</span>,<span>38</span>,<span>32</span>,<span>62</span>,<span>30</span>,<span>34</span>,<span>37</span>,<span>62</span>,<span>31</span>,<span>30</span>,<span>35</span>,<span>31</span>,<span>36</span><span>,\
</span><span>38</span>,<span>32</span>,<span>31</span>,<span>30</span>,<span>30</span>,<span>63</span>,<span>65</span>,<span>63</span>,<span>61</span>,<span>37</span>,<span>33</span>,<span>66</span>,<span>30</span>,<span>63</span>,<span>62</span>,<span>65</span>,<span>31</span>,<span>30</span>,<span>36</span>,<span>65</span>,<span>36</span>,<span>64</span>,<span>31</span>,<span>65</span>,<span>38</span><span>,\
</span><span>38</span>,<span>34</span>,<span>63</span>,<span>64</span>,<span>38</span>,<span>30</span>,<span>37</span>,<span>31</span>,<span>33</span>,<span>64</span>,<span>64</span>,<span>37</span>,<span>31</span>,<span>37</span>,<span>63</span>,<span>34</span>,<span>37</span>,<span>34</span>,<span>35</span>,<span>63</span>,<span>31</span>,<span>65</span>,<span>37</span>,<span>64</span>,<span>30</span><span>,\
</span><span>38</span>,<span>31</span>,<span>30</span>,<span>30</span>,<span>36</span>,<span>64</span>,<span>31</span>,<span>36</span>,<span>65</span>,<span>64</span>,<span>36</span>,<span>63</span>,<span>65</span>,<span>64</span>,<span>64</span>,<span>36</span>,<span>64</span>,<span>38</span>,<span>30</span>,<span>31</span>,<span>34</span>,<span>65</span>,<span>39</span>,<span>63</span>,<span>30</span><span>,\
</span><span>30</span>,<span>61</span>,<span>36</span>,<span>32</span>,<span>65</span>,<span>63</span>,<span>64</span>,<span>32</span>,<span>34</span>,<span>62</span>,<span>64</span>,<span>32</span>,<span>34</span>,<span>63</span>,<span>66</span>,<span>35</span>,<span>36</span>,<span>33</span>,<span>66</span>,<span>63</span>,<span>66</span>,<span>30</span>,<span>34</span>,<span>61</span>,<span>39</span><span>,\
</span><span>33</span>,<span>62</span>,<span>66</span>,<span>37</span>,<span>32</span>,<span>62</span>,<span>32</span>,<span>62</span>,<span>62</span>,<span>66</span>,<span>64</span>,<span>34</span>,<span>65</span>,<span>61</span>,<span>63</span>,<span>65</span>,<span>38</span>,<span>39</span>,<span>34</span>,<span>34</span>,<span>33</span>,<span>33</span>,<span>36</span>,<span>31</span>,<span>33</span><span>,\
</span><span>35</span>,<span>66</span>,<span>31</span>,<span>31</span>,<span>30</span>,<span>61</span>,<span>66</span>,<span>66</span>,<span>61</span>,<span>37</span>,<span>34</span>,<span>63</span>,<span>61</span>,<span>32</span>,<span>34</span>,<span>37</span>,<span>61</span>,<span>63</span>,<span>38</span>,<span>34</span>,<span>64</span>,<span>33</span>,<span>35</span>,<span>34</span>,<span>00</span><span>
"Edition"</span><span>=</span><span>"Developer Edition"
"EditionType"</span><span>=</span><span>"Developer Edition"
"SP"</span><span>=</span>dword:<span>00000004</span><span>
"AssociatedHotfixBuild"</span><span>=</span>"<span>1520</span>"
由于[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server]位置下的内容太长了，所以只摘抄了一部分
这些注册表值都记录了一些SQLSERVER的设置参数，比如：
SQLSERVER的服务器网络配置选项在SQLSERVER配置管理器工具的网络配置
配置的结果其实存放在注册表的[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib]下的各个项目里。不用管理界面，直接修改注册也能同样达到一样的目的。
<span>[</span><span>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib</span><span>]</span><span> "ForceEncryption"</span><span>=</span>dword:<span>00000000</span><span> "HideInstance"</span><span>=</span>dword:<span>00000000</span><span> "Certificate"</span><span>=</span><span>"" "DisplayName"</span><span>=</span>"SQL Server Network Configuration"
ForceEncryption：强制加密
HideInstance：隐藏实例
-----------------------------------------------华丽的分割线-------------------------------------------
下面我只简单介绍一下我所知道的一些注册表配置选项，以截图的方式来说明
因为安装了SQL Prompt，还有一些Windows补丁，所以会出现80（SQL2000） 90(SQL2005) 100(SQL2008)的一些选项
安装了SQL Prompt因为要SQL2005~SQL2008都能用所以生成了相应版本的注册表项目，为什麽没有SQL2000跟SQL2012呢？
因为我没有安装过SQL2012，SQL2000不支持
记录SQLSERVER的安装日志路径
记录MSDTS的一些信息，DTS：数据转换服务，不知道的大家可以百度，这里不详细说了
安装完SQLSERVER之后附带的一些工具的工具目录路径
数据库发布向导，不知道有没有人用过，将现有数据库生成一个脚本，但不包括数据库的数据，然后在另一台机器上生成整个数据库结构
一些安装信息
卸载信息，卸载SQLSERVER的时候，操作系统就按照这个来卸载相应的SQLSERVER组件
数据库引擎
MSDTS
通知服务
分析服务
客户端组件
因为我的电脑里还安装了SQL Express，所以还有一个数据库引擎选项，在控制面板-》添加/删除程序 ，里面操作系统如何识别出
你当前系统里的SQLSRVER实例呢？其实从注册表里来的，注意看红框部分
SQLSERVER给每个组件分配了数字的，例如SQL企业版实例分配数字.1 ，SQLExpress版分配数字.3 ,其他组件也分配数字
.X
例如：
分析服务.4
报表服务.5
不过这些都没有规律的
当前系统里有的数据库实例
配置管理器里面的SQLSERVER启动参数
已经注册了的驱动程序
SQL Agent的一些配置参数，当你设置了作业的时候，设置的参数就保存在这个位置
OLAP的一些设置选项和参数
SQLSERVER的一些服务，包括：分析服务，全文检索，通知服务，报表服务，代理服务，Browser服务，SSIS服务
SMO对象的版本
-------------------------------------------------------华丽的分割线----------------------------------------------------------
总结
注册表部分就介绍到这里了，可能又长又臭，不过如果你读完了，恭喜你！！，你对SQLSERVER的认识又更深一步了o(∩_∩)o
如果大家有什么需要补充的，或者文章有不正确的，欢迎大家拍砖！！
![[Web-Frontend] Node.js-Schnellstart](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
