sql server msde: MSDE and XP SP2 -- sql server msde

You're in the

sql server msde

group:

MSDE and XP SP2

Nathan Thompson
10/4/2004 8:08:16 AM

sql server msde:

Hello everyone

Was anyone experienced problems with MSDE after XP SP2
was installed? I have a client's computer that is
running MBS Great Plains using MSDE SP3, that now is
displaying an error on boot that it cannont find the
default instance of SQL. Looking at the event viewer, I
noticed that the errors started after SP 2 was
installed. Any thoughts?

Re: MSDE and XP SP2

anonymous NO[at]SPAM discussions.microsoft.com
10/4/2004 10:42:38 AM

Thank you for your response,

I have referenced those documents, and tried opening the
suggested ports, and even went as far as shutting down
the firewall, but I still get the message. SQL Server
could not find the default instance (MSSQLSERVER)-please
specify the name of the existing instance on the
invocation of sqlservr.exe. It then suggests re-install

I am to that point to reinstall, but was hoping for a

Re: MSDE and XP SP2

Andrea Montanari
10/4/2004 7:17:07 PM

hi Nathan,
"Nathan Thompson" <anonymous@discussions.microsoft.com> ha scritto nel
messaggio news:413701c4aa23$f98b26c0$a601280a@phx.gbl
[quoted text, click to view]

XP sp2 installs and configure the Windows Firewall to close all ports so
that connection can be critical... you have to manually enable and open the
desired comunication ports ...
please have a look at
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251 and
http://support.microsoft.com/default.aspx?kbid=841249 to troubleshoot post
XP sp2 connection problems..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

RE: MSDE and XP SP2

Allan Halbert
10/5/2004 9:15:07 AM

[quoted text, click to view]

RE: MSDE and XP SP2

Allan Halbert
10/5/2004 9:41:03 AM

Hi Nathan,

I tried Andrea's recommendation, setting up sqlservr.exe as an exception. It
worked.

My app needed to be installed on a salesperson's computer to demonstrate. It
would find any of several server instances if that computer was connected to
a LAN. Once unplugged from the LAN, it couldn't find any server instance,
even with the SP2 firewall off.

The firewall still seems to block when off. I've had trouble getting Remote
Desktop Assistance or Remote Destop to work.

Allan Halbert

[quoted text, click to view]

Re: MSDE and XP SP2

Tony Taylor
10/5/2004 10:07:20 AM

[quoted text, click to view]

Hi Nathan

I've had the same problems and managed to fix them.

Can you post exactly what you've tried so that I can try to help without
just sending you info about things you've already done.

Cheers

MSDE 1 and SP2 (was: Re: MSDE and XP SP2)

Stefan M. Huber
10/7/2004 2:23:44 PM

On Mon, 4 Oct 2004 08:08:16 -0700, Nathan Thompson
[quoted text, click to view]

Yes, I have. But different ones. After opening port 1433/TCP, connecting
to the database worked again. But from Delphi5 using ADO, we have troubles:

Connecting to the database takes a lot of time. The funny thing is, that
our application does the same things as before. Then, at some point,
sqlsvr.exe starts working wildly: 100% CPU load, a lot of HD activity.
This takes soem time: 10 secs on fast machines, about 2 minutes on a
slower test machine. After that, operation continues normally.

Any hints, what may cause these troubles?

Can I enable verbose logging somewhere in MSDE to actually see which
queries are processed (like in Postgres)?

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn