We have a SQL 2000 server on a 8 processor Dell server
that uses tables from another server (Linked Server).
Periodically it hangs up locking out out our.NET users. It
fails to display the linked server tables on EM.
The SQL logs show thes two lines:
The Scheduler 7 appears to be hung. SPID 0, ECID 0, UMS
Context 0x03EFC168.
Error: 17883, Severity: 1, State: 0
The server also shows a bunch of Application Pop-ups that
say:
"Application Popup error: SQL Server OLEDB provider
support error. Unable to load SQL Server OLEDB provider
resource dll."
Can someone help with a fix? Its a little tiresome to have
to shutdown and restart the server (which takes about 10
minutes).
Thanks very much.
Sam AbrahamCheck if this article is helpful:
http://support.microsoft.com/defaul...b;EN-US;810885.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Sam Abraham" <sabraham@.state.pa.us> wrote in message
news:1cb101c3e02d$4428f1b0$a601280a@.phx.gbl...
quote:|||Thanks for trying Dejan but the knowledge Base Article is
> Hi,
> We have a SQL 2000 server on a 8 processor Dell server
> that uses tables from another server (Linked Server).
> Periodically it hangs up locking out out our.NET users. It
> fails to display the linked server tables on EM.
> The SQL logs show thes two lines:
> The Scheduler 7 appears to be hung. SPID 0, ECID 0, UMS
> Context 0x03EFC168.
> Error: 17883, Severity: 1, State: 0
> The server also shows a bunch of Application Pop-ups that
> say:
> "Application Popup error: SQL Server OLEDB provider
> support error. Unable to load SQL Server OLEDB provider
> resource dll."
>
> Can someone help with a fix? Its a little tiresome to have
> to shutdown and restart the server (which takes about 10
> minutes).
>
> Thanks very much.
> Sam Abraham
no longer available.
Sam
quote:
>--Original Message--
>Check if this article is helpful:
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;810885.
quote:|||Hello Sam,
>--
>Dejan Sarka, SQL Server MVP
>Associate Mentor
>Solid Quality Learning
>More than just Training
>www.SolidQualityLearning.com
>"Sam Abraham" <sabraham@.state.pa.us> wrote in message
>news:1cb101c3e02d$4428f1b0$a601280a@.phx.gbl...
It[QUOTE]
that[QUOTE]
have[QUOTE]
>
>.
>
Error 17883 is not correctly displayed in earlier build of SQL 2K SP3. You
might need the Hotfix mentioed in
FIX: Error 17883 May Display Message Text That Is Not Correct
http://support.microsoft.com/defaul...kb;en-us;816840
However, that would just allow SQL Server to display the correct error
message.. They are several causes of this kind of error and
its required to analyse the errorlogs,event logs and mini dumps to narrow
down the actual cause of this problem you are having.
Looking at the nature of this issue, it would require intensive
troubleshooting which would be done quickly and effectively with direct
assistance from a Microsoft Support Professional through Microsoft Product
Support Services. You can contact Microsoft Product Support directly to
discuss additional support options you may have available, by contacting us
at 1-(800)936-5800 or by choosing one of the options listed at
http://support.microsoft.com/defaul...d=sz;en-us;top. If this is not
an urgent issue and your would like us to create an incident for you and
have Microsoft Customer Service Representative contact you directly,
please send email to (remove "online." from this no Spam email address):
mailto:dscommhf@.online.microsoft.com with the following information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*Subject Line
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
| Content-Class: urn:content-classes:message
| From: "Sam Abraham" <sabraham@.state.pa.us>
| Sender: "Sam Abraham" <sabraham@.state.pa.us>
| Subject: Error 17883 forcing shutdown and hard boot
| Date: Wed, 21 Jan 2004 06:45:51 -0800
| Lines: 29
| Message-ID: <1cb101c3e02d$4428f1b0$a601280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPgLUQog4wHY5XDQDqvTUZLq4jvlA==
| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:325329
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
|
| We have a SQL 2000 server on a 8 processor Dell server
| that uses tables from another server (Linked Server).
| Periodically it hangs up locking out out our.NET users. It
| fails to display the linked server tables on EM.
| The SQL logs show thes two lines:
|
| The Scheduler 7 appears to be hung. SPID 0, ECID 0, UMS
| Context 0x03EFC168.
|
| Error: 17883, Severity: 1, State: 0
|
| The server also shows a bunch of Application Pop-ups that
| say:
|
| "Application Popup error: SQL Server OLEDB provider
| support error. Unable to load SQL Server OLEDB provider
| resource dll."
|
|
| Can someone help with a fix? Its a little tiresome to have
| to shutdown and restart the server (which takes about 10
| minutes).
|
|
| Thanks very much.
|
| Sam Abraham
||||The link works. Maybe you had some temporary connection problem?
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
<anonymous@.discussions.microsoft.com> wrote in message
news:1c2701c3e04a$a5766f70$a001280a@.phx.gbl...[QUOTE]
> Thanks for trying Dejan but the knowledge Base Article is
> no longer available.
> Sam
> US;810885.
> It
> that
> have
