error 18452 after installaling sp4 e slammer patch on win2000 pro

previous win 2000 sp1
what can I do? thanks in advance
http://www.visual-basic-data-mining...spx?PostID=251
provide the solution !
"roberto" <anonymous@.discussions.microsoft.com>
?:b09301c43738$5f1626c0$a401280a@.phx.gbl...
> previous win 2000 sp1
> what can I do? thanks in advance
sql

error 18452 after installaling sp4 e slammer patch on win2000 pro

previous win 2000 sp1
what can I do? thanks in advancehttp://www.visual-basic-data-mining...aspx?PostID=251
provide the solution !
"roberto" <anonymous@.discussions.microsoft.com>
':b09301c43738$5f1626c0$a401280a@.phx.gbl...
> previous win 2000 sp1
> what can I do? thanks in advance

Error 17883 in SQL error log

Hello,
We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
the following error recently:
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 12 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
Scheduler 0.
We also get error like below daily:
SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [E:\Microsoft SQL
Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
handle is 0x0000053C. The offset of the latest long IO is: 0x00000000010000
The SQL server is used as data warhouse server, so there are a lots of IO.
I appreciate any suggestions or comments.
Thanks!
Sugarhigh,
For 17883 here is a whitepaper
http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx#ELDAC
For your IO issues:
http://support.microsoft.com/kb/897284
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx
Basically, you need to investigate your hardware utilization, particularly
(as you might expect) measuring your IO subsystem which sounds like it is
strained. Most likely you will need to do some upgrades to your equipment.
RLF
"Sugarhigh" <sugarhigh@.community.nospam> wrote in message
news:EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com...
> Hello,
> We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
> the following error recently:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 12 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
> Scheduler 0.
> We also get error like below daily:
> SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [E:\Microsoft SQL
> Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
> handle is 0x0000053C. The offset of the latest long IO is:
> 0x00000000010000
> The SQL server is used as data warhouse server, so there are a lots of IO.
> I appreciate any suggestions or comments.
> Thanks!
|||Hello,
Thank you for posting here.
To better understand the error message, you must first understand how SQL
Server uses a User Mode Scheduling (UMS) Ums.dll helper file.
Microsoft SQL Server 2000 use logical schedulers. These schedulers help to
make sure that SQL Server maximizes operating system resource usage in
relation to key database action paths. The UMS layer makes sure that SQL
Server correctly uses Win32 events to strictly control thread and fiber (or
both) scheduling visibility to the operating system. By strictly
controlling the threads or fibers that can run, SQL Server can maximize CPU
usage as it relates to database primitives such as locking.
For example, logical scheduling permits lock waiters to sleep
(WaitForSingleObject on a Win32 event) until the lock owner releases the
lock and signals (SetEvent) them to wake up.
For more information, please refer to the following article:
New concurrency and scheduling diagnostics added to SQL Server (319892)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;319892
Note: The format of the 17833 message is different for separate versions of
the SQL Server product; however, the meaning is the same.
However, to find out the root cause of this issue we may need to analyze
memory dumps, this work has to be done by contacting Microsoft Product
Support Services. Therefore, we probably will not be able to resolve the
issue through the newsgroups. If the issue is urgent, I recommend that you
open a Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
At the same time, please also ensure that latest update for SQL Server 2000
Service Pack 4 has been installed. We can download it from the following
website:
Cumulative Hotfix for SQL Server 2000 Service Pack 4 - Build 2187 for x86
and x64 Based Systems
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=9c9a
b140-bdee-44df-b7a3-e6849297754a
More related information:
=======================
892840FIX: 17883 errors may be written to the SQL Server error log when
you run a query that generates many floating point exception errors in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;892840
810885High-end disk subsystems may experience error 17883
http://support.microsoft.com/default.aspx?scid=kb;EN-US;810885
888666You may receive a 17883 error message when you run full-text queries
in SQL Server 7.0 or SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;888666
890730FIX: You receive a 17883 error message when you perform large
in-memory sort operations in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;890730
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Error 17883 in SQL error log
| thread-index: AcfVM7K5Tj5qumliSs2GiuzWV3+hMQ==
| X-WBNR-Posting-Host: 207.46.19.168
| From: =?Utf-8?B?U3VnYXJoaWdo?= <sugarhigh@.community.nospam>
| Subject: Error 17883 in SQL error log
| Date: Thu, 2 Aug 2007 11:34:02 -0700
| Lines: 23
| Message-ID: <EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:21828
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hello,
|
| We have a SQL server 2000 enterprise edition on SP4 on windows NT, and
got
| the following error recently:
|
| Sleeping until external dump process completes.
| Resuming after waiting on external debug process for 12 seconds.
| Stack Signature for the dump is 0x00000000
| Error: 17883, Severity: 1, State: 0
| Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
| Scheduler 0.
|
| We also get error like below daily:
| SQL Server has encountered 5359 occurrence(s) of IO requests taking
longer
| than 15 seconds to complete on file [E:\Microsoft SQL
| Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
| handle is 0x0000053C. The offset of the latest long IO is:
0x00000000010000
|
| The SQL server is used as data warhouse server, so there are a lots of
IO.
|
| I appreciate any suggestions or comments.
|
| Thanks!
|

Error 17883 in SQL error log

Hello,
We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
the following error recently:
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 12 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
Scheduler 0.
We also get error like below daily:
SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [E:\Microsoft SQL
Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
handle is 0x0000053C. The offset of the latest long IO is: 0x00000000010000
The SQL server is used as data warhouse server, so there are a lots of IO.
I appreciate any suggestions or comments.
Thanks!Sugarhigh,
For 17883 here is a whitepaper
http://www.microsoft.com/technet/prodtechnol/sql/2005/diagandcorrecterrs.mspx#ELDAC
For your IO issues:
http://support.microsoft.com/kb/897284
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx
Basically, you need to investigate your hardware utilization, particularly
(as you might expect) measuring your IO subsystem which sounds like it is
strained. Most likely you will need to do some upgrades to your equipment.
RLF
"Sugarhigh" <sugarhigh@.community.nospam> wrote in message
news:EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com...
> Hello,
> We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
> the following error recently:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 12 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
> Scheduler 0.
> We also get error like below daily:
> SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [E:\Microsoft SQL
> Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
> handle is 0x0000053C. The offset of the latest long IO is:
> 0x00000000010000
> The SQL server is used as data warhouse server, so there are a lots of IO.
> I appreciate any suggestions or comments.
> Thanks!|||Hello,
Thank you for posting here.
To better understand the error message, you must first understand how SQL
Server uses a User Mode Scheduling (UMS) Ums.dll helper file.
Microsoft SQL Server 2000 use logical schedulers. These schedulers help to
make sure that SQL Server maximizes operating system resource usage in
relation to key database action paths. The UMS layer makes sure that SQL
Server correctly uses Win32 events to strictly control thread and fiber (or
both) scheduling visibility to the operating system. By strictly
controlling the threads or fibers that can run, SQL Server can maximize CPU
usage as it relates to database primitives such as locking.
For example, logical scheduling permits lock waiters to sleep
(WaitForSingleObject on a Win32 event) until the lock owner releases the
lock and signals (SetEvent) them to wake up.
For more information, please refer to the following article:
New concurrency and scheduling diagnostics added to SQL Server (319892)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;319892
Note: The format of the 17833 message is different for separate versions of
the SQL Server product; however, the meaning is the same.
However, to find out the root cause of this issue we may need to analyze
memory dumps, this work has to be done by contacting Microsoft Product
Support Services. Therefore, we probably will not be able to resolve the
issue through the newsgroups. If the issue is urgent, I recommend that you
open a Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
At the same time, please also ensure that latest update for SQL Server 2000
Service Pack 4 has been installed. We can download it from the following
website:
Cumulative Hotfix for SQL Server 2000 Service Pack 4 - Build 2187 for x86
and x64 Based Systems
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=9c9a
b140-bdee-44df-b7a3-e6849297754a
More related information:
=======================892840 FIX: 17883 errors may be written to the SQL Server error log when
you run a query that generates many floating point exception errors in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;892840
810885 High-end disk subsystems may experience error 17883
http://support.microsoft.com/default.aspx?scid=kb;EN-US;810885
888666 You may receive a 17883 error message when you run full-text queries
in SQL Server 7.0 or SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;888666
890730 FIX: You receive a 17883 error message when you perform large
in-memory sort operations in SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;EN-US;890730
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: Error 17883 in SQL error log
| thread-index: AcfVM7K5Tj5qumliSs2GiuzWV3+hMQ==| X-WBNR-Posting-Host: 207.46.19.168
| From: =?Utf-8?B?U3VnYXJoaWdo?= <sugarhigh@.community.nospam>
| Subject: Error 17883 in SQL error log
| Date: Thu, 2 Aug 2007 11:34:02 -0700
| Lines: 23
| Message-ID: <EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:21828
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hello,
|
| We have a SQL server 2000 enterprise edition on SP4 on windows NT, and
got
| the following error recently:
|
| Sleeping until external dump process completes.
| Resuming after waiting on external debug process for 12 seconds.
| Stack Signature for the dump is 0x00000000
| Error: 17883, Severity: 1, State: 0
| Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
| Scheduler 0.
|
| We also get error like below daily:
| SQL Server has encountered 5359 occurrence(s) of IO requests taking
longer
| than 15 seconds to complete on file [E:\Microsoft SQL
| Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
| handle is 0x0000053C. The offset of the latest long IO is:
0x00000000010000
|
| The SQL server is used as data warhouse server, so there are a lots of
IO.
|
| I appreciate any suggestions or comments.
|
| Thanks!
|

Error 17883 in SQL error log

Hello,
We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
the following error recently:
Sleeping until external dump process completes.
Resuming after waiting on external debug process for 12 seconds.
Stack Signature for the dump is 0x00000000
Error: 17883, Severity: 1, State: 0
Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
Scheduler 0.
We also get error like below daily:
SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
than 15 seconds to complete on file [E:\Microsoft SQL
Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS file
handle is 0x0000053C. The offset of the latest long IO is: 0x00000000010000
The SQL server is used as data warhouse server, so there are a lots of IO.
I appreciate any suggestions or comments.
Thanks!Sugarhigh,
For 17883 here is a whitepaper
C" target="_blank">http://www.microsoft.com/technet/pr...x#ELDA
C
For your IO issues:
http://support.microsoft.com/kb/897284
http://blogs.msdn.com/sqlserverstor.../21/642314.aspx
Basically, you need to investigate your hardware utilization, particularly
(as you might expect) measuring your IO subsystem which sounds like it is
strained. Most likely you will need to do some upgrades to your equipment.
RLF
"Sugarhigh" <sugarhigh@.community.nospam> wrote in message
news:EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com...
> Hello,
> We have a SQL server 2000 enterprise edition on SP4 on windows NT, and got
> the following error recently:
> Sleeping until external dump process completes.
> Resuming after waiting on external debug process for 12 seconds.
> Stack Signature for the dump is 0x00000000
> Error: 17883, Severity: 1, State: 0
> Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
> Scheduler 0.
> We also get error like below daily:
> SQL Server has encountered 5359 occurrence(s) of IO requests taking longer
> than 15 seconds to complete on file [E:\Microsoft SQL
> Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS fil
e
> handle is 0x0000053C. The offset of the latest long IO is:
> 0x00000000010000
> The SQL server is used as data warhouse server, so there are a lots of IO.
> I appreciate any suggestions or comments.
> Thanks!|||Hello,
Thank you for posting here.
To better understand the error message, you must first understand how SQL
Server uses a User Mode Scheduling (UMS) Ums.dll helper file.
Microsoft SQL Server 2000 use logical schedulers. These schedulers help to
make sure that SQL Server maximizes operating system resource usage in
relation to key database action paths. The UMS layer makes sure that SQL
Server correctly uses Win32 events to strictly control thread and fiber (or
both) scheduling visibility to the operating system. By strictly
controlling the threads or fibers that can run, SQL Server can maximize CPU
usage as it relates to database primitives such as locking.
For example, logical scheduling permits lock waiters to sleep
(WaitForSingleObject on a Win32 event) until the lock owner releases the
lock and signals (SetEvent) them to wake up.
For more information, please refer to the following article:
New concurrency and scheduling diagnostics added to SQL Server (319892)
http://support.microsoft.com/defaul...KB;EN-US;319892
Note: The format of the 17833 message is different for separate versions of
the SQL Server product; however, the meaning is the same.
However, to find out the root cause of this issue we may need to analyze
memory dumps, this work has to be done by contacting Microsoft Product
Support Services. Therefore, we probably will not be able to resolve the
issue through the newsgroups. If the issue is urgent, I recommend that you
open a Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
At the same time, please also ensure that latest update for SQL Server 2000
Service Pack 4 has been installed. We can download it from the following
website:
Cumulative Hotfix for SQL Server 2000 Service Pack 4 - Build 2187 for x86
and x64 Based Systems
http://www.microsoft.com/downloads/...n&FamilyID=9c9a
b140-bdee-44df-b7a3-e6849297754a
More related information:
=======================
892840 FIX: 17883 errors may be written to the SQL Server error log when
you run a query that generates many floating point exception errors in SQL
Server 2000
http://support.microsoft.com/defaul...kb;EN-US;892840
810885 High-end disk subsystems may experience error 17883
http://support.microsoft.com/defaul...kb;EN-US;810885
888666 You may receive a 17883 error message when you run full-text queries
in SQL Server 7.0 or SQL Server 2000
http://support.microsoft.com/defaul...kb;EN-US;888666
890730 FIX: You receive a 17883 error message when you perform large
in-memory sort operations in SQL Server 2000
http://support.microsoft.com/defaul...kb;EN-US;890730
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: Error 17883 in SQL error log
| thread-index: AcfVM7K5Tj5qumliSs2GiuzWV3+hMQ==
| X-WBNR-Posting-Host: 207.46.19.168
| From: examnotes <sugarhigh@.community.nospam>
| Subject: Error 17883 in SQL error log
| Date: Thu, 2 Aug 2007 11:34:02 -0700
| Lines: 23
| Message-ID: <EBD8AFCC-B391-4E6C-A341-0BD5A4D62903@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:21828
| NNTP-Posting-Host: tk2msftsbfm01.phx.gbl 10.40.244.148
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hello,
|
| We have a SQL server 2000 enterprise edition on SP4 on windows NT, and
got
| the following error recently:
|
| Sleeping until external dump process completes.
| Resuming after waiting on external debug process for 12 seconds.
| Stack Signature for the dump is 0x00000000
| Error: 17883, Severity: 1, State: 0
| Process 1:0 (9d4) UMS Context 0x002977F8 appears to be non-yielding on
| Scheduler 0.
|
| We also get error like below daily:
| SQL Server has encountered 5359 occurrence(s) of IO requests taking
longer
| than 15 seconds to complete on file [E:\Microsoft SQL
| Server\Data\DBAUtility.mdf] in database [DBAUtility] (14). The OS fil
e
| handle is 0x0000053C. The offset of the latest long IO is:
0x00000000010000
|
| The SQL server is used as data warhouse server, so there are a lots of
IO.
|
| I appreciate any suggestions or comments.
|
| Thanks!
|sql

Error 17883

I have read the other threads that discuss error 17883. I have a SQL 2000 server with SP 3a on a Windows 2000 server SP4. I get the following error in my SQL log...

Process 429:0 (ad4) UMS Context 0x06BA8D30 appears to be non-yielding on Scheduler 0.

Then ...

Error: 17883, Severity: 1, State: 0

When this error occurs my users are forced to close and reopen the application. Once the users log back in they are good to go.

I just started getting this error 2 weeks ago about 1 error a week. Now I am getting them everyday...At first I thought it was due to a database Log file autogrow, but my log files haven't gotten autogrown in the last week.

Has anyone else seen this specific version of Error 17883?Did you see this article (http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885)?

I have never encountered encountered the error myself. I ran on SP3a for quite some time before upgrading to SP4.

Regards,

hmscott

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupoPupo
take a look at following article:
http://support.microsoft.com/defaul...kb;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupoPupo
take a look at following article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>
sql

Error 14294 in replication

Hi
I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
This server has several published databases that they replicate data to
another server.
All the replications is of transactional type.
When creating to publish another database it leaves me the following error:
Error 14294
Supply either @.job_id or @.job_name to indentify the job.
That I can make to correct the problem?
Thank you
are you or have you deployed the other publications using a script?
If you, you must use unique publication names and ensure that you don't
specify a snapshot agent name, log reader agent name, or distribution agent
name.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you
|||Hi Hilary
I don′t use a script, my publications was created by wizard.
"Hilary Cotter" wrote:

> are you or have you deployed the other publications using a script?
> If you, you must use unique publication names and ensure that you don't
> specify a snapshot agent name, log reader agent name, or distribution agent
> name.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Mario" <Mario@.discussions.microsoft.com> wrote in message
> news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> error:
>
>
|||Can you do a Select @.@.SERVERNAME on your publisher and see what server name
it returns? Did you rename this server recently.
There are some reports that this error can be cleared by disabling
replication on your publisher and then recreating it.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Mario" <Mario@.discussions.microsoft.com> wrote in message
news:C083E5F7-8740-4ACC-B73E-51B6B35FCE62@.microsoft.com...
> Hi
> I have a server with Windows 2000 Server SP4 and SQL 2000 with SP3.
> This server has several published databases that they replicate data to
> another server.
> All the replications is of transactional type.
> When creating to publish another database it leaves me the following
error:
> Error 14294
> Supply either @.job_id or @.job_name to indentify the job.
> That I can make to correct the problem?
> Thank you

Error 14258 while creating a publication

Hi all,
I am trying to create a merge-publication (SQL 2000 SP4).
Unfortunately, it is not working because the wizard pops up with error
14258: Cannot perform this operation while SQL Server Agent is
starting. Try again later.
Checked both services, they seem correct. Both are using (the same)
domain-user with sufficient privs to access the SQLServer box. They
both run fine (all in the green) and there are no errors in the logs.
SQL itself runs fine and I can access all data from any computer in the
network.
Just to be sure, I've stopped and restarted both services but the same
error comes back again. I've checked all settings but as far as I can
see, the box is configured properly.
Any ideas?
Thx,
FS
Check out this MS article:
http://support.microsoft.com/?id=303287
John Steen
"Ferry" wrote:

> Hi all,
> I am trying to create a merge-publication (SQL 2000 SP4).
> Unfortunately, it is not working because the wizard pops up with error
> 14258: Cannot perform this operation while SQL Server Agent is
> starting. Try again later.
> Checked both services, they seem correct. Both are using (the same)
> domain-user with sufficient privs to access the SQLServer box. They
> both run fine (all in the green) and there are no errors in the logs.
> SQL itself runs fine and I can access all data from any computer in the
> network.
> Just to be sure, I've stopped and restarted both services but the same
> error comes back again. I've checked all settings but as far as I can
> see, the box is configured properly.
> Any ideas?
> Thx,
> FS
>
>
|||Hmm, I guess I was too fast... Solved the problem already by googling a
bit further. As a thank you for reading I will share the solution :-)
When having MSDTC switched on _and_ using NT-fibres in the SQL
configuration, you can encounter this error. Switching the NT-fibres
off (and stopping and starting the services again) resolved the
problem. MSKB article, aaaaargh, how could I missed it in the first
place...
From Ferry :
> Hi all,
> I am trying to create a merge-publication (SQL 2000 SP4). Unfortunately, it
> is not working because the wizard pops up with error 14258: Cannot perform
> this operation while SQL Server Agent is starting. Try again later.
>

Error -133 on installing Service Pack 4 for SQL7

Hallo, my problem is to upgrade instance of SQL7 to SQL7 SP4.

Server is WIN2K SP4 + MDAC 2.8 SP1

Installing the SQL7 Server from CD is OK.

When i try to apply the SQL7 SP4 the first fase, when SP4 checks all conditions to start is OK, when start to copy file i receive an error -113 like this

--

Error occurred during the move data process: -113

Component Server: base server \ base server files

File Group: Base Server Files

File: C:\70SP4\X86\Setup.....\SQLIMAGE.DLL

--

On server is installed the library SQLDMO.DLL for SQL2000 but only the library used by an application VB6.

In need to install SQL7 and i can't install SQL2000 or SQL2005 because we work with an application written for SQL7. I've tried to migrate application SQL2000 but not work properly.

Somebody can help me ?

Thanks in advance.

Aragorn

Have you got or already installed SQL 7 on this machine?

If there are instances running for SQL 2000 and 2005 then you may not be able to install previous version of SQL until unless these are uninstalled.

It might be a problem with SP4 files, try to download again and apply.

Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
Chuck
Check this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:

> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than normal.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
ChuckCheck this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
--
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:
> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than normal.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
ChuckCheck this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:

> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, i
t
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than norma
l.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error =x8004D00A after SP4 on SQL 2000 on W2003

Hi:
Some clients (Windows XP all of then ) on my aplication (components and VB
6 ) have this error message
I did the follow KB but no help me
KB 839279
KB 922430
System.Runtime.InteropServices.COMException (0x8004D00A): No se puede dar de
alta la nueva transaccin en el coordinador de transacciones especificado.
en InterfazReglas._IEntidad.GetOne(String DataServer, String
ConnectionName, String Entidad, Object Clave)
en Utilidades.Herramientas.MostrarMensaje(String Fuente, Int32 NroErr,
String TipoErr, String Msg)
en SueldosFormsNet.FPer.OkEdicion()
en SueldosFormsNet.FPer.BarEdicion1_btnOkEditClick(Ob ject sender,
EventArgs e)
en Condor.Controles.barEdicion.btnOkEdit_Click(Object sender, EventArgs
e)
en System.Windows.Forms.Control.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ButtonBase.WndProc(Message& m)
en System.Windows.Forms.Button.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
Plese Helppp Meee !!!!
thanks
Have you checked if DTC Service (Distributed Transaction Coordinator) is
initiated?
Please, rate this post. Thanks!
May the bytes be with you!!!
Pedro López-Belmonte Eraso
MCAD, MCT
"Manuel Palacio (Argentina)" wrote:

> Hi:
> Some clients (Windows XP all of then ) on my aplication (components and VB
> 6 ) have this error message
> I did the follow KB but no help me
> KB 839279
> KB 922430
> System.Runtime.InteropServices.COMException (0x8004D00A): No se puede dar de
> alta la nueva transacción en el coordinador de transacciones especificado.
> en InterfazReglas._IEntidad.GetOne(String DataServer, String
> ConnectionName, String Entidad, Object Clave)
> en Utilidades.Herramientas.MostrarMensaje(String Fuente, Int32 NroErr,
> String TipoErr, String Msg)
> en SueldosFormsNet.FPer.OkEdicion()
> en SueldosFormsNet.FPer.BarEdicion1_btnOkEditClick(Ob ject sender,
> EventArgs e)
> en Condor.Controles.barEdicion.btnOkEdit_Click(Object sender, EventArgs
> e)
> en System.Windows.Forms.Control.OnClick(EventArgs e)
> en System.Windows.Forms.Button.OnClick(EventArgs e)
> en System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
> en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
> button, Int32 clicks)
> en System.Windows.Forms.Control.WndProc(Message& m)
> en System.Windows.Forms.ButtonBase.WndProc(Message& m)
> en System.Windows.Forms.Button.WndProc(Message& m)
> en System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
> en System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
> en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> Plese Helppp Meee !!!!
> thanks
>
>
|||Pedro.
Yes I do
tengo algunos equipos que andan y la ocnfiguracion del DTC la revise
hice todo lo que dice Microsoft
y nada
"Pedro Lpez-Belmonte" <plberaso@.mizarsoluciones.com.quitaestoparaenviar>
wrote in message news:0652BCD2-81B7-41E5-B11D-0902531AF57D@.microsoft.com...[vbcol=seagreen]
> Have you checked if DTC Service (Distributed Transaction Coordinator) is
> initiated?
> --
> Please, rate this post. Thanks!
> --
> May the bytes be with you!!!
> Pedro Lpez-Belmonte Eraso
> MCAD, MCT
>
> "Manuel Palacio (Argentina)" wrote:

Error =x8004D00A after SP4 on SQL 2000 on W2003

Hi:
Some clients (Windows XP all of then ) on my aplication (components and VB
6 ) have this error message
I did the follow KB but no help me
KB 839279
KB 922430
System.Runtime.InteropServices.COMException (0x8004D00A): No se puede dar de
alta la nueva transacción en el coordinador de transacciones especificado.
en InterfazReglas._IEntidad.GetOne(String DataServer, String
ConnectionName, String Entidad, Object Clave)
en Utilidades.Herramientas.MostrarMensaje(String Fuente, Int32 NroErr,
String TipoErr, String Msg)
en SueldosFormsNet.FPer.OkEdicion()
en SueldosFormsNet.FPer.BarEdicion1_btnOkEditClick(Object sender,
EventArgs e)
en Condor.Controles.barEdicion.btnOkEdit_Click(Object sender, EventArgs
e)
en System.Windows.Forms.Control.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnClick(EventArgs e)
en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ButtonBase.WndProc(Message& m)
en System.Windows.Forms.Button.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
Plese Helppp Meee !!!!
thanksHave you checked if DTC Service (Distributed Transaction Coordinator) is
initiated?
--
Please, rate this post. Thanks!
--
May the bytes be with you!!!
Pedro López-Belmonte Eraso
MCAD, MCT
"Manuel Palacio (Argentina)" wrote:
> Hi:
> Some clients (Windows XP all of then ) on my aplication (components and VB
> 6 ) have this error message
> I did the follow KB but no help me
> KB 839279
> KB 922430
> System.Runtime.InteropServices.COMException (0x8004D00A): No se puede dar de
> alta la nueva transacción en el coordinador de transacciones especificado.
> en InterfazReglas._IEntidad.GetOne(String DataServer, String
> ConnectionName, String Entidad, Object Clave)
> en Utilidades.Herramientas.MostrarMensaje(String Fuente, Int32 NroErr,
> String TipoErr, String Msg)
> en SueldosFormsNet.FPer.OkEdicion()
> en SueldosFormsNet.FPer.BarEdicion1_btnOkEditClick(Object sender,
> EventArgs e)
> en Condor.Controles.barEdicion.btnOkEdit_Click(Object sender, EventArgs
> e)
> en System.Windows.Forms.Control.OnClick(EventArgs e)
> en System.Windows.Forms.Button.OnClick(EventArgs e)
> en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
> en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
> button, Int32 clicks)
> en System.Windows.Forms.Control.WndProc(Message& m)
> en System.Windows.Forms.ButtonBase.WndProc(Message& m)
> en System.Windows.Forms.Button.WndProc(Message& m)
> en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> Plese Helppp Meee !!!!
> thanks
>
>|||Pedro.
Yes I do
tengo algunos equipos que andan y la ocnfiguracion del DTC la revise
hice todo lo que dice Microsoft
y nada
"Pedro López-Belmonte" <plberaso@.mizarsoluciones.com.quitaestoparaenviar>
wrote in message news:0652BCD2-81B7-41E5-B11D-0902531AF57D@.microsoft.com...
> Have you checked if DTC Service (Distributed Transaction Coordinator) is
> initiated?
> --
> Please, rate this post. Thanks!
> --
> May the bytes be with you!!!
> Pedro López-Belmonte Eraso
> MCAD, MCT
>
> "Manuel Palacio (Argentina)" wrote:
>> Hi:
>> Some clients (Windows XP all of then ) on my aplication (components and
>> VB
>> 6 ) have this error message
>> I did the follow KB but no help me
>> KB 839279
>> KB 922430
>> System.Runtime.InteropServices.COMException (0x8004D00A): No se puede dar
>> de
>> alta la nueva transacción en el coordinador de transacciones
>> especificado.
>> en InterfazReglas._IEntidad.GetOne(String DataServer, String
>> ConnectionName, String Entidad, Object Clave)
>> en Utilidades.Herramientas.MostrarMensaje(String Fuente, Int32 NroErr,
>> String TipoErr, String Msg)
>> en SueldosFormsNet.FPer.OkEdicion()
>> en SueldosFormsNet.FPer.BarEdicion1_btnOkEditClick(Object sender,
>> EventArgs e)
>> en Condor.Controles.barEdicion.btnOkEdit_Click(Object sender,
>> EventArgs
>> e)
>> en System.Windows.Forms.Control.OnClick(EventArgs e)
>> en System.Windows.Forms.Button.OnClick(EventArgs e)
>> en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
>> en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
>> button, Int32 clicks)
>> en System.Windows.Forms.Control.WndProc(Message& m)
>> en System.Windows.Forms.ButtonBase.WndProc(Message& m)
>> en System.Windows.Forms.Button.WndProc(Message& m)
>> en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
>> m)
>> en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
>> m)
>> en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> Plese Helppp Meee !!!!
>> thanks
>>
>>

Erroneous error in Reporting Services Configuration Manager (2005)

I'm attempting to setup reporting services 2005 on a system that has never
had reporting services installed and has a previous SQL 2000 (sp4) instance.
This server is running Windows 2000 SP4.
In the Reporting Services Configuration Manager I have successfully have
completed (check marks) the following steps "Server Status, Report Server
Virtual Directory, Report Manager Virtual Directory, Windows Service
Identity, Email Settings".
My problem is when I attempt to perform the database connection step. I
click connect and type in my computer name and leave in windows
authenticaiton. I am then able to browse the drop down list of my SQL 2000
databases. I then click new, leave the defaults and say OK. It successfully
creates a ReportServer and ReportServerTempDB. I click Apply, however, and
get the following error:
There was a failure applying your change. A virtual directory must first be
created before performing this operation.
I already created both of the virtual directory steps with no issue. I even
went into IIS and see the directories have been created by the Configuration
Manager. Any suggestions?
--
-DanielMaybe its a clue... But it appears on this server that the application log
is being filled up with .NET Runtime Optimization Service entries. I even
cleared the log yesterday and its full again. Here is what an entry looks
like:
Event Type: Information
Event Source: .NET Runtime Optimization Service
Event Category: None
Event ID: 1100
Date: 11/15/2005
Time: 7:12:20 PM
User: N/A
Computer: PUMBAA
Description:
.NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Began
compiling: Microsoft.ReportingServices.Interfaces, Version=9.0.242.0,
Culture=neutral, PublicKeyToken=89845dcd8080cc91
--
-Daniel