Any SQL Server 2000 and XP SP2 issues?

There is a recent news article that indicates that Microsoft has "warned"
its customers about SQL Server 2000 (version not identified) not being
compatible with the XP SP 2.
I went to the MS website and searched everything I could find on the RTM
version of SP2. I found no such warning ... I found "issues" that could
come up if the Firewall is enabled and how to modify the settings so that
you could get to the SQL Server 2000 if there were problems.
I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
not including SP2 and wanted to make sure that I didn't do anything to screw
up our current development processes ... we're in the middle of a large dev
project and didn't want to bring everything to a grinding halt.
Yes, we will install SP2 and test to make sure that our .NET apps will work
under SP2 but I want to do it in a "controlled manner" ... not an
inadvertent shutdown in the middle.
Anyone know of any issues, other than the Firewall, that makes SQL Server
2000 incompatible with XP SP2?
Thanks...
Ron
Hi Ron,
Thanks for using MSDN Managed Newsgroup!
Here are some links showing why it is warned using SQL Server / MSDE with
XP SP2
"some programs may seem not to work. By default, Windows Firewall is
enabled and blocks unsolicited connections to your computer"
Some programs seem to stop working after you install Windows XP Service
Pack 2
http://support.microsoft.com/default.aspx?kbid=842242
"After you install Microsoft Windows XP Service Pack 2 on a computer that
is configured as a distributor, if you try to synchronize data from a
subscriber that is configured on a remote computer, you may notice that the
changes that are made in the subscriber database are not updated to the
publisher database."
BUG: The changes in a remote subscriber are not updated to the publisher
for a queued updating replication that uses Message Queuing on a
computer that is running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839278
"You may not be able to connect to an instance of SQL Server, and you may
receive one of the following error messages.
[Named Pipes]SQL Server does not exist or access denied.
Unable to connect to server <SQL Server instance name>"
You may not be able to connect to an instance of SQL Server that is
configured to use the Named Pipes server network library on a computer
that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=839269
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1"
You may receive a 7391 error message in SQL Server 2000 when you run a
distributed transaction against a linked server after you install Microsoft
Windows XP Service Pack 2
http://support.microsoft.com/?id=839279
" the SQL debugging feature in Microsoft Visual Studio .NET 2003 (Visual
Studio .NET) does not work. When you try to debug a SQL Server stored
procedure by using the Step Into Stored Procedure option in the Server
Explorer pane, you may receive the following error message:
Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug.
Run SQL Server setup or contact database administrator."
BUG: SQL debugging does not work in Visual Studio .NET after you install
Windows XP Service Pack 2
http://support.microsoft.com/?id=839280
"When you install Microsoft SQL Server 2000 or Microsoft SQL Server Desktop
Engine (also known as MSDE 2000) on a computer that is running Microsoft
Windows XP Service Pack 2 (SP2), a message is logged in the application
event log. The message states that the instance of SQL Server or the
instance of MSDE is vulnerable to virus attacks."
A message stating that an instance of SQL Server is vulnerable to virus
attacks is logged in the application event log when you install SQL Server
2000 or MSDE 2000 on a computer that is running Windows XP Service Pack 2
http://support.microsoft.com/?id=841375
"When you run a distributed transaction against an instance of SQL Server,
you may receive an error message that is similar to the following:
Server: Msg 7391, Level 16, State 1, Line 1 "
You may receive a 7391 error message in SQLOLEDB when you run a distributed
transaction against a linked server after you install Microsoft Windows XP
Service Pack 2
http://support.microsoft.com/?id=873160
Here is another very useful link for you about how to troubleshooting
Windows Firewall settings in Windows XP SP2
Troubleshooting Windows Firewall settings in Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=875357
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Ron,
Additionally, I would like to provide five HOW-TO articiles for
configuration SQL Server with XP SP2.
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/?id=841249
How to enable SQL Server connectivity on Windows XP Service Pack 2
http://support.microsoft.com/?id=841251
How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
2000
http://support.microsoft.com/?id=841252
How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack
2
http://support.microsoft.com/?id=841253
How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=842005
How to enable SQL Server 2000 Analysis Services and OLAP Services on
computers that are running Windows XP SP2
http://support.microsoft.com/?id=841256
How to use a script to programmatically open ports for SQL Server to use on
systems that are running Windows XP Service Pack 2
http://support.microsoft.com/default.aspx?kbid=839980
Thank you for your patience and cooperation again. If you have any
questions or concerns, don't hesitate to let me know. We are here to be of
assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thank you very much for both replies. Your replies were both thorough and
very helpful.
I will back the machines up and begin installing SP2 on Saturday.
Hopefully, I will be able to report successful and uneventful installations
on Monday.
Again, many thanks...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> Additionally, I would like to provide five HOW-TO articiles for
> configuration SQL Server with XP SP2.
> How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
> http://support.microsoft.com/?id=841249
> How to enable SQL Server connectivity on Windows XP Service Pack 2
> http://support.microsoft.com/?id=841251
> How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server
> 2000
> http://support.microsoft.com/?id=841252
> How to enable SQL Server 2000 Reporting Services on Windows XP Service
Pack
> 2
> http://support.microsoft.com/?id=841253
> How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=842005
> How to enable SQL Server 2000 Analysis Services and OLAP Services on
> computers that are running Windows XP SP2
> http://support.microsoft.com/?id=841256
> How to use a script to programmatically open ports for SQL Server to use
on
> systems that are running Windows XP Service Pack 2
> http://support.microsoft.com/default.aspx?kbid=839980
> Thank you for your patience and cooperation again. If you have any
> questions or concerns, don't hesitate to let me know. We are here to be of
> assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
want to wait. More details are at
http://support.microsoft.com/?kbid=839280. If anyone knows of a way
around this problem, please let me know.
Ken Kimball [kkimball@.gmail.com]
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...
> There is a recent news article that indicates that Microsoft has "warned"
> its customers about SQL Server 2000 (version not identified) not being
> compatible with the XP SP 2.
> I went to the MS website and searched everything I could find on the RTM
> version of SP2. I found no such warning ... I found "issues" that could
> come up if the Firewall is enabled and how to modify the settings so that
> you could get to the SQL Server 2000 if there were problems.
> I have installed MSDE on an XP Pro machine with all SPs and fixes up to but
> not including SP2 and wanted to make sure that I didn't do anything to screw
> up our current development processes ... we're in the middle of a large dev
> project and didn't want to bring everything to a grinding halt.
> Yes, we will install SP2 and test to make sure that our .NET apps will work
> under SP2 but I want to do it in a "controlled manner" ... not an
> inadvertent shutdown in the middle.
> Anyone know of any issues, other than the Firewall, that makes SQL Server
> 2000 incompatible with XP SP2?
> Thanks...
> Ron
|||Ken,
Yes, I was aware of that problem. I do use VS 2003 to develop apps but do
not use SQL Stored Procedures (for a number of reasons specific to our
apps).
I was very surprised to find the number of "issues" related to SQL Server
2000 given that is the current release of MS's SQL Server -- especially
since there is nothing to indicate that patches or fixes are forthcoming.
On the same XP Pro machine, I'm also running Oracle 9i and I'm hoping that
it doesn't come to a crashing halt as well. (These are used for
"development" and not for production databases)
Ron
"Ken Kimball" <kkimball@.gmail.com> wrote in message
news:466a0cb4.0408130512.4468a03a@.posting.google.c om...
> If you use Visual Studio.Net to debug SQL Stored Proceedures you'll
> want to wait. More details are at
> http://support.microsoft.com/?kbid=839280. If anyone knows of a way
> around this problem, please let me know.
> Ken Kimball [kkimball@.gmail.com]
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:<#i24S0HgEHA.904@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
"warned"[vbcol=seagreen]
that[vbcol=seagreen]
but[vbcol=seagreen]
screw[vbcol=seagreen]
dev[vbcol=seagreen]
work[vbcol=seagreen]
Server[vbcol=seagreen]
|||You might also check out:
Finally, you should absolutely watch and learn from the webcast titled MSDN
Webcast: SQL Server and Windows XP SP2 - Level 300 available at
http://msevents.microsoft.com/CUI/Ev...&Culture=en-US
I found it to be very helpful.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Ron Fluegge" <rmflugge@.swbell.net> wrote in message
news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
> Thank you very much for both replies. Your replies were both thorough and
> very helpful.
> I will back the machines up and begin installing SP2 on Saturday.
> Hopefully, I will be able to report successful and uneventful
installations[vbcol=seagreen]
> on Monday.
> Again, many thanks...
> Ron
> ""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
> news:g5WOYOOgEHA.3356@.cpmsftngxa06.phx.gbl...
Server[vbcol=seagreen]
> Pack
> on
of[vbcol=seagreen]
rights.
>
|||Brian,
Will do ... THANKS VERY MUCH!!!
Ron
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OOHq06UgEHA.1764@.TK2MSFTNGP10.phx.gbl...
> You might also check out:
> Finally, you should absolutely watch and learn from the webcast titled
'MSDN
> Webcast: SQL Server and Windows XP SP2 - Level 300 ' available at
>
http://msevents.microsoft.com/CUI/Ev...&Culture=en-US[vbcol=seagreen]
>
> I found it to be very helpful.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Ron Fluegge" <rmflugge@.swbell.net> wrote in message
> news:e9BEMnPgEHA.1972@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
> installations
message[vbcol=seagreen]
Server[vbcol=seagreen]
> Server
2[vbcol=seagreen]
use[vbcol=seagreen]
be
> of
> rights.
>
|||Hi Ron,
If you encounter any questions or concerns when upgrading to Windows XP
Service Pack 2, please feel free to reply here or make a new thread. We
would love to make a follow up until that issue is completely resolved.
Good Luck!
Thank you for your patience and cooperation.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||I just finished the upgrade to SP2 ... on this machine I have both SQL
Server 2000 and Oracle 9i as well as VS 2003 -- it's my development machine.
It all went well without a hitch!!!
Everything is up and running without any problems so far software or
hardware-wise. I have a dual AMD MoBo with RAID controllers and it is
having no problems.
So needless to say, I am a happy camper ...
Ron
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:v7ocVFcgEHA.480@.cpmsftngxa06.phx.gbl...
> Hi Ron,
> If you encounter any questions or concerns when upgrading to Windows XP
> Service Pack 2, please feel free to reply here or make a new thread. We
> would love to make a follow up until that issue is completely resolved.
> Good Luck!
> Thank you for your patience and cooperation.
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>