Don,
Thanks for your posting. From SQL side we do not have any know issues. I
also fail to understand how SQL SP2 would break NAT.
Let's first check the basics.
- Start with a Windows 2000 server without SQL SP2 that works. Test the
behavior.
- Reboot your Windows 2000 Server.
- Stop all the non-default services (list of default services listed on
Q192710 link found bellow)
- Close all applications, including anti-virus.
- The ONLY thing to do after a clean start, is install SQL Server 2000 SP2
and then reboot the Windows 2000 server again.
Do you still experience that behavior?
Q192710 INF: Basic Guidelines for Installing SQL Server 6.5 or 7.0
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q192710
If this does not resolve the behavior, and you would like to pursue this
issue, please open a case with Microsoft Product Support Services (PSS).
Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| I had the same Problem, i took me 3 installations to find out, that it was
| the sp2.
| Is there a patch from MS?
|
| Frank
| > Pardon my posting to multiple news groups, but I am
| > trying to get this message out to anyone who might benefit
| > from the information a priori.
| >
| > A number of us have determined that if you are using Network
| > Address Translation under Windows 2000 server or advanced
| > server and you are running SQLserver 2000 on the same server,
| > the installation of SQLserver 2000 SP2 will cause NAT to fail.
| >
| > The symptom seen is that CLIENT systems on the LAN that are
| > using the server for NAT are no longer able to browse certain
| > web sites correctly. Failing web pages typically do not load all
| > of the graphics or applets associated with the page even though
| > the remainder of the page loads correctly. Often you can force the
| > missing graphic to load by doing a right mouse click on it and selecting
| > "show picture." Everything works correctly when browsing the web
| > from the server system itself.
| >
| > Since there is no "uninstall" option for SQLserver 2000 SP2, the only
| > known resolution for this problem is to totally recreate the server
system
| > from scratch.
| >
| > Hopefully if you use NAT on Windows 2000 and you are also running
| > SQLserver 2000, you will see this note before you install SQL SP2.
| >
| > Don Miller
by