error 18456 when running job

sql2k sp3
Ive got a job that creates a folder both on the local box
and on the remote box. This job has run every nite
successfully for a few weeks now. Last nite it failed with
message: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.
I havent changed anything security or services related.
The sql services for both boxes run in the same domain
admin account.
Any ideas?
Thanks, Chris.Try making the job owner sa. I've seen this and it ideespeared when I did that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"chris" <chrisr@.fingps.com> wrote in message news:034901c36693$a4ce8750$a501280a@.phx.gbl...
> sql2k sp3
> Ive got a job that creates a folder both on the local box
> and on the remote box. This job has run every nite
> successfully for a few weeks now. Last nite it failed with
> message: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.
> I havent changed anything security or services related.
> The sql services for both boxes run in the same domain
> admin account.
> Any ideas?
> Thanks, Chris.

error 1722 starting sqlserveragent

(this is a repost, the original post was mistakenly posted to the odbc
group)
Hello all,
I have a nightly job which runs under the SQLServerAgent service on my
SQLServer2000 database. Someone mentioned that the jobs did not run
last night, so I logged in to the server to see why, and I noticed that
the SQLServerAgent service was not running, which seemed like something
that would prevent jobs under it from being executed.
However, when I try to right-click/Start the SQL Server Agent i get the
following error:
An error 1722 - (The RPC server is unavailable) occurred while
performing this service operation on the SQLServerAgent service.
But that's all it says. I've looked in the SQL Server Agent logs, as
well as the Windows Event View application logs, and no further
information is provided in either location.
Can anyone tell me what kinds of things might cause this error? I'm not
even sure where to begin looking.
Thanks
JasonMy guess (only a guess, though) is that you aren't sitting on the SQL Server
machine doing this. So
you are using EM remotely to start the service and something goes bad in the
remote communications
to start the service. First step I'd try is to login locally on the machine
(possibly using Remote
Desktop) and start the service using the Services Applet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"jason" <iaesun@.yahoo.com> wrote in message
news:1132076344.251481.299800@.g14g2000cwa.googlegroups.com...
> (this is a repost, the original post was mistakenly posted to the odbc
> group)
> Hello all,
> I have a nightly job which runs under the SQLServerAgent service on my
> SQLServer2000 database. Someone mentioned that the jobs did not run
> last night, so I logged in to the server to see why, and I noticed that
> the SQLServerAgent service was not running, which seemed like something
> that would prevent jobs under it from being executed.
> However, when I try to right-click/Start the SQL Server Agent i get the
> following error:
> An error 1722 - (The RPC server is unavailable) occurred while
> performing this service operation on the SQLServerAgent service.
> But that's all it says. I've looked in the SQL Server Agent logs, as
> well as the Windows Event View application logs, and no further
> information is provided in either location.
> Can anyone tell me what kinds of things might cause this error? I'm not
> even sure where to begin looking.
> Thanks
> Jason
>|||that was indeed the problem. thanks a lot Tibor
jason

'Error 14274' - Cannot add, update, or delete a job (or its steps or schedules) that ori

http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
I followed the tip above but it didn't work. anyone know of other workaround
?
I restore a copy of my Production DB on a TestDB, the scheduled jobs get
copied over as well. Cannot removed these job frm the Test DB because of
error 14274.
I logon the Test DB on workgroup, rename to original server name (on
workgroup because the Production still exist on the network), tried to
delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
Agent Service to prevent the jobs frm running.
How to remove the jobs in the Test DB for good ?Don't bother with the rename stuff. Simply update the originating_server
column to reflect the new server name.
Have a look at http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:%23GEUVi%23bEHA.1764@.TK2MSFTNGP10.phx.gbl...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
>
> I followed the tip above but it didn't work. anyone know of other
workaround
> ?
> I restore a copy of my Production DB on a TestDB, the scheduled jobs get
> copied over as well. Cannot removed these job frm the Test DB because of
> error 14274.
> I logon the Test DB on workgroup, rename to original server name (on
> workgroup because the Production still exist on the network), tried to
> delete the jobs, SQL doesn't allow also. At the moment, I stopped the SQL
> Agent Service to prevent the jobs frm running.
> How to remove the jobs in the Test DB for good ?
>
>

Error 14274

I am trying to delete a job, but keep getting the error 14274. It says thta
I can not dlete the job because this job originated from an MSX Server.
I would appreciate any help on this subject.
ThanksHi
Have you checked out
http://support.microsoft.com/defaul...kb;en-us;281642
John
"Munch" wrote:

> I am trying to delete a job, but keep getting the error 14274. It says th
ta
> I can not dlete the job because this job originated from an MSX Server.
> I would appreciate any help on this subject.
> Thanks
>

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.
Hi!

> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/default...;en-us;281642.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>
> I guess this should help:
> http://support.microsoft.com/default...;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>
|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>
|||Check the following article:
http://www.karaszi.com/sqlserver/inf...erver_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:

>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.Hi!

> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/defaul...b;en-us;281642.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>
> I guess this should help:
> http://support.microsoft.com/defaul...b;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>|||Check the following article:
http://www.karaszi.com/sqlserver/in...server_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:

>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>sql

error 14274

After I change a job and want to save, it gives me error as following:
error 14274: Cannot add, update or delete a job (or its steps or schedules)
that originates from an MSX server. The job was not save.
Can anyone please tell me how to fix this error? Thanks.Hi!
> error 14274: Cannot add, update or delete a job (or its steps or
> schedules) that originates from an MSX server. The job was not save.
I guess this should help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Actually, I read this article. But I cannot down the SQL service and rename
the DB instance name as it said. What is other solution? Thanks.
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
> I guess this should help:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||Can anyone please help? This is urgent. Thanks.
"00KobeBrian" <a@.b.com> wrote in message
news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
> Actually, I read this article. But I cannot down the SQL service and
> rename the DB instance name as it said. What is other solution? Thanks.
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
>> I guess this should help:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor, www.SolidQualityLearning.com
>> Anything written in this message represents solely the point of view of
>> the sender.
>> This message does not imply endorsement from Solid Quality Learning, and
>> it does not represent the point of view of Solid Quality Learning or any
>> other person, company or institution mentioned in this message
>>
>|||Check the following article:
http://www.karaszi.com/sqlserver/info_change_server_name.asp
-Sue
On Tue, 7 Mar 2006 08:04:50 +0800, "00KobeBrian" <a@.b.com>
wrote:
>Can anyone please help? This is urgent. Thanks.
>"00KobeBrian" <a@.b.com> wrote in message
>news:uGdduPPQGHA.312@.TK2MSFTNGP12.phx.gbl...
>> Actually, I read this article. But I cannot down the SQL service and
>> rename the DB instance name as it said. What is other solution? Thanks.
>>
>> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>> message news:%23ZnjkyOQGHA.5400@.TK2MSFTNGP09.phx.gbl...
>> Hi!
>> error 14274: Cannot add, update or delete a job (or its steps or
>> schedules) that originates from an MSX server. The job was not save.
>> I guess this should help:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;281642.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor, www.SolidQualityLearning.com
>> Anything written in this message represents solely the point of view of
>> the sender.
>> This message does not imply endorsement from Solid Quality Learning, and
>> it does not represent the point of view of Solid Quality Learning or any
>> other person, company or institution mentioned in this message
>>
>>
>

error 14269

Hi
When i am changing the owner which is the default owner
for SQL Agent Job, I am getting error as
Error 14269: Job 'DB Maintenance Plan ' ia already
targteted at server xxxxxxx.
The jobs are failing becuase of other user created the
jobs.
Thanks,
John.Have you renamed this server? I'd check the value of the
originating_server in msdb..sysjobs to make sure it's
correct.
-Sue
On Wed, 5 Nov 2003 07:04:28 -0800, "John"
<anonymous@.discussions.microsoft.com> wrote:
>Hi
>When i am changing the owner which is the default owner
>for SQL Agent Job, I am getting error as
>Error 14269: Job 'DB Maintenance Plan ' ia already
>targteted at server xxxxxxx.
>The jobs are failing becuase of other user created the
>jobs.
>Thanks,
>John.

Error 14258: ... SQL ServerAgent is starting

Whenever I attempt to edit/run/... a scheduled job, I get the error message:
"Error 14258: Cannot perform this operation while SQL ServerAgent is
starting. Try again later."
I also notice that all scheduled jobs have "Date/time not available" in
"Next Run Date".
Of course Agent is not starting now, it has already started (Alerts and
Operators can be edited without a problem). The server is SQL2000, SP4.
Check the status of the service from Administrative Tools -
is the service Running or Starting?
Alerts and operators can be edited without Agent running.
Also check your Agent.out file.
-Sue
On Thu, 16 Feb 2006 03:55:29 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:

>Whenever I attempt to edit/run/... a scheduled job, I get the error message:
>"Error 14258: Cannot perform this operation while SQL ServerAgent is
>starting. Try again later."
>I also notice that all scheduled jobs have "Date/time not available" in
>"Next Run Date".
>Of course Agent is not starting now, it has already started (Alerts and
>Operators can be edited without a problem). The server is SQL2000, SP4.
|||The service IS running. I restarted it to make sure though, as I also did
with the server and the machine; nothing worked. The service is reported to
be running in both enterprise manager and windows services but no scheduled
jobs can be edited/run/...etc.
Also, when I stop the service I can edit jobs or create new ones, but there
is no way to run them.
There is no Agent.out file.
"Sue Hoegemeier" wrote:

> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||ok, I checked SQLAgent.out file. It has one entry:
"... ? [393] Waiting for SQL Server to recover databases..."
but I don't understand which databases it is recovering as there is no such
indication in SQL server logs or Current activity.
"Sue Hoegemeier" wrote:

> Check the status of the service from Administrative Tools -
> is the service Running or Starting?
> Alerts and operators can be edited without Agent running.
> Also check your Agent.out file.
> -Sue
|||If you tried stopping and then restarting just the Agent
service and it won't start, reporting the same error then my
guess would be that you are running SQL Server in
lightweight pooling mode. Set it back to the default of
thread mode.
sp_configure 'allow updates', 1
go
reconfigure with override
go
sp_configure 'lightweight pooling', 0
go
reconfigure with override
go
-Sue
On Fri, 17 Feb 2006 00:41:28 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>ok, I checked SQLAgent.out file. It has one entry:
>"... ? [393] Waiting for SQL Server to recover databases..."
>but I don't understand which databases it is recovering as there is no such
>indication in SQL server logs or Current activity.
>
>"Sue Hoegemeier" wrote:

Error 14258

For the last two days I've been getting this error whenever I click on a Job
in Enterprise Manager:
Error 14258: Cannot perform this operation while SQLServerAgent is starting.
Try again later.
Any idea what is causing this? Agent appears to be running - it is
performing the assigned tasks on schedule.Hi,
The SQLServerAgent has NOT started properly after a
shutdown/reboot two days ago. If you look at the service
manager, the service appears to have started, but its
really not.
Here is what you have to do:
Stop the SQLServerAgent (Not SQL Server)
Restart the service (make no errors are recorded)
Here is something else you may have not noticed, since
this error has been occurring, your scheduled jobs have
not run. You might want to backup your databases and run
any other jobs you may have.
hth
DeeJay
>--Original Message--
>For the last two days I've been getting this error
whenever I click on a Job
>in Enterprise Manager:
>Error 14258: Cannot perform this operation while
SQLServerAgent is starting.
>Try again later.
>Any idea what is causing this? Agent appears to be
running - it is
>performing the assigned tasks on schedule.
>
>.
>|||OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?
"DeeJay Puar" <deejaypuar@.Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@.phx.gbl...
> Hi,
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
> Here is what you have to do:
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
> hth
> DeeJay
> >--Original Message--
> >For the last two days I've been getting this error
> whenever I click on a Job
> >in Enterprise Manager:
> >
> >Error 14258: Cannot perform this operation while
> SQLServerAgent is starting.
> >Try again later.
> >
> >Any idea what is causing this? Agent appears to be
> running - it is
> >performing the assigned tasks on schedule.
> >
> >
> >.
> >|||I am also have a ongoing issue with this problem. Where you able to find
the root cause of this issue? Please let me know, as we are in bad need
of a solution to this problem.
Reply to thovorka@.quickutz.com
Thanks,
Todd
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Error 1105: 'PRIMARY' filegroup is full

I get the following error when attempting to run the
Database Maintenance Plan Optimization job for a database:
Rebuilding indexes for table 'WebLog'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not
allocate space for object '(SYSTEM table id: -933813458)'
in database 'svc2000WebLog' because the 'PRIMARY'
filegroup is full.
I am running SQL Server 2000 (SP3) on a Windows 2000 (SP4)
machine. There is plenty of disk space on the server. Do
I need to expand the database before running this job?SQL Server need working space in the db for DBCC DBREINDEX. Also, autogrow
doesn't catch up in some situations. See below. Consider pre-allocating
storage or using DBCC INDEXDEFRAG instead.
http://support.microsoft.com/default.aspx?scid=kb;en-us;305635
--
Tibor Karaszi
"Tom Griffin" <griffin@.co.santa-barbara.ca.us> wrote in message
news:042601c3a23d$5e190a70$a301280a@.phx.gbl...
> I get the following error when attempting to run the
> Database Maintenance Plan Optimization job for a database:
> Rebuilding indexes for table 'WebLog'
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not
> allocate space for object '(SYSTEM table id: -933813458)'
> in database 'svc2000WebLog' because the 'PRIMARY'
> filegroup is full.
> I am running SQL Server 2000 (SP3) on a Windows 2000 (SP4)
> machine. There is plenty of disk space on the server. Do
> I need to expand the database before running this job?
>

Error 1105 When Using SQLMaint To Reindex Tables

I have a standard reorganise/reindex job running against a 32GB database on SQl Srever 2000. When trying to run the job it fails and returns Error 1105 <'PRIMARY' filegroup is full>. What's confusing me is that I have 53GB free on the drive on which my Primary file group sits.

Has anyone else come accross this problem when trying to set up a regular reindex job?

(more detail) the maintenance plan only includes the reorganisation/reindex job, no other jobs - including backing up the DB - are included. The DB in question is the only DB on the server: it's a test server.Sounds like you've restricted the file growth size...go to the database properties and tell us what it's set to...|||Brett,

You were right, log size was being restricted. Funny how you miss the obvious stuff.....

Many Thanks

Matthew

Error 11 in Agent Job

We're getting an error message ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network documentati
on. [SQLSTATE 08S01] (Error 11). The step failed.
when running an agent job which updates from one Database to another but sti
ll on the same server. If we run the job from T-SQL it works fine. Eventuall
y though the service degenerates and we can't run the job as either an agent
or a T-SQL script and we h
ave to re-build the server.
Any ideas what would cause this problem and how we can rectify it?Please check your Server network utilities. Make sure that TCP/IP and Named
pipes values are not blank by clicking on the Properties.
thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||We have extensively tested the server and found the problem to be with a thi
rd party piece of software, Backup EXEC. Once this is removed the agent job
fires fine.
"akcsl" wrote:

> We're getting an error message ConnectionRead (WrapperRead()). [SQLSTA
TE 01000] (Message 258) General network error. Check your network documenta
tion. [SQLSTATE 08S01] (Error 11). The step failed.
> when running an agent job which updates from one Database to another but still on
the same server. If we run the job from T-SQL it works fine. Eventually though the s
ervice degenerates and we can't run the job as either an agent or a T-SQL script and
we
have to re-build the server.
> Any ideas what would cause this problem and how we can rectify it?
>

Error 11 in Agent Job

We're getting an error message ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
when running an agent job which updates from one Database to another but still on the same server. If we run the job from T-SQL it works fine. Eventually though the service degenerates and we can't run the job as either an agent or a T-SQL script and we h
ave to re-build the server.
Any ideas what would cause this problem and how we can rectify it?
Please check your Server network utilities. Make sure that TCP/IP and Named
pipes values are not blank by clicking on the Properties.
thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||We have extensively tested the server and found the problem to be with a third party piece of software, Backup EXEC. Once this is removed the agent job fires fine.
"akcsl" wrote:

> We're getting an error message ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
> when running an agent job which updates from one Database to another but still on the same server. If we run the job from T-SQL it works fine. Eventually though the service degenerates and we can't run the job as either an agent or a T-SQL script and we
have to re-build the server.
> Any ideas what would cause this problem and how we can rectify it?
>

Error 11 in Agent Job

We're getting an error message ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
when running an agent job which updates from one Database to another but still on the same server. If we run the job from T-SQL it works fine. Eventually though the service degenerates and we can't run the job as either an agent or a T-SQL script and we have to re-build the server.
Any ideas what would cause this problem and how we can rectify it?Please check your Server network utilities. Make sure that TCP/IP and Named
pipes values are not blank by clicking on the Properties.
thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error '0x8000ffff' occurred during full-text index population

I have a nightly job scheduled by the SQL Agent scheduler to run full-text
creations nightly, and I have noticed that the following error message
appears during the process of trying to index a number of tables (but not
all).
can someone please provide some advice as to what might be causing this
error to occur - and what I should be looking at to resolve this issue.
Regards
Andy MBCS CITP
Andy,
Do the SQL logs report any more information, or the Windows Event Logs?
Error '0x8000FFFF' (2147549183) often means "Unexpected failure", so
additional information from the logs might help.
RLF
"Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
news:DC3B2B34-7A26-44F0-B75E-E02ADD4CE07C@.microsoft.com...
>I have a nightly job scheduled by the SQL Agent scheduler to run full-text
> creations nightly, and I have noticed that the following error message
> appears during the process of trying to index a number of tables (but not
> all).
> can someone please provide some advice as to what might be causing this
> error to occur - and what I should be looking at to resolve this issue.
>
> --
> Regards
> Andy MBCS CITP
|||Russell
Unfortuanately the event logs tell me to look at the full crawl logs - and
it is the full crawl logs which have this error code contained within them.
If, as you suggest the code is a non specific one, how on earth am I going
to track down what is causing the error to be thrown in the first place!!
Thanks for your response - any other suggestions very welcome
Regards
Andy
Regards
Andy MBCS CITP
"Russell Fields" wrote:

> Andy,
> Do the SQL logs report any more information, or the Windows Event Logs?
> Error '0x8000FFFF' (2147549183) often means "Unexpected failure", so
> additional information from the logs might help.
> RLF
> "Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
> news:DC3B2B34-7A26-44F0-B75E-E02ADD4CE07C@.microsoft.com...
>
>
|||Andy,
I scoured my various crawl logs to see if I ever got the same message, but I
have not. I see that missing iFilters are an 'expected' error and are
reported on properly, etc, etc. through the problems that came to my mind.
Do the files that produce these errors remain the same from day to day? Do
they share any characteristic in common, such as file type, length of file
name, directory nesting, embedded bitmaps, etc? I have not a clue as to
what is wrong, but any information that gives a hint would help.
RLF
"Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
news:94FF8204-9A4F-4841-BF8E-CF7724E1EAAF@.microsoft.com...[vbcol=seagreen]
> Russell
> Unfortuanately the event logs tell me to look at the full crawl logs - and
> it is the full crawl logs which have this error code contained within
> them.
> If, as you suggest the code is a non specific one, how on earth am I going
> to track down what is causing the error to be thrown in the first place!!
> Thanks for your response - any other suggestions very welcome
> Regards
> Andy
> --
> Regards
> Andy MBCS CITP
>
> "Russell Fields" wrote:
|||Please see the following article from Microsoft.
http://support.microsoft.com/default.aspx/kb/243349
"Russell Fields" wrote:

> Andy,
> I scoured my various crawl logs to see if I ever got the same message, but I
> have not. I see that missing iFilters are an 'expected' error and are
> reported on properly, etc, etc. through the problems that came to my mind.
> Do the files that produce these errors remain the same from day to day? Do
> they share any characteristic in common, such as file type, length of file
> name, directory nesting, embedded bitmaps, etc? I have not a clue as to
> what is wrong, but any information that gives a hint would help.
> RLF
> "Andy Knott" <AndyKnott@.discussions.microsoft.com> wrote in message
> news:94FF8204-9A4F-4841-BF8E-CF7724E1EAAF@.microsoft.com...
>
>

error 0x80004005 when copying tables between servers

hi
I've got a job which copy tables between different servers .
I am feeding the tables one by one and the process of copying is in a loop so I have cotrol over the copying process.
it works fine but sometimes randomly I am getting

Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

and the process fails and this might happen for in any point and on any table and sometimes it runs all the way successfully!!
any idea what the problem might be!
ThanksDo the tables have exactly the same structure? If not then I'd suggest it is as indicated a simple conversion error due to a type mismatch.|||Yes they are exactly the same is if it isn't it shouldn't run successfully sometimes!|||

Kolf wrote:

Yes they are exactly the same is if it isn't it shouldn't run successfully sometimes!

Unless they aren't the same, but normally the data can be explicitly cast to the destination type. Perhaps, though, that sometimes there is data in the source that cannot be cast.

How do you copy the tables?|||using the SSIS Object trasfer task object, and also I have to mention it is from sql 2000 to 2005
thanks|||

Kolf wrote:

using the SSIS Object trasfer task object, and also I have to mention it is from sql 2000 to 2005
thanks

Can you by chance post the create table statement for your table in SQL Server 2000?

Error : Difference of two datetime columns caused overflow at runtime.

At my job is a dts package that is failing in SQL 2005. I am not a SQL
expert. I am just trying to fix. I put the query in Query Analyzer
and get this error:

(4322 row(s) affected)

Server: Msg 535, Level 16, State 1, Line 1
Difference of two datetime columns caused overflow at runtime.

I am just trying to understand what this means, what I should be
looking for and what could be wrong. Here is the query:

SELECT i.SerialNumber, '' AS mac_number, DATEDIFF([second], 'Jan 1,
1970', s.DateOrdered) AS Support_StartDt, DATEDIFF([second], 'Jan 1,
1970',
s.Warranty_Enddate) AS Support_EndDt,
DATEDIFF([second], 'Jan 1, 1970', c.Registration_Date) AS
Registration_Date, c.FirstName AS enduser_fname,
c.LastName AS enduser_lname, c.CompanyName AS
enduser_companyname, c.ContactEmail AS enduser_email, c.Address AS
enduser_address1,
c.Address2 AS enduser_address2, c.City AS
enduser_city, c.State AS enduser_state, c.Zip AS enduser_zip,
c.WorkPhone AS enduser_phone,
c.Fax AS enduser_fax, d.DealerName AS
dealer_companyname, d.ContactFirstName AS dealer_fname,
d.ContactLastName AS dealer_name,
d.Address1 AS dealer_address, d.City AS
dealer_city, d.State AS dealer_state, d.Zip AS dealer_zip,
d.ContactPhone AS dealer_phone,
d.ContactFax AS dealer_fax,
ISNULL(SUBSTRING(p.ProductName, 11, LEN(p.ProductName) - 10), 'unknown
IWP product') AS product_type, '' AS extra1,
'' AS extra2, '' AS extra3, '' AS extra4, '' AS
extra5, '' AS extra6, '' AS extra7
FROM tblInventory i full outer JOIN
tblDealers d ON i.DealerID = d.DealerID full
OUTER JOIN
tblSupport s ON i.InventoryID = s.InventoryID
full outer JOIN
tblCustomers c ON s.InventoryID = c.InventoryID
LEFT OUTER JOIN
tblProducts p ON LEFT(i.SerialNumber,
PATINDEX('%-%', i.SerialNumber)) = p.SerialPrefix
WHERE i.SerialNumber <> ''

Any ideas would be greatly appreciated.geekwagon@.gmail.com (geekwagon@.gmail.com) writes:
> At my job is a dts package that is failing in SQL 2005. I am not a SQL
> expert. I am just trying to fix. I put the query in Query Analyzer
> and get this error:
>
> (4322 row(s) affected)
> Server: Msg 535, Level 16, State 1, Line 1
> Difference of two datetime columns caused overflow at runtime.
>
> I am just trying to understand what this means, what I should be
> looking for and what could be wrong. Here is the query:
>
> SELECT i.SerialNumber, '' AS mac_number, DATEDIFF([second], 'Jan 1,
> 1970', s.DateOrdered) AS Support_StartDt, DATEDIFF([second], 'Jan 1,
> 1970',
> s.Warranty_Enddate) AS Support_EndDt,
> DATEDIFF([second], 'Jan 1, 1970', c.Registration_Date) AS

One or of the rows has a value that is in 2038 or later in one of the
columns. My bets are on Warranty_Enddate and somehas put in 99991231
for an infinite warranty.

(2038-01-19 03:14:07.000 is the time when the number of seconds since
1970-01-01 exceeds the range of an un integer.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||>From Transact-SQL Reference:

DATEDIFF produces an error if the result is out of range for integer
values. For milliseconds, the maximum number is 24 days, 20 hours, 31
minutes and 23.647 seconds. For seconds, the maximum number is 68 years.

ERROR - Subscription Failure (Please Help!)

The report subscription is returning the following error message.
How should I resolve this issue?
However, according to the Job executed, the process was successful but the
report manager is displaying the following.
ERROR:
Failure sending mail: The report server has encountered a configuration
error. See the report server log files for more information.
Also, the event viewer is displaying the following error message well.Also, the event viewer is displaying the following error message well.
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 11/30/2005
Time: 10:49:03 AM
User: NT AUTHORITY\SYSTEM
Computer: REPORTSERV
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: REPORTSERV
Caller User Name: NETWORK SERVICE
Caller Domain: NT AUTHORITY
Caller Logon ID: (0x0,0x3E4)
Caller Process ID: 5928
Transited Services: -
Source Network Address: -
Source Port: -
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Terry" wrote:
> The report subscription is returning the following error message.
> How should I resolve this issue?
> However, according to the Job executed, the process was successful but the
> report manager is displaying the following.
> ERROR:
> Failure sending mail: The report server has encountered a configuration
> error. See the report server log files for more information.
> Also, the event viewer is displaying the following error message well.
>
>