#5 Login failed for MSDE instance.

[Mark Pawelek]

Hi,

I have installed an MSDE 2000 on my machine. Prior to
that I had SQL Server 2K installed.

I was able to login to my SQL Server 2k database with
ASP.NET Enterprise Manager.

This was the setup.ini I used to install MSDE 2K:
---------- ----------
[Options]
InstanceName="instance_name"
SAPWD="sa_password"
SecurityMode=SQL
---------- ----------

Note that when I installed MSDE 2K, I did NOT add the
line:

---------- ----------
DisableNetworkProtocols=0
---------- ----------

The options for this switch are 0 or 1. That was
probably a mistake on my behalf.

When I run ASP.NET Enterprise Manager I can't login to
the MSDE using the "sa" account with the instance
name and password I specified in the above setup.ini
file. I get a delay and eventually a "Login Failed" error
message, with this URL showing in my browser bar:

http://localhost/SQLEntMan_0.5.1/app/connect.aspx?
Error=Login%20Failed

I'm fairly certain MSDE 2K is running because I have 2
SQLservr.exe processes running, using 16M and 8M of
memory respectively. However, in the system tray only
the original SQL Server 2K instance is shown to be
running, so I can't be absolutely certain.

Does ASP.NET Enterprise Manager work with MSDE?

Should I execute Server Network Utility (svrnetcn.exe)
to enable more|other network protocol(s)?

[I'm doing this on a Win XP pro SP1 with .net 2003]

[Mark Pawelek]

Logged In: YES
user_id=728628

Apologies for the premature post but I have it working now.

After installing MSDE 2K, I ran server network utility and
installed:
Named Pipes
TCP/IP

for my new MSDE installation aka
machine_name\instance_name

After rebooting it now shows to be 'running' in my system
tray as an option of my SQL Server. I can connect to it via
QA, Ent Manager and ASP.NET Ent Manager.

Does one need both these network protocols?