Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!
"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell
|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:
> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> > We are running SBS 2003 Premium with SP1.
> > Each PC runs a small VB .exe, a booking program, which we use as a front
> > end
> > to SQL database.
> > Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> > trouble running the booking program. It hangs for up to 30 seconds at a
> > time
> > in different parts of the process but always, apparently, when it is
> > trying
> > to access the SQL data. A booking that should take no more than half a
> > minute
> > is now taking 5 minutes or more.
> > All other machines running the same program do not have a problem. I have
> > slowly eliminated user issues, log in issues and possible physical
> > (network)
> > problems.
> > Now I am baffled!
> > Any suggestions please!
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minut
e
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>