8,327
社区成员
发帖
与我相关
我的任务
分享IIS和SQLserver有冲突吗？哪位大侠给个说法
我这几天把IIS配置好了，用的也挺好的，后来我又做了个FTP服务，也挺好的，后来我装了微软的SQLserver，它要我启动时我没有启动。后来第二天来一开机，IIS里的目录就全被删除了!是不是他们俩个有冲突啊，还是别的原因啊!哪位帮小弟搞定，200分谢意!
...全文
请发表友善的回复…
发表回复
andyilove 2003-05-25
- 打赏
- 举报
重装也不行啊!漏洞我都补了。用X-SCAN扫的没有漏洞啊!
goingdown 2003-05-16
- 打赏
- 举报
装了以后漏洞没补，屁股漏出来了...被人踢了一脚！
tata_1980 2003-05-16
- 打赏
- 举报
http://support.microsoft.com/default.aspx?scid=kb;EN-US;249310
tata_1980 2003-05-16
- 打赏
- 举报
BUG: Install of SQL Server 6.5 on Windows 2000 Modifies DTC Service
The information in this article applies to:
Microsoft SQL Server 6.5, when used with:
the operating system: Microsoft Windows 2000
This article was previously published under Q249310
BUG #: 18597 (SQLBUG_65)
SYMPTOMS
When you install SQL Server 6.5 from the CD, and you then install the Microsoft SQL Server Service Pack 5a (which is required to run SQL Server 6.5 on Microsoft Windows 2000), the service pack installation removes the Microsoft Windows 2000 version of the Distributed Transaction Coordinator (DTC) service and replaces it with the MSDTC service from the SQL Server 6.5 CD or service pack 5a. To see this, open Control Panel, double-click the Administrative Tools icon and then double-click Services.
Another way to see this is to click Start, point to Programs, point to Administrative Tools, point to Computer Management, point to System Tools, point to System Information, point to Software Environment, and then double-click the Loaded Modules folder. The Msdtc.exe process should be there. However, after you install SQL Server 6.5, Msdtc.exe is run from the Mssql\Binn folder of SQL Server 6.5, rather than the Winnt\System32 folder, and the version number for the module is not that of the original Windows 2000 (which is 1999.9.3422.24).
Another indication that this problem occurred is if you find the following entry in your Microsoft Windows Event Viewer (Application) Log:
Event Type:Error Event Source:MSDTC Event Category:SVC Event ID:4377 Date:5/21/2000 Time:3:15:24 PM User:N/A Computer:TESTCOMPUTER Description: Running "msdtc -remove" is no longer supported. To un-install MSDTC please contact product support. To configure this system to use a remote MSDTC as the coordinator please use the Component Services Explorer.
Another possible Description may be:
The description for Event ID ( 4377 ) in Source ( MSDTC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: .
CAUSE
SQL Server 6.5 and service pack 5a has an add on program, DTC, which runs as part of the larger SQL Server install process. The version checking for this DTC install package was developed prior to the creation of Windows 2000, and the DTC package is consequently unaware of the Windows 2000 version.
So, both SQL Server 6.5 and the service pack 5a installation packages run the Dtcsetup.exe from the wrong place, which in this case is from either the SQL Server 6.5 CD or service pack 5a.
WORKAROUND
If the Windows 2000 version of Dtcsetup.exe is located on either the Windows CD or in the C:\Winnt\System32 folder, and has the following properties:
File Version 1999.9.342x.x
Product Version of 3.00.00.342x
You can then run that Dtcsetup.exe file, which then properly reconfigures the Distributed Transaction Coordinator service back to the correct state.
WARNING: If the MSSQLServer service is running when you run the Dtcsetup.exe, then that service will be stopped. Also, in some cases it may be necessary to set the MSDTC and IISAdmin services to DISABLED and to then reboot the computer, before you successfully run the Dtcsetup.exe.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.
The information in this article applies to:
Microsoft SQL Server 6.5, when used with:
the operating system: Microsoft Windows 2000
This article was previously published under Q249310
BUG #: 18597 (SQLBUG_65)
SYMPTOMS
When you install SQL Server 6.5 from the CD, and you then install the Microsoft SQL Server Service Pack 5a (which is required to run SQL Server 6.5 on Microsoft Windows 2000), the service pack installation removes the Microsoft Windows 2000 version of the Distributed Transaction Coordinator (DTC) service and replaces it with the MSDTC service from the SQL Server 6.5 CD or service pack 5a. To see this, open Control Panel, double-click the Administrative Tools icon and then double-click Services.
Another way to see this is to click Start, point to Programs, point to Administrative Tools, point to Computer Management, point to System Tools, point to System Information, point to Software Environment, and then double-click the Loaded Modules folder. The Msdtc.exe process should be there. However, after you install SQL Server 6.5, Msdtc.exe is run from the Mssql\Binn folder of SQL Server 6.5, rather than the Winnt\System32 folder, and the version number for the module is not that of the original Windows 2000 (which is 1999.9.3422.24).
Another indication that this problem occurred is if you find the following entry in your Microsoft Windows Event Viewer (Application) Log:
Event Type:Error Event Source:MSDTC Event Category:SVC Event ID:4377 Date:5/21/2000 Time:3:15:24 PM User:N/A Computer:TESTCOMPUTER Description: Running "msdtc -remove" is no longer supported. To un-install MSDTC please contact product support. To configure this system to use a remote MSDTC as the coordinator please use the Component Services Explorer.
Another possible Description may be:
The description for Event ID ( 4377 ) in Source ( MSDTC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: .
CAUSE
SQL Server 6.5 and service pack 5a has an add on program, DTC, which runs as part of the larger SQL Server install process. The version checking for this DTC install package was developed prior to the creation of Windows 2000, and the DTC package is consequently unaware of the Windows 2000 version.
So, both SQL Server 6.5 and the service pack 5a installation packages run the Dtcsetup.exe from the wrong place, which in this case is from either the SQL Server 6.5 CD or service pack 5a.
WORKAROUND
If the Windows 2000 version of Dtcsetup.exe is located on either the Windows CD or in the C:\Winnt\System32 folder, and has the following properties:
File Version 1999.9.342x.x
Product Version of 3.00.00.342x
You can then run that Dtcsetup.exe file, which then properly reconfigures the Distributed Transaction Coordinator service back to the correct state.
WARNING: If the MSSQLServer service is running when you run the Dtcsetup.exe, then that service will be stopped. Also, in some cases it may be necessary to set the MSDTC and IISAdmin services to DISABLED and to then reboot the computer, before you successfully run the Dtcsetup.exe.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.
dacos5984 2003-05-15
- 打赏
- 举报
win 2000+sql server决不会冲突，要不微软就别做了，一定是其它原因
zhanghy2 2003-05-14
- 打赏
- 举报
iis和sqlserver肯定没有冲突，你重装一下系统好了
ceocio 2003-05-14
- 打赏
- 举报
可能是其他原因造成的。
qiangsheng 2003-05-13
- 打赏
- 举报
实在因为你的问题太没边际，不知道怎么回答。
你的IIS中目录全被删除了，能够再建立新目录吗？能够正常访问吗？
你的IIS中目录全被删除了，能够再建立新目录吗？能够正常访问吗？
andyilove 2003-05-13
- 打赏
- 举报
到底是什么其它原因说清楚点行吗？我现在想把IIS卸了也卸不了。想重装都重装不起来。到底哪位大哥能给我解决这个问题啊？如果分不够我可以在加尽管开口！
只要能把我的IIS重新弄好。
只要能把我的IIS重新弄好。
wqccnu 2003-05-12
- 打赏
- 举报
是SQLserver的原因，但不是冲突的原因，因为SQLserver的设置值优先于IIs，所以你在它要求启动时没有进行启动，系统会进行默认操作，即替代性操作。你的IIS的目录就就是被替代的
qiangsheng 2003-05-12
- 打赏
- 举报
没有任何冲突，你的目录被删有其他原因。
