connection problem

One customer reported they were having problem with their Access database
that is
linked to our SQL Server. They had to relink the tables every 30 minutes
when working on the db. Where should I look on the SQL server to determine
if this is SQL server related or network related?
Thanks,
Bing"bing" <bing@.discussions.microsoft.com> wrote in message
news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> One customer reported they were having problem with their Access database
> that is
> linked to our SQL Server. They had to relink the tables every 30 minutes
> when working on the db. Where should I look on the SQL server to
determine
> if this is SQL server related or network related?
What problem were they having? And, what versions of products are being
used? More information is better in this case ;)
Steve|||This is SQL server 2000 with SP3a installed on Windows 2003.
I just checked the Application logs in the Even Viewer on the SQL server and
found the following errors repeated every 30 minutes that seems to match the
problem symtom the customer is having. I've searched on the web and looks
like the problem has something to do with group policy.
Could these errors be the cause of the problem? Are they that bad that can
break connection between the client and the server?
==========Type Date Time Source Category Event User Computer
Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
==========
Would anybody give any insight on this? Thanks much in advance.
Bing
"Steve Thompson" wrote:
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > One customer reported they were having problem with their Access database
> > that is
> > linked to our SQL Server. They had to relink the tables every 30 minutes
> > when working on the db. Where should I look on the SQL server to
> determine
> > if this is SQL server related or network related?
> What problem were they having? And, what versions of products are being
> used? More information is better in this case ;)
> Steve
>
>|||According to the following article those errors occur if you are enforcing
IPSec. And, there is a hotfix for this issue -- not sure if it's related to
your linked tables issue but it's a start.
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> This is SQL server 2000 with SP3a installed on Windows 2003.
> I just checked the Application logs in the Even Viewer on the SQL server
and
> found the following errors repeated every 30 minutes that seems to match
the
> problem symtom the customer is having. I've searched on the web and
looks
> like the problem has something to do with group policy.
> Could these errors be the cause of the problem? Are they that bad that
can
> break connection between the client and the server?
> ==========> Type Date Time Source Category Event User Computer
> Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> ==========> Would anybody give any insight on this? Thanks much in advance.
> Bing
> "Steve Thompson" wrote:
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > One customer reported they were having problem with their Access
database
> > > that is
> > > linked to our SQL Server. They had to relink the tables every 30
minutes
> > > when working on the db. Where should I look on the SQL server to
> > determine
> > > if this is SQL server related or network related?
> >
> > What problem were they having? And, what versions of products are being
> > used? More information is better in this case ;)
> >
> > Steve
> >
> >
> >|||I thought hotfixes for specific issues were free of charge? If they are
telling you that you need to pay for this -- get back to me and we'll figure
out a way to get it to you.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> Ok, I'm stuck on get Microsoft Product Support Services. After taking
some
> time finding the product ID of the SQL server, MS said this ID cannot get
> no-charge support. Does that mean we have to pay to get this hotfix?
> Bing
> "Steve Thompson" wrote:
> > According to the following article those errors occur if you are
enforcing
> > IPSec. And, there is a hotfix for this issue -- not sure if it's related
to
> > your linked tables issue but it's a start.
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> >
> > Steve
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > >
> > > I just checked the Application logs in the Even Viewer on the SQL
server
> > and
> > > found the following errors repeated every 30 minutes that seems to
match
> > the
> > > problem symtom the customer is having. I've searched on the web
and
> > looks
> > > like the problem has something to do with group policy.
> > >
> > > Could these errors be the cause of the problem? Are they that bad
that
> > can
> > > break connection between the client and the server?
> > >
> > > ==========> > > Type Date Time Source Category Event User Computer
> > >
> > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > ==========> > >
> > > Would anybody give any insight on this? Thanks much in advance.
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > One customer reported they were having problem with their Access
> > database
> > > > > that is
> > > > > linked to our SQL Server. They had to relink the tables every 30
> > minutes
> > > > > when working on the db. Where should I look on the SQL server to
> > > > determine
> > > > > if this is SQL server related or network related?
> > > >
> > > > What problem were they having? And, what versions of products are
being
> > > > used? More information is better in this case ;)
> > > >
> > > > Steve
> > > >
> > > >
> > > >
> >
> >
> >|||My suggestion would be call into the queue, request the specific hotfix
noted in 823608, tell the support person that you need that specific hotfix
to solve your issue.
There is a note on that page:
"Note In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. "
As long as you do not bring up any other issue as part of that support call
it appears you would qualify.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> Thanks much, Steve, for getting back to this track. It's not any person
in
> MS who told me that. Following the link provided in the KB article you
> pointed out, I got on the support site. Next entered my personal passport
> email and password, selected product SQL server, selected No-Charge
Support,
> input the Product ID number for our SQL Server. Then I got the following
> message back:
> Products purchased under a Select License Agreement or Software Assurance
> Home Use Program are not eligible for no-charge support. You may go back
and
> choose another support option or enter another Product ID number.
> I did not know how I should proceed from there. Any advices would be
> greatly appreciated. A couple of more questions. The KB article with the
> title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
Log'
> says:
> " if you are not severely affected by this problem, Microsoft recommends
> that you wait for the next Windows Server 2003 service pack that contains
> this fix."
> Is there any more detailed information that tells what bad impacts these
> events could cause? I can not fully get what 'severely affected' really
> means. Any time table for when the next Windows Server 2003 service pack
> that contains this fix will be released?
> Bing
> "Steve Thompson" wrote:
> > I thought hotfixes for specific issues were free of charge? If they are
> > telling you that you need to pay for this -- get back to me and we'll
figure
> > out a way to get it to you.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > Ok, I'm stuck on get Microsoft Product Support Services. After taking
> > some
> > > time finding the product ID of the SQL server, MS said this ID cannot
get
> > > no-charge support. Does that mean we have to pay to get this hotfix?
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > According to the following article those errors occur if you are
> > enforcing
> > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
related
> > to
> > > > your linked tables issue but it's a start.
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > >
> > > > Steve
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > >
> > > > > I just checked the Application logs in the Even Viewer on the SQL
> > server
> > > > and
> > > > > found the following errors repeated every 30 minutes that seems to
> > match
> > > > the
> > > > > problem symtom the customer is having. I've searched on the
web
> > and
> > > > looks
> > > > > like the problem has something to do with group policy.
> > > > >
> > > > > Could these errors be the cause of the problem? Are they that bad
> > that
> > > > can
> > > > > break connection between the client and the server?
> > > > >
> > > > > ==========> > > > > Type Date Time Source Category Event User
Computer
> > > > >
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > > > ==========> > > > >
> > > > > Would anybody give any insight on this? Thanks much in advance.
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > One customer reported they were having problem with their
Access
> > > > database
> > > > > > > that is
> > > > > > > linked to our SQL Server. They had to relink the tables every
30
> > > > minutes
> > > > > > > when working on the db. Where should I look on the SQL server
to
> > > > > > determine
> > > > > > > if this is SQL server related or network related?
> > > > > >
> > > > > > What problem were they having? And, what versions of products
are
> > being
> > > > > > used? More information is better in this case ;)
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi Bing,
Sorry for the delay in responding -- comments in-line.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> Thanks much, Steve, for getting back to this track. It's not any person
in
> MS who told me that. Following the link provided in the KB article you
> pointed out, I got on the support site. Next entered my personal passport
> email and password, selected product SQL server, selected No-Charge
Support,
> input the Product ID number for our SQL Server. Then I got the following
> message back:
> Products purchased under a Select License Agreement or Software Assurance
> Home Use Program are not eligible for no-charge support. You may go back
and
> choose another support option or enter another Product ID number.
Please respond with a valid email address and I'll see if I can get you a
copy (no promises and no other requests!).
> I did not know how I should proceed from there. Any advices would be
> greatly appreciated. A couple of more questions. The KB article with the
> title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
Log'
> says:
> " if you are not severely affected by this problem, Microsoft recommends
> that you wait for the next Windows Server 2003 service pack that contains
> this fix."
> Is there any more detailed information that tells what bad impacts these
> events could cause?
That disclaimer is actually Microsoft normal -- they are stating that a
hotifx has not had the extensive regression testing that a service pack has
experienced. While it usually fixes the specific problem as advertised, they
cannot know of any and all colateral side effects that may be introduced. My
methodology has been, test in a lab, if it works, roll it out to QA then
production..
> I can not fully get what 'severely affected' really
> means.
Again, disclaimer time -- what is your threshold of pain ;) if you cannot
live without this hotfix then apply it.
>Any time table for when the next Windows Server 2003 service pack
> that contains this fix will be released?
Sources indicate that Windows Server 2003 SP1 will be available early next
year. Release dates are subject to change, etc, etc, etc.
Steve
> Bing
> "Steve Thompson" wrote:
> > I thought hotfixes for specific issues were free of charge? If they are
> > telling you that you need to pay for this -- get back to me and we'll
figure
> > out a way to get it to you.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > Ok, I'm stuck on get Microsoft Product Support Services. After taking
> > some
> > > time finding the product ID of the SQL server, MS said this ID cannot
get
> > > no-charge support. Does that mean we have to pay to get this hotfix?
> > >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > According to the following article those errors occur if you are
> > enforcing
> > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
related
> > to
> > > > your linked tables issue but it's a start.
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > >
> > > > Steve
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > >
> > > > > I just checked the Application logs in the Even Viewer on the SQL
> > server
> > > > and
> > > > > found the following errors repeated every 30 minutes that seems to
> > match
> > > > the
> > > > > problem symtom the customer is having. I've searched on the
web
> > and
> > > > looks
> > > > > like the problem has something to do with group policy.
> > > > >
> > > > > Could these errors be the cause of the problem? Are they that bad
> > that
> > > > can
> > > > > break connection between the client and the server?
> > > > >
> > > > > ==========> > > > > Type Date Time Source Category Event User
Computer
> > > > >
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM pc100
> > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM pc100
> > > > > ==========> > > > >
> > > > > Would anybody give any insight on this? Thanks much in advance.
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > One customer reported they were having problem with their
Access
> > > > database
> > > > > > > that is
> > > > > > > linked to our SQL Server. They had to relink the tables every
30
> > > > minutes
> > > > > > > when working on the db. Where should I look on the SQL server
to
> > > > > > determine
> > > > > > > if this is SQL server related or network related?
> > > > > >
> > > > > > What problem were they having? And, what versions of products
are
> > being
> > > > > > used? More information is better in this case ;)
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Bing,
Check your mail.
Steve
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C9D33B0B-09F9-4F4E-BB1C-160AA055A735@.microsoft.com...
> Thanks Steve for all the help. The valid email address is
bdu@.iastate.edu.
> Bing
> "Steve Thompson" wrote:
> > Hi Bing,
> >
> > Sorry for the delay in responding -- comments in-line.
> >
> > Steve
> >
> > "bing" <bing@.discussions.microsoft.com> wrote in message
> > news:28E58896-12A6-4A8E-ABED-08BD1FCC7856@.microsoft.com...
> > > Thanks much, Steve, for getting back to this track. It's not any
person
> > in
> > > MS who told me that. Following the link provided in the KB article
you
> > > pointed out, I got on the support site. Next entered my personal
passport
> > > email and password, selected product SQL server, selected No-Charge
> > Support,
> > > input the Product ID number for our SQL Server. Then I got the
following
> > > message back:
> > >
> > > Products purchased under a Select License Agreement or Software
Assurance
> > > Home Use Program are not eligible for no-charge support. You may go
back
> > and
> > > choose another support option or enter another Product ID number.
> >
> > Please respond with a valid email address and I'll see if I can get you
a
> > copy (no promises and no other requests!).
> >
> > > I did not know how I should proceed from there. Any advices would be
> > > greatly appreciated. A couple of more questions. The KB article with
the
> > > title 'Event ID 1091 and Event ID 1085 Appear in the Application Event
> > Log'
> > > says:
> > >
> > > " if you are not severely affected by this problem, Microsoft
recommends
> > > that you wait for the next Windows Server 2003 service pack that
contains
> > > this fix."
> > >
> > > Is there any more detailed information that tells what bad impacts
these
> > > events could cause?
> >
> > That disclaimer is actually Microsoft normal -- they are stating that a
> > hotifx has not had the extensive regression testing that a service pack
has
> > experienced. While it usually fixes the specific problem as advertised,
they
> > cannot know of any and all colateral side effects that may be
introduced. My
> > methodology has been, test in a lab, if it works, roll it out to QA then
> > production..
> >
> > > I can not fully get what 'severely affected' really
> > > means.
> >
> > Again, disclaimer time -- what is your threshold of pain ;) if you
cannot
> > live without this hotfix then apply it.
> >
> > >Any time table for when the next Windows Server 2003 service pack
> > > that contains this fix will be released?
> >
> > Sources indicate that Windows Server 2003 SP1 will be available early
next
> > year. Release dates are subject to change, etc, etc, etc.
> >
> > Steve
> >
> > > Bing
> > >
> > > "Steve Thompson" wrote:
> > >
> > > > I thought hotfixes for specific issues were free of charge? If they
are
> > > > telling you that you need to pay for this -- get back to me and
we'll
> > figure
> > > > out a way to get it to you.
> > > >
> > > > Steve
> > > >
> > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > news:1CC2B1D1-7950-4E8D-9CB9-B1B44871F8FE@.microsoft.com...
> > > > > Ok, I'm stuck on get Microsoft Product Support Services. After
taking
> > > > some
> > > > > time finding the product ID of the SQL server, MS said this ID
cannot
> > get
> > > > > no-charge support. Does that mean we have to pay to get this
hotfix?
> > > > >
> > > > > Bing
> > > > >
> > > > > "Steve Thompson" wrote:
> > > > >
> > > > > > According to the following article those errors occur if you are
> > > > enforcing
> > > > > > IPSec. And, there is a hotfix for this issue -- not sure if it's
> > related
> > > > to
> > > > > > your linked tables issue but it's a start.
> > > > > >
> > > >
> >
http://support.microsoft.com/default.aspx?scid=kb;en-us;823608&Product=winsvr2003
> > > > > >
> > > > > > Steve
> > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> > > > > > > This is SQL server 2000 with SP3a installed on Windows 2003.
> > > > > > >
> > > > > > > I just checked the Application logs in the Even Viewer on the
SQL
> > > > server
> > > > > > and
> > > > > > > found the following errors repeated every 30 minutes that
seems to
> > > > match
> > > > > > the
> > > > > > > problem symtom the customer is having. I've searched on
the
> > web
> > > > and
> > > > > > looks
> > > > > > > like the problem has something to do with group policy.
> > > > > > >
> > > > > > > Could these errors be the cause of the problem? Are they that
bad
> > > > that
> > > > > > can
> > > > > > > break connection between the client and the server?
> > > > > > >
> > > > > > > ==========> > > > > > > Type Date Time Source Category Event User
> > Computer
> > > > > > >
> > > > > > > Error 8/24/2004 3:54:12 PM Userenv None 1085 SYSTEM
pc100
> > > > > > > Error 8/24/2004 3:54:12 PM Userenv None 1091 SYSTEM
pc100
> > > > > > > ==========> > > > > > >
> > > > > > > Would anybody give any insight on this? Thanks much in
advance.
> > > > > > >
> > > > > > > Bing
> > > > > > >
> > > > > > > "Steve Thompson" wrote:
> > > > > > >
> > > > > > > > "bing" <bing@.discussions.microsoft.com> wrote in message
> > > > > > > > news:6C9ADFB9-51B5-451C-A921-540624570C1F@.microsoft.com...
> > > > > > > > > One customer reported they were having problem with their
> > Access
> > > > > > database
> > > > > > > > > that is
> > > > > > > > > linked to our SQL Server. They had to relink the tables
every
> > 30
> > > > > > minutes
> > > > > > > > > when working on the db. Where should I look on the SQL
server
> > to
> > > > > > > > determine
> > > > > > > > > if this is SQL server related or network related?
> > > > > > > >
> > > > > > > > What problem were they having? And, what versions of
products
> > are
> > > > being
> > > > > > > > used? More information is better in this case ;)
> > > > > > > >
> > > > > > > > Steve
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >