MSDE Not connecting remotely  
Author Message
InsomniaKev





PostPosted: Sun Oct 17 23:21:58 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely

Hi Guys,

I have a client who is running SBS2003. We are in the process of moving an
msde 2000 database from WIN2000 server to this server.

We have installed MSDE 2000 and it is running on the new server. We can
connect and access the DB locally. However, we cannot establish a connection
from any PCs on the network. There is no firewall between the PCs and the
server. We have done a port scan on both servers and port 1433 is open on
the old server and not the new one. The netstat command however says the
port is open on the new server.

Can anyone tell me how to open up port 1433 on the server or any other
solutions?

SQL Server103  
 
 
David





PostPosted: Sun Oct 17 23:21:58 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely Dave,

You should be able to use C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\svrnetcn.exe to configure which library the instance
listens on (like TCP/IP).
If you do a netstat -aon | find ":1433" is sql have the port open?


--

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.


SBS Newsgroups:

SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs



> Hi Guys,
>
> I have a client who is running SBS2003. We are in the process of moving
an
> msde 2000 database from WIN2000 server to this server.
>
> We have installed MSDE 2000 and it is running on the new server. We can
> connect and access the DB locally. However, we cannot establish a
connection
> from any PCs on the network. There is no firewall between the PCs and the
> server. We have done a port scan on both servers and port 1433 is open on
> the old server and not the new one. The netstat command however says the
> port is open on the new server.
>
> Can anyone tell me how to open up port 1433 on the server or any other
> solutions?


 
 
David





PostPosted: Sun Oct 17 23:24:55 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely Dave,

Are you trying to get to the MSDE from the external side or internal side?
Do you have ISA installed? Is the SBS 2003 Std. Ed. or Premium Edition?

--

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.


SBS Newsgroups:

SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs



> Hi Guys,
>
> I have a client who is running SBS2003. We are in the process of moving
an
> msde 2000 database from WIN2000 server to this server.
>
> We have installed MSDE 2000 and it is running on the new server. We can
> connect and access the DB locally. However, we cannot establish a
connection
> from any PCs on the network. There is no firewall between the PCs and the
> server. We have done a port scan on both servers and port 1433 is open on
> the old server and not the new one. The netstat command however says the
> port is open on the new server.
>
> Can anyone tell me how to open up port 1433 on the server or any other
> solutions?


 
 
sayravi





PostPosted: Mon Oct 18 02:17:59 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely Hi Dave,

Use Client Network Utility from the client to configure for Network
Library(TCP/IP) and connection parameters (server name, 1433).

Ravi


> Hi Guys,
>
> I have a client who is running SBS2003. We are in the process of moving an
> msde 2000 database from WIN2000 server to this server.
>
> We have installed MSDE 2000 and it is running on the new server. We can
> connect and access the DB locally. However, we cannot establish a connection
> from any PCs on the network. There is no firewall between the PCs and the
> server. We have done a port scan on both servers and port 1433 is open on
> the old server and not the new one. The netstat command however says the
> port is open on the new server.
>
> Can anyone tell me how to open up port 1433 on the server or any other
> solutions?
 
 
Dave





PostPosted: Mon Oct 18 02:45:02 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely > Are you trying to get to the MSDE from the external side or internal side?
> Do you have ISA installed? Is the SBS 2003 Std. Ed. or Premium Edition?

I am trying to access the MSDE from the internal network.

We are running SBS 2003 Std which does not include SQL server or ISA (It
sounds like it would have been a good idea to buy premium now doesn't it?)

I have run the svrnetcn.exe and TCP\IP is included. I have run the netstat
command you asked me to run and received the following information:

TCP 0.0.0.0:1433 0.0.0.0:0 Listening 5596
 
 
Dave





PostPosted: Mon Oct 18 02:55:02 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely Where will I find the Client Network Utility on MSDE2000? Will I need to
install MSDE onto my PC? I am using MSDE Plus 2.1 to try to establish a
connection. It works locally on the server.

I have tried creating an ODBC connection to the server, specifying port
1433, but this connection failed.

Is there a way to open port 1433 on SBS2003?



> Hi Dave,
>
> Use Client Network Utility from the client to configure for Network
> Library(TCP/IP) and connection parameters (server name, 1433).
>
> Ravi
>

> > Hi Guys,
> >
> > I have a client who is running SBS2003. We are in the process of moving an
> > msde 2000 database from WIN2000 server to this server.
> >
> > We have installed MSDE 2000 and it is running on the new server. We can
> > connect and access the DB locally. However, we cannot establish a connection
> > from any PCs on the network. There is no firewall between the PCs and the
> > server. We have done a port scan on both servers and port 1433 is open on
> > the old server and not the new one. The netstat command however says the
> > port is open on the new server.
> >
> > Can anyone tell me how to open up port 1433 on the server or any other
> > solutions?
>
 
 
sayravi





PostPosted: Mon Oct 18 12:05:06 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely If you install the sql server client tools you will get this client
network utility.


> Where will I find the Client Network Utility on MSDE2000? Will I need to
> install MSDE onto my PC? I am using MSDE Plus 2.1 to try to establish a
> connection. It works locally on the server.
>
> I have tried creating an ODBC connection to the server, specifying port
> 1433, but this connection failed.
>
> Is there a way to open port 1433 on SBS2003?
>

>
> > Hi Dave,
> >
> > Use Client Network Utility from the client to configure for Network
> > Library(TCP/IP) and connection parameters (server name, 1433).
> >
> > Ravi
> >

> > > Hi Guys,
> > >
> > > I have a client who is running SBS2003. We are in the process of moving an
> > > msde 2000 database from WIN2000 server to this server.
> > >
> > > We have installed MSDE 2000 and it is running on the new server. We can
> > > connect and access the DB locally. However, we cannot establish a connection
> > > from any PCs on the network. There is no firewall between the PCs and the
> > > server. We have done a port scan on both servers and port 1433 is open on
> > > the old server and not the new one. The netstat command however says the
> > > port is open on the new server.
> > >
> > > Can anyone tell me how to open up port 1433 on the server or any other
> > > solutions?
 
 
David





PostPosted: Mon Oct 18 22:39:00 CDT 2004 Top

SQL Server >> MSDE Not connecting remotely Dave,

At least on the server take a look at \%systemroom$\system32\cliconfg.exe.

If you run the tasklist /svc with the process id from the netstat -aon for
port 1433 does it show it as being owned by SQL? For example

netstat -aon | find ":1433"
TCP 0.0.0.0:1433 0.0.0.0:0 Listening 5596

tasklist /svc | find "5596"


You might also take a look in \program files\microsoft sql
server\instancename\log directory at the ERRORLOG files to verify that the
instance you are expecting on TCP Port 1433 is the one you expect.. since by
default SBS 2003 will install an SBSMonitoring (MSDE) and SharePoint (WMSDE)
instance (both of which are only configured to use Shared Memory)



--

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.


SBS Newsgroups:

SBS v4.x: microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs



> If you install the sql server client tools you will get this client
> network utility.
>


> > Where will I find the Client Network Utility on MSDE2000? Will I need
to
> > install MSDE onto my PC? I am using MSDE Plus 2.1 to try to establish a
> > connection. It works locally on the server.
> >
> > I have tried creating an ODBC connection to the server, specifying port
> > 1433, but this connection failed.
> >
> > Is there a way to open port 1433 on SBS2003?
> >

> >
> > > Hi Dave,
> > >
> > > Use Client Network Utility from the client to configure for Network
> > > Library(TCP/IP) and connection parameters (server name, 1433).
> > >
> > > Ravi
> > >


> > > > Hi Guys,
> > > >
> > > > I have a client who is running SBS2003. We are in the process of
moving an
> > > > msde 2000 database from WIN2000 server to this server.
> > > >
> > > > We have installed MSDE 2000 and it is running on the new server. We
can
> > > > connect and access the DB locally. However, we cannot establish a
connection
> > > > from any PCs on the network. There is no firewall between the PCs
and the
> > > > server. We have done a port scan on both servers and port 1433 is
open on
> > > > the old server and not the new one. The netstat command however
says the
> > > > port is open on the new server.
> > > >
> > > > Can anyone tell me how to open up port 1433 on the server or any
other
> > > > solutions?