Re: MSDE and Sql Server 2005


"A Lake" <ALake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F238BB2A-F729-4375-99C9-5730488CE3AC@xxxxxxxxxxxxxxxx
I have a Windows 2003 server which has an instance of Sql Server 2005
(express I assume, showing as version 9) running on it that was installed
by
Backup Exec.

On this server is another application that installated an MSDE database
(showing as version 8).

I can see both databases OK on the server using Management Studio Express,
and I can see the Server 2005 database from other PCs. However I cannot
see
the MSDE database from anywhere else.

I've checked the configuration and using the surface configuration tool
(but
this doesn't show the MSDE database) I've checked the configuration
svrnetcn.exe tool and the port is correctly set to 1433. The database is
set
to allow remote connections over named pipes and tcpip.

So I'm stumped - nothing can connect to this database unless its on the
server itself. I have noticed that runing netstat shows that port 1433
isn't
open?

I think I have a customer with the same problem. If MSDE (named instance)
installed on a server with no other SQL Server, the customer can connect to
the database from either the server or a client workstation. If MSDE is
installed on a server with older version of SQL Server (before 2005), same
thing. However, if MSDE installed on W2k3 Server with SQL Server 2005,
customer can connect from the server, but not from a client (XP). It acts as
if SQL Server 2005 prevents MSDE from networking. SQL Server 2005 tools do
not see the MSDE instance.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--


.

Relevant Pages
Loading