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...
> determine
> 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...uct=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[vbcol=seagreen]
> 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:
database[vbcol=seagreen]
minutes[vbcol=seagreen]
|||Thanks for the pointer, Steve. Now I'm having trouble getting MS online
support. In their product list on the Product ID (PID) Locator page, I was
not able to find SQL server. How can I find the product ID?
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...uct=winsvr2003
> Steve
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> and
> the
> looks
> can
> database
> minutes
>
>
|||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...uct=winsvr2003
> Steve
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:F749D976-A9F3-4E64-913C-92F38E020F5C@.microsoft.com...
> and
> the
> looks
> can
> database
> minutes
>
>
|||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[vbcol=seagreen]
> 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:
enforcing[vbcol=seagreen]
to[vbcol=seagreen]
http://support.microsoft.com/default...uct=winsvr2003[vbcol=seagreen]
server[vbcol=seagreen]
match[vbcol=seagreen]
and[vbcol=seagreen]
that[vbcol=seagreen]
being[vbcol=seagreen]
|||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...
> some
> enforcing
> to
> http://support.microsoft.com/default...uct=winsvr2003
> server
> match
> and
> that
> being
>
>
|||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'[vbcol=seagreen]
> 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:
figure[vbcol=seagreen]
get[vbcol=seagreen]
related[vbcol=seagreen]
http://support.microsoft.com/default...uct=winsvr2003[vbcol=seagreen]
web[vbcol=seagreen]
Computer[vbcol=seagreen]
Access[vbcol=seagreen]
30[vbcol=seagreen]
to[vbcol=seagreen]
are[vbcol=seagreen]
|||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
[vbcol=seagreen]
> Bing
> "Steve Thompson" wrote:
figure[vbcol=seagreen]
get[vbcol=seagreen]
related[vbcol=seagreen]
http://support.microsoft.com/default...uct=winsvr2003[vbcol=seagreen]
web[vbcol=seagreen]
Computer[vbcol=seagreen]
Access[vbcol=seagreen]
30[vbcol=seagreen]
to[vbcol=seagreen]
are[vbcol=seagreen]