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 connectio
n
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,
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
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:AE297F27-ACB5-4C46-B652-9E29EE39DC0C@.microsoft.com...
> 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,
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
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:AE297F27-ACB5-4C46-B652-9E29EE39DC0C@.microsoft.com...
> 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?|||Hi Dave,
Use Client Network Utility from the client to configure for Network
Library(TCP/IP) and connection parameters (server name, 1433).
Ravi
"Dave" <Dave@.discussions.microsoft.com> wrote in message news:<AE297F27-ACB5-4C46-B652-9E29E
E39DC0C@.microsoft.com>...
> Hi Guys,
> I have a client who is running SBS2003. We are in the process of moving a
n
> 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 connect
ion
> 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?|||> 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|||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?
"Ravi" wrote:
> Hi Dave,
> Use Client Network Utility from the client to configure for Network
> Library(TCP/IP) and connection parameters (server name, 1433).
> Ravi
> "Dave" <Dave@.discussions.microsoft.com> wrote in message news:<AE297F27-AC
B5-4C46-B652-9E29EE39DC0C@.microsoft.com>...
>|||If you install the sql server client tools you will get this client
network utility.
"Dave" <Dave@.discussions.microsoft.com> wrote in message news:<F83A4647-58A5-4D55-8FAB-23D90
0D6070A@.microsoft.com>...[vbcol=seagreen]
> 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?
> "Ravi" wrote:
>|||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
"Ravi" <sayravi@.yahoo.com> wrote in message
news:838d29e0.0410180905.f443d40@.posting.google.com...
> If you install the sql server client tools you will get this client
> network utility.
> "Dave" <Dave@.discussions.microsoft.com> wrote in message
news:<F83A4647-58A5-4D55-8FAB-23D900D6070A@.microsoft.com>...[vbcol=seagreen]
to[vbcol=seagreen]
news:<AE297F27-ACB5-4C46-B652-9E29EE39DC0C@.microsoft.com>...[vbcol=seagreen]
moving an[vbcol=seagreen]
can[vbcol=seagreen]
connection[vbcol=seagreen]
and the[vbcol=seagreen]
open on[vbcol=seagreen]
says the[vbcol=seagreen]
other[vbcol=seagreen]
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment