Cannot connect to MSDE database from Enterprise Manager

Hello,
I try to access a MSDE 2000 3.0a Database installed on Windows Server 2003 a
s the default instance.
MSDE has been installed with the following options:
[Options]
TARGETDIR="C:\Program Files\MSDE 2000\"
SAPWD="<My Password>"
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
I try to connect to this MSDE database from another machine where SQL Server
2000 3.0a is running, using the Enterprise Manager.
In Enterprise Manager I enter the IP-address of the server where the MSDE-da
tabase is running and choose the option "Connect using the SQl server login
information..." where I enter "sa" and "<My Password>", the same assigned to
MSDE during setup.
As result I always get the message: "SQL Server does not exist or access is
denied. ConnectionOpen (Connect())".
I don't have any more ideas about what might be wrong...
Can anybody help me please?Are you sure MSDE isn't a named instance (so you would enter <ip
address>\<instance name> )?
"Roberto Rocco" <roberto@.rocco.de> wrote in message
news:eHYPhUZ0DHA.3196@.TK2MSFTNGP11.phx.gbl...
Hello,
I try to access a MSDE 2000 3.0a Database installed on Windows Server 2003
as the default instance.
MSDE has been installed with the following options:
[Options]
TARGETDIR="C:\Program Files\MSDE 2000\"
SAPWD="<My Password>"
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
I try to connect to this MSDE database from another machine where SQL Server
2000 3.0a is running, using the Enterprise Manager.
In Enterprise Manager I enter the IP-address of the server where the
MSDE-database is running and choose the option "Connect using the SQl server
login information..." where I enter "sa" and "<My Password>", the same
assigned to MSDE during setup.
As result I always get the message: "SQL Server does not exist or access is
denied. ConnectionOpen (Connect())".
I don't have any more ideas about what might be wrong...
Can anybody help me please?|||Hello Foo,
thank you for your fast reply. Yes, I am sure that it is the default
instance.
Meanwhile I made some other tests: Running the same MSDE installation on
another machine (Windows XP) with the same Options.ini file (same settings,
same password, etc.) works pretty well!!
So I guess it must be "something" on the Windows 2003 Server.
I checked if it has a firewall configured, but it has not.
Can some ports be disabled on the Windows 2003 Server?
Are there other places to check?
Roberto.
"Foo Man Chew" <foo@.man.chew> schrieb im Newsbeitrag
news:OHbGqBa0DHA.2580@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Are you sure MSDE isn't a named instance (so you would enter <ip
> address>\<instance name> )?
>
>
> "Roberto Rocco" <roberto@.rocco.de> wrote in message
> news:eHYPhUZ0DHA.3196@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I try to access a MSDE 2000 3.0a Database installed on Windows Server 2003
> as the default instance.
> MSDE has been installed with the following options:
> [Options]
> TARGETDIR="C:\Program Files\MSDE 2000\"
> SAPWD="<My Password>"
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> I try to connect to this MSDE database from another machine where SQL

---

Server

quote:

---

> 2000 3.0a is running, using the Enterprise Manager.
> In Enterprise Manager I enter the IP-address of the server where the
> MSDE-database is running and choose the option "Connect using the SQl

---

server

quote:

---

> login information..." where I enter "sa" and "<My Password>", the same
> assigned to MSDE during setup.
> As result I always get the message: "SQL Server does not exist or access

---

is

quote:

---

> denied. ConnectionOpen (Connect())".
> I don't have any more ideas about what might be wrong...
> Can anybody help me please?
>

---

|||Problem solved!
Port 1433 was blocked on the Windows 2003 Server. After adjusting the Packet
Filter Policies to permit Port 1433 access I was able to connect to the MSDE
database.
Thanks all for your support.
Roberto.
"Roberto Rocco" <roberto@.rocco.de> schrieb im Newsbeitrag
news:OTXwf%23f0DHA.1532@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hello Foo,
> thank you for your fast reply. Yes, I am sure that it is the default
> instance.
> Meanwhile I made some other tests: Running the same MSDE installation on
> another machine (Windows XP) with the same Options.ini file (same

---

settings,

quote:

---

> same password, etc.) works pretty well!!
> So I guess it must be "something" on the Windows 2003 Server.
> I checked if it has a firewall configured, but it has not.
> Can some ports be disabled on the Windows 2003 Server?
> Are there other places to check?
> Roberto.
> "Foo Man Chew" <foo@.man.chew> schrieb im Newsbeitrag
> news:OHbGqBa0DHA.2580@.TK2MSFTNGP09.phx.gbl...
2003[QUOTE]
> Server
> server
> is
>

---

|||Hi.
I have the same problem, I have changed the TCP/IP filtering under the
TCP/IP setting on the network adapter to 'Enable TCP/IP Filtering' and
set to 'Permit All' on all types, but it still doesn't work. Are you
talking about something else? If so can you post a short guide of what
to change and where it is found in the Windows 2003 maze.
Thanks
Best Regards
Andrew.
da644
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message238297.html