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 17827 from SQL Server 2005 Express Edition

Hi,
I'm using SQL server 2005 Express Edition in my solution and I've run into a
problem that I can't find any information about.
The application was running OK (for several days) until this happend just
out of the blue.
The application is written in C++ and we are using ADO to access the
database.
The authentication used with sql server user names and passwords.
I have not changed the password for any user
In the SQL server error log I found the following lines.
2007-03-15 01:34:01.13 Server Server resumed execution after being idle
209 seconds: user activity awakened the server. This is an informational
message only. No user action is required.
2007-03-15 02:34:01.61 Server Server resumed execution after being idle
213 seconds: user activity awakened the server. This is an informational
message only. No user action is required.
2007-03-15 03:11:00.78 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:00.78 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:00.80 Server Error: 17054, Severity: 16, State: 1.
2007-03-15 03:11:00.80 Server The current event was not reported to the
Windows Events log. Operating system error = 5(error not found). You may need
to clear the Windows Events log if it is full.
2007-03-15 03:11:02.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:02.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:05.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:05.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:11.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:11.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:23.45 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:23.45 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:48.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:48.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:12:38.31 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:12:38.31 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:14:16.67 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:14:16.67 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:15:55.91 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:15:55.91 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:17:35.19 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:17:35.19 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
Does anyone have any ideas why i get this behavior from SQL?
After we rebooted the system everything worked OK again.
Voja Tadic
Voja,
How many connections are being made to your SQL Express instance? Although
there is no hard limit to connections, there are resource limits on memory
and once those are used up, you will have problems.
Might you have many connections that should have closed during the several
successful days, but have not? If so, you many have many unused connections
still consuming resources.
The reason I ask is because the only instance of 17827 I see in Technet is
SQL Server 2000 extended stored procedure related and means: The maximum
number of '%1!ld!' remote connections is currently in use.
Although that is not directly your error, it may be a hint as to the
underlying problem.
RLF
"vojat" <vojat@.discussions.microsoft.com> wrote in message
news:0AD8C694-B1B5-462A-9425-B8C791BE63E6@.microsoft.com...
> Hi,
> I'm using SQL server 2005 Express Edition in my solution and I've run into
> a
> problem that I can't find any information about.
> The application was running OK (for several days) until this happend just
> out of the blue.
> The application is written in C++ and we are using ADO to access the
> database.
> The authentication used with sql server user names and passwords.
> I have not changed the password for any user
>
> In the SQL server error log I found the following lines.
>
> 2007-03-15 01:34:01.13 Server Server resumed execution after being
> idle
> 209 seconds: user activity awakened the server. This is an informational
> message only. No user action is required.
> 2007-03-15 02:34:01.61 Server Server resumed execution after being
> idle
> 213 seconds: user activity awakened the server. This is an informational
> message only. No user action is required.
> 2007-03-15 03:11:00.78 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:00.78 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:00.80 Server Error: 17054, Severity: 16, State: 1.
> 2007-03-15 03:11:00.80 Server The current event was not reported to
> the
> Windows Events log. Operating system error = 5(error not found). You may
> need
> to clear the Windows Events log if it is full.
> 2007-03-15 03:11:02.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:02.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:05.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:05.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:11.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:11.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:23.45 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:23.45 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:48.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:48.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:12:38.31 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:12:38.31 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:14:16.67 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:14:16.67 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:15:55.91 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:15:55.91 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:17:35.19 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:17:35.19 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
>
> Does anyone have any ideas why i get this behavior from SQL?
>
> After we rebooted the system everything worked OK again.
> Voja Tadic
|||Hi,
I only use one connection for this application and I'm closing the
connection after each action to the database. I'm also using the connection
pooling functionality in ADO. This application uses the database alot.
I do have one additional application that uses ADO.DET and connects,
retrives data and dissconects and then terminats. This is done ~20-30 times
each day.
"Russell Fields" wrote:

> Voja,
> How many connections are being made to your SQL Express instance? Although
> there is no hard limit to connections, there are resource limits on memory
> and once those are used up, you will have problems.
> Might you have many connections that should have closed during the several
> successful days, but have not? If so, you many have many unused connections
> still consuming resources.
> The reason I ask is because the only instance of 17827 I see in Technet is
> SQL Server 2000 extended stored procedure related and means: The maximum
> number of '%1!ld!' remote connections is currently in use.
> Although that is not directly your error, it may be a hint as to the
> underlying problem.
> RLF
> "vojat" <vojat@.discussions.microsoft.com> wrote in message
> news:0AD8C694-B1B5-462A-9425-B8C791BE63E6@.microsoft.com...
>
>
|||Voja,
I don't have any real good insight for you. You might look here for the
answer or someone to talk with:
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
RLF
"vojat" <vojat@.discussions.microsoft.com> wrote in message
news:0ACE3553-246E-46EC-936D-5A57E1181A02@.microsoft.com...[vbcol=seagreen]
> Hi,
> I only use one connection for this application and I'm closing the
> connection after each action to the database. I'm also using the
> connection
> pooling functionality in ADO. This application uses the database alot.
> I do have one additional application that uses ADO.DET and connects,
> retrives data and dissconects and then terminats. This is done ~20-30
> times
> each day.
>
> "Russell Fields" 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.
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.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Error 14058: The subscription already exists

Hi,
I've got the error in the Subject when I tried to delete and recreate
manually a pull subscription to a publication.
How can I delete defenitely the subscription from that database?
Thank you.
get your publication name and issue the following command in your
subscription database:
sp_droppullsubscription @.publisher = 'publisher' , @.publisher_db =
'publisher_db' ,[ @.publication = 'publication'
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Siu" <Siu@.discussions.microsoft.com> wrote in message
news:7957B486-16ED-498A-BAFC-2755E49555E1@.microsoft.com...
> Hi,
> I've got the error in the Subject when I tried to delete and recreate
> manually a pull subscription to a publication.
> How can I delete defenitely the subscription from that database?
> Thank you.
|||Hi Hilary,
thanks for your answer, but your code still gives the message that the
subscription doesn't exist... I'm also sure that I've written correctly all
the parameter, namely the publisher name, publisher db and the publication
name.
Do you think that there is another problem?
"Hilary Cotter" wrote:

> get your publication name and issue the following command in your
> subscription database:
> sp_droppullsubscription @.publisher = 'publisher' , @.publisher_db =
> 'publisher_db' ,[ @.publication = 'publication'
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:7957B486-16ED-498A-BAFC-2755E49555E1@.microsoft.com...
>
>
|||Hi Hilary,
now I solved the problem: I had to delete the pull subscription manually
from the Publisher database.
I have another question: when I started the syncronitation, I got the
following error:
"The process could not connect to Disctributor 'MYDISTRIBUTOR'. Login failed
for user'
How can I discover which USER NAME failed the login?
"Hilary Cotter" wrote:

> get your publication name and issue the following command in your
> subscription database:
> sp_droppullsubscription @.publisher = 'publisher' , @.publisher_db =
> 'publisher_db' ,[ @.publication = 'publication'
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Siu" <Siu@.discussions.microsoft.com> wrote in message
> news:7957B486-16ED-498A-BAFC-2755E49555E1@.microsoft.com...
>
>

error -132

hello
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.
Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto González" wrote:

> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>
|||Getting the same thing - any ideas?
"Paul J" wrote:
[vbcol=seagreen]
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto González" wrote:
|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a.MSDTC - Microsoft Distributed Transaction Coordinator
b.MSSEARCH - Microsoft Search
c.ReportServer - SQL Reporting Services
d.SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
[vbcol=seagreen]
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
[vbcol=seagreen]
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a.MSDTC - Microsoft Distributed Transaction Coordinator
> b.MSSEARCH - Microsoft Search
> c.ReportServer - SQL Reporting Services
> d.SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
[vbcol=seagreen]
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:

error 0xE0040200

Hello,

I′ve got this problem when I′m creating a new cube with the Microsoft Visual Studio 2005 8.0.550727.42 (RTM.050727-4200) and my operative system is Microsoft(R) Windows(R) Server 2003, Standard Edition. It isn′t the first cube I′ve created in this project, but it′s the the first time I get the problem.

Could someone help me?

Can you provide bit more informatio about the problem.

At what point you are getting the error?
Is that at deployment time or you get the error while running Cube Wizard?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I′m getting the error when I′m browsing the cube using the third level of a hierarchy. It happens whit all the hierarchies of the project so I think It isn′t a problem of the hierarchy.|||

Try installing SP1 of SQL server and see if the same problem happens.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.