RE: MSDE and Sql Server 2005

=?Utf-8?B?QSBMYWtl?= <ALake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:E9CF7CB1-7880-46DB-B0E8-152B686AC032@xxxxxxxxxxxxx:

Done some testing:

I can connect locally with osql, but only if I specify the instance
name i.e SERVER\DATABASE. if I specify the IP and port I get the same
error. (I tried using both 1433 and other ports as well)

osql cannot connect from any clients.

When I use port 1433 netstat -a doesn't show this port as listening,
but when I change to another port (i.e 1217) that does show as
listening but still with no connectivity.

Is the SQL Server Express 2005 blocking the MSDE SQL Server somehow? I
didn't have this problem on the previous server which only ran MSDE
databases?

"A Lake" wrote:

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?


http://support.microsoft.com/kb/265808 is not directly relevant but you may
find the techniques suggested to be helpful.
.

Relevant Pages
Loading