XP Guest issue

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Steven J. Reed (Reed_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 14:57:06 -0700

I have successfully created a database on my XP Home machine (SP1) that has
MSDE 2000 SP3a installed through my application and can fully utilize it.

However, if I log off then login as Guest, I get the message 'Login failed
for user 'machinename\Guest''.

Also, accessing the XP machine through my network using Enterprise Manager
based on my Windows 2000 machine, I get the message 'A connection could not
be established to machinename. Reason: Login failed for user
'machinename\Guest'..

I have used Svrnetcn.exe to establish Named Pipes & TCP/IP on the machine,
so at least I can see it from Enterprise manager, but I can't login. I'va
also tried using osql to add user Guest, but still no luck.

Any ideas? It seems to be XP related, since it works on 2000 machines.

Relevant Pages

  • RE: VSnet.ide cannot see local SQL db, but Enterprise Manager can
    ... added a new login for the new MSDE instance, ... I cannot get the connection to my SQLServer instance working. ... > I can register this instance in Enterprise Manager, ...
    (microsoft.public.vsnet.ide)
  • How to Replicate using OSQL?
    ... I've installed a MSDE 2000 in a remote Computer. ... and set subscriber from OSQL? ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Replication with MSDE
    ... If you have the Enterprise Edition tools (i.e. Enterprise Manager) you can ... However, when you put MSDE on other machines, you will ultimately need to ... run the distributor script for that machine and then the publication ... > SQL Server 2000 Enterise installed. ...
    (microsoft.public.sqlserver.ce)
  • Re: MSDE login problem - URGENT.
    ... Enterprise manager on my notebook can connect to MSDE. ... And the server is registered in EM with sa / 123 as opposed to using Windows ... laptop, I guess) and go into Properties, then select the Security tab. ...
    (microsoft.public.vb.general.discussion)
  • Re: Moving database and repositories
    ... Enterprise Manager is a part of the SQL Server installation (not MSDE). ... may ask your IT if they have one installed anywhere on network (most likely ...
    (microsoft.public.windowsxp.embedded)