Re: MSDE Installation on a XP Professional WS.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Can't help you with 1 unfortunately - it has happened to me but I've never
quite worked out why...

To log in from an external computer you need to have set the
DISABLENETWORKPROTOLS flag to false when installing. See the readme that
comes with the installer for more details on command line switches.

Also, MSDE from Service Pack 3a onwards, installs in Windows Authentication
mode only by default. see the following kb article for more info:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q325022

If you're trying to access it from another machine that is not logged in as
a *domain* user on the same domain (i.e. you must be running a Windows 2003
Server Domain Controller somewhere) then you can only connect using Mixed
Mode Authentication, which as the above article will tell you is disabled by
default.

"Francesco Garganese" <FrancescoGarganese@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:CD18E7C6-6E32-4D27-974D-C744C580C820@xxxxxxxxxxxxxxxx
> Hello,
> I'm experiencing 2 problems after MSDE installation on a XP Pro
> workstation
> on a network.
> 1. The SQL Service Manager don't show the default instance. If I put
> manually is OK, but on every reboot it lose the instance name and show me
> nothing.
> 2. it's impossible to login from an external computer or create any kind
> of
> connection (ODBC or .udl file).
> For information the setup was make:
> with an .ini file containing
>
> [Options]
> INSTANCENAME=fgsoftware
> SAPWD=xyzxyz
> SECURITYMODE=SQL
>
> The computer is SP2 full patched.
>
> After the first problems I deactivated the windows firewall.
>
> Help me!!!
> TIA
> --
> Francesco Garganese
> FG software


.