在 vmware (Windows XP) 上安装 sql server 2000 时出错
安装程序崩溃，并指示检查 c:\windows\sqlstp.log 以获取更多信息，以下是日志包含的内容：
Connecting to Server ...
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
SQL Server configuration failed.
###############################################################################
15:57:07 Process Exit Code: (-1)
15:57:11 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
15:57:11 Action CleanUpInstall:
15:57:11 C:\DOCUME~1\15876\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
15:57:12 Process Exit Code: (1060) The specified service does not exist as an installed service.
15:57:12 C:\DOCUME~1\15876\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
15:57:12 Process Exit Code: (0)
15:57:12 StatsGenerate returned: 2
15:57:12 StatsGenerate (0x0,0x1,0xf000000,0x300,1033,303,0x0,0x1,0,0,0
15:57:12 StatsGenerate -1,15876)
15:57:12 Installation Failed.
我尝试在仅主机、NAT 和桥接之间切换网络，完全断开网络连接，以及尝试过的其他操作将虚拟机 RAM 增加到 1GB。
似乎没有什么帮助。 知道我该如何解决这个问题吗？
The installer crashes with instruction to check c:\windows\sqlstp.log for more information, here's what the log contains:
Connecting to Server ...
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
driver={sql server};server=JJOHN-vm;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
SQL Server configuration failed.
###############################################################################
15:57:07 Process Exit Code: (-1)
15:57:11 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
15:57:11 Action CleanUpInstall:
15:57:11 C:\DOCUME~1\15876\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
15:57:12 Process Exit Code: (1060) The specified service does not exist as an installed service.
15:57:12 C:\DOCUME~1\15876\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
15:57:12 Process Exit Code: (0)
15:57:12 StatsGenerate returned: 2
15:57:12 StatsGenerate (0x0,0x1,0xf000000,0x300,1033,303,0x0,0x1,0,0,0
15:57:12 StatsGenerate -1,15876)
15:57:12 Installation Failed.
I have tried switching the network between host-only, NAT and bridged, disconnecting the network altogether, and among other things tried increasing the vm RAM TO 1gb as well.
Nothing seems to help. Any idea how I can fix this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
好吧，我在休息了很长一段时间后又开始尝试这个...
事实证明，这是 HOSTNAME 的问题:) !!!
SQL Server 2000 不会安装在分配了大小写混合或小写主机名的主机上。 我重命名了系统并且运行良好。
如果您不愿意重命名您的组件，Microsoft 提供了一个修补程序来解决此问题：http: //support.microsoft.com/kb/285100/en-us。
Well, I got back to trying this out after a long break...
As it turns out, this is a problem with the HOSTNAME :) !!!
SQL server 2000 will not install on hosts assigned a mixed case or lowercase hostname. I renamed the system and it worked fine.
Microsoft provides a hotfix to correct the issue if you're averse to renaming your comp: http://support.microsoft.com/kb/285100/en-us .
所以从日志中我们可以看到MSSQLSERVER服务确实安装了（而SQLSERVERAGENT没有安装，这是不相关的）。 安装程序尝试使用共享内存协议访问新安装的服务器，但失败。 我想知道为什么会发生这种情况。 网络配置与此处无关。
你有什么东西可以阻止共享内存的事情吗？ 可能是具有防泄漏检测功能的高级防火墙。
您是否提供了一些奇特的命令行密钥来不安装服务器的某些部分或在安装后不启动服务？
So from the log we can see that MSSQLSERVER service is indeed installed (and SQLSERVERAGENT is not which is irrelevant). The installer tries to access newly installed server using shared memory protocol and fails. I wonder why this might happen. Network configuration isn't relevant here.
Do you have something that prevents shared memory stuff? Could be an advanced firewall with anti-leak detection.
Did you provide some fancy command line keys to not install some parts of the server or to not start the service once it's installed?
如果您尝试通过 RDP 会话安装 SQL Server 2000，它总是会崩溃。 如果您仍在虚拟机的控制台上安装它，则可能仍然是类似的问题。
SQL Server 2000 will always crash if you try to install it through an RDP session. If you ware still installing it at the console of the VM, it might still be a similar issue.