Reasons for [382] Logon to server '(local)' failed (JobManager) Message 
Author Message
 Reasons for [382] Logon to server '(local)' failed (JobManager) Message
Hi,

On a fairly heavily used SQL2000 SP2 + security fixes server we get the
following messages quite often:-

[165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
[382] Logon to server '(local)' failed (JobManager)

and our transaction log backup jobs fail at this time.

We are looking at 306457 as a fix but does anybody have any other ideas why
this could be happening?

Thanks

Chris Wood
Alberta Department of Energy
CANADA



Tue, 27 Sep 2005 16:20:02 GMT
 Reasons for [382] Logon to server '(local)' failed (JobManager) Message

Hi There,

I had a problem the last couple of days on error382 in SQL 2000 relating
to invalid login ids and what else more.

I traced it back that someone resotred several databases on the network.

My setup is 7 SQL instances and what seems to happen is the SA account
of the other sql instances were used as the actual SQL instance (The one
with the problem) and running the jobs.

The jobs worked fine yea, but the notifications and all did not go away.

I changed the job owner to my local account on the domain and ever since
then i did not get a repsonse from SQL Agent.

God Luck , and if it fixed your problem please buzz.

Kind Regards
Xcorporation

--
Posted via http://dbforums.com



Sat, 01 Oct 2005 16:33:58 GMT
 Reasons for [382] Logon to server '(local)' failed (JobManager) Message
The messages show in the SQLAGENT log and we have not restored any databases
or changed permissions on the server.

Thanks

Chris


Quote:

> Hi There,

> I had a problem the last couple of days on error382 in SQL 2000 relating
> to invalid login ids and what else more.

> I traced it back that someone resotred several databases on the network.

> My setup is 7 SQL instances and what seems to happen is the SA account
> of the other sql instances were used as the actual SQL instance (The one
> with the problem) and running the jobs.

> The jobs worked fine yea, but the notifications and all did not go away.

> I changed the job owner to my local account on the domain and ever since
> then i did not get a repsonse from SQL Agent.

> God Luck , and if it fixed your problem please buzz.

> Kind Regards
> Xcorporation

> --
> Posted via http://dbforums.com



Sat, 01 Oct 2005 22:47:40 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Logon to server '(local)' failed (SaveAllSchedules)

2. logon failed for user '(null)'

3. Logon failed for user '\'.;42000

4. Logon Failed user '\'

5. Method 'Protect' failed error message

6. message 'update or delete failed'

7. sp_OACreate 'CDO.Message' fails

8. OpenSchema Fails With 'Errors Occurred' Message

9. message 'update or delete failed'

10. sp_OACreate 'CDO.Message' fails

11. (HELP) SCSI transport failed:reason 'timeou

12. login failed for user 'NT AUTHORITY\ANONYMOUS LOGON


 
Powered by phpBB® Forum Software