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,
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-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?|||> 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-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?
>|||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>...
> 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-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,
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>...
> > 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-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?
Showing posts with label win2000. Show all posts
Showing posts with label win2000. Show all posts
Wednesday, March 21, 2012
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?
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-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?
|||> 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-ACB5-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-23D900D6070A@.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.co m...
> 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]
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,
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-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?
|||> 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-ACB5-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-23D900D6070A@.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.co m...
> 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]
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 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]
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]
Wednesday, March 7, 2012
MSDE install problem
Hi,
My computer OS is win2000 +sp3, I download the MSDE setup file(sql2kdesksp3.exe), I followed the instruction of the microsoft web site to install the msde, but during the windows configure the SQL server desktop engine, it hangs up there. I checked the setup log file, it has no error, it goes to sqlredis.exe, and stop there.
Can any one help me for this?
I really appreciated!
zgWhat is the command line you are using to install msde?
-Kashif
Subscribe to:
Posts (Atom)