MS Sql Server loosing connection over WAN ..

Hello everyone.
We are experiencing a weird MS Sql Server behavior, and so far I have
not been able to identify the problem.. Any pointers will be deeply
appreciated.
Here is the scenario: we have three servers. One of them is running MS
Sql Server 2000, and the other two are application servers connecting
to the SQL Server. One of them is connecting over LAN, the other over
WAN. Every now and then, the one connecting over WAN becomes unable to
communicate with the SQL server. Even the Query Analyzer is not able
to connect (it cannot even get the list of databases to fill the
combo).
At the same time, the server connecting to SQL over LAN can connect
and function without any problems.
When the SQL server machine is rebooted, the server on WAN is able to
connect again...
I was suspenting some intermittent network problems, but at the time
the problem occurs, the SQL server and the problematic server on WAN
can ping each other without any problem and telnet from the server on
WAN to the SQL server port 1433 seems to work fine.
Configuration: All three servers running on Windows Server 2003 SP1,
SQL Server version is 2000 SP3a.
Where should we look into ?
Many thanks in advance,
Arifi Koseoglu
http://vyaskn.tripod.com/watch_your_timeouts.htm
check it out.
You should run a trace with profiler to capture info what happens in the
database when the problems acure.
Cheers
"arifi" wrote:

> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>
|||Sounds like this is a network issue, not a database issue. There could be a
resource limitation somewhere or something maybe happening on a router or
firewall somewhere that could be causing this.
MG
"arifi" wrote:

> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>
sql

MS Sql Server loosing connection over WAN ..

Hello everyone.
We are experiencing a weird MS Sql Server behavior, and so far I have
not been able to identify the problem.. Any pointers will be deeply
appreciated.
Here is the scenario: we have three servers. One of them is running MS
Sql Server 2000, and the other two are application servers connecting
to the SQL Server. One of them is connecting over LAN, the other over
WAN. Every now and then, the one connecting over WAN becomes unable to
communicate with the SQL server. Even the Query Analyzer is not able
to connect (it cannot even get the list of databases to fill the
combo).
At the same time, the server connecting to SQL over LAN can connect
and function without any problems.
When the SQL server machine is rebooted, the server on WAN is able to
connect again...
I was suspenting some intermittent network problems, but at the time
the problem occurs, the SQL server and the problematic server on WAN
can ping each other without any problem and telnet from the server on
WAN to the SQL server port 1433 seems to work fine.
Configuration: All three servers running on Windows Server 2003 SP1,
SQL Server version is 2000 SP3a.
Where should we look into ?
Many thanks in advance,
Arifi Koseogluhttp://vyaskn.tripod.com/watch_your_timeouts.htm
check it out.
You should run a trace with profiler to capture info what happens in the
database when the problems acure.
Cheers
"arifi" wrote:

> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>|||Sounds like this is a network issue, not a database issue. There could be a
resource limitation somewhere or something maybe happening on a router or
firewall somewhere that could be causing this.
--
MG
"arifi" wrote:

> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>

MS Sql Server loosing connection over WAN ..

Hello everyone.
We are experiencing a weird MS Sql Server behavior, and so far I have
not been able to identify the problem.. Any pointers will be deeply
appreciated.
Here is the scenario: we have three servers. One of them is running MS
Sql Server 2000, and the other two are application servers connecting
to the SQL Server. One of them is connecting over LAN, the other over
WAN. Every now and then, the one connecting over WAN becomes unable to
communicate with the SQL server. Even the Query Analyzer is not able
to connect (it cannot even get the list of databases to fill the
combo).
At the same time, the server connecting to SQL over LAN can connect
and function without any problems.
When the SQL server machine is rebooted, the server on WAN is able to
connect again...
I was suspenting some intermittent network problems, but at the time
the problem occurs, the SQL server and the problematic server on WAN
can ping each other without any problem and telnet from the server on
WAN to the SQL server port 1433 seems to work fine.
Configuration: All three servers running on Windows Server 2003 SP1,
SQL Server version is 2000 SP3a.
Where should we look into ?
Many thanks in advance,
Arifi Koseogluhttp://vyaskn.tripod.com/watch_your_timeouts.htm
check it out.
You should run a trace with profiler to capture info what happens in the
database when the problems acure.
Cheers
"arifi" wrote:
> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>|||Sounds like this is a network issue, not a database issue. There could be a
resource limitation somewhere or something maybe happening on a router or
firewall somewhere that could be causing this.
--
MG
"arifi" wrote:
> Hello everyone.
> We are experiencing a weird MS Sql Server behavior, and so far I have
> not been able to identify the problem.. Any pointers will be deeply
> appreciated.
> Here is the scenario: we have three servers. One of them is running MS
> Sql Server 2000, and the other two are application servers connecting
> to the SQL Server. One of them is connecting over LAN, the other over
> WAN. Every now and then, the one connecting over WAN becomes unable to
> communicate with the SQL server. Even the Query Analyzer is not able
> to connect (it cannot even get the list of databases to fill the
> combo).
> At the same time, the server connecting to SQL over LAN can connect
> and function without any problems.
> When the SQL server machine is rebooted, the server on WAN is able to
> connect again...
> I was suspenting some intermittent network problems, but at the time
> the problem occurs, the SQL server and the problematic server on WAN
> can ping each other without any problem and telnet from the server on
> WAN to the SQL server port 1433 seems to work fine.
> Configuration: All three servers running on Windows Server 2003 SP1,
> SQL Server version is 2000 SP3a.
> Where should we look into ?
> Many thanks in advance,
> Arifi Koseoglu
>

MS SQL Server 2000 destop engine install fails

Hello
This is a weird one.
Trying to install the MS SQL Server 2000 desktop engine but it fails without
error. In fact, the installer goes through the motions of installing and
then unwinds the install; the progress bar goes backwards?
setup.exe SAPWD="1232"
Any ideas?
TIA
Russell MorganRussell,
You can set up verbose logging that will give you information on your
setup to debug the problem. Below is a section of the readme that applies
and an example of the syntax of your setup string:
Requesting a Setup Log
You will need a verbose log to verify that the installation succeeded or to
assist in debugging any problems that occur.
To generate a verbose log, specify /L*v <LogFileName>. <LogFileName> is the
name of a log file where Setup will record all of its actions. If you do not
specify a path as part of the name, the log file is created in the current
folder. If you are executing Setup from a compact disc, you must specify the
full path to a folder on the hard disk of your computer.
This example creates a log file, MSDELog.log, in the root folder of the C:
drive:
setup SAPWD="AStrongSAPassword" /L*v C:/MSDELog.log
Hope this helps
"Russell J Morgan" wrote:

> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails witho
ut
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>
>|||I had this problem with Windows XP SP2
What is the Operating System?
Try to install MSDE200A it has a SP3 embedded:
http://www.microsoft.com/downloads/...&displaylang=en
Hope it helps.
"Russell J Morgan" <russell.morgan@.careervision.co.uk> escreveu na mensagem
news:uGh$qxUCFHA.1084@.tk2msftngp13.phx.gbl...
> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails
> without
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>

MS SQL Server 2000 destop engine install fails

Hello
This is a weird one.
Trying to install the MS SQL Server 2000 desktop engine but it fails without
error. In fact, the installer goes through the motions of installing and
then unwinds the install; the progress bar goes backwards?
setup.exe SAPWD="1232"
Any ideas?
TIA
Russell MorganRussell,
You can set up verbose logging that will give you information on your
setup to debug the problem. Below is a section of the readme that applies
and an example of the syntax of your setup string:
Requesting a Setup Log
You will need a verbose log to verify that the installation succeeded or to
assist in debugging any problems that occur.
To generate a verbose log, specify /L*v <LogFileName>. <LogFileName> is the
name of a log file where Setup will record all of its actions. If you do not
specify a path as part of the name, the log file is created in the current
folder. If you are executing Setup from a compact disc, you must specify the
full path to a folder on the hard disk of your computer.
This example creates a log file, MSDELog.log, in the root folder of the C:
drive:
setup SAPWD="AStrongSAPassword" /L*v C:/MSDELog.log
Hope this helps
"Russell J Morgan" wrote:
> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails without
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>
>|||I had this problem with WINDOWS XP SP2
What is the Operating System?
Try to install MSDE200A it has a SP3 embedded:
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en
Hope it helps.
"Russell J Morgan" <russell.morgan@.careervision.co.uk> escreveu na mensagem
news:uGh$qxUCFHA.1084@.tk2msftngp13.phx.gbl...
> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails
> without
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>

MS SQL Server 2000 destop engine install fails

Hello
This is a weird one.
Trying to install the MS SQL Server 2000 desktop engine but it fails without
error. In fact, the installer goes through the motions of installing and
then unwinds the install; the progress bar goes backwards?
setup.exe SAPWD="1232"
Any ideas?
TIA
Russell Morgan
Russell,
You can set up verbose logging that will give you information on your
setup to debug the problem. Below is a section of the readme that applies
and an example of the syntax of your setup string:
Requesting a Setup Log
You will need a verbose log to verify that the installation succeeded or to
assist in debugging any problems that occur.
To generate a verbose log, specify /L*v <LogFileName>. <LogFileName> is the
name of a log file where Setup will record all of its actions. If you do not
specify a path as part of the name, the log file is created in the current
folder. If you are executing Setup from a compact disc, you must specify the
full path to a folder on the hard disk of your computer.
This example creates a log file, MSDELog.log, in the root folder of the C:
drive:
setup SAPWD="AStrongSAPassword" /L*v C:/MSDELog.log
Hope this helps
"Russell J Morgan" wrote:

> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails without
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>
>
|||I had this problem with WINDOWS XP SP2
What is the Operating System?
Try to install MSDE200A it has a SP3 embedded:
http://www.microsoft.com/downloads/d...displaylang=en
Hope it helps.
"Russell J Morgan" <russell.morgan@.careervision.co.uk> escreveu na mensagem
news:uGh$qxUCFHA.1084@.tk2msftngp13.phx.gbl...
> Hello
> This is a weird one.
> Trying to install the MS SQL Server 2000 desktop engine but it fails
> without
> error. In fact, the installer goes through the motions of installing and
> then unwinds the install; the progress bar goes backwards?
> setup.exe SAPWD="1232"
> Any ideas?
> TIA
> Russell Morgan
>