Authentication failure for perfectly good server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChanKaiShi - 02 Jul 2008 17:18 GMT

Hi,

I have really weird issue. SQL server is in workgroup, my account in local
administrator's group on machine, default setup so I'm sysadmin as well. I
can register to server with MS just fine, I can not all operations just fine.
But when I try to delete Maintainance Plan (some of them only) I get
following error (Login failed for user ''. The user is not associated with a
trusted SQL Server connection. (.Net SqlClient Data Provider)), in event
viewer I get 2 events (18542 and 17806), both of which showing SSPI handshake
failure with 0x8009030c error code.

Beaing in mind that server is part of workgroup it's using NTLM for
authentication and not kerberos. What can be the reason for this behaviour?

G

Reply to this Message

EugeneZ - 02 Jul 2008 21:57 GMT

try solution from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114

1. Select the ID with the select statement
select * from sysmaintplan_plans

2. Replace with the selected ID and run the delete statements
delete from sysmaintplan_log where plan_id = ''

delete from sysmaintplan_subplans where plan_id = ''

delete from sysmaintplan_plans where id = ''

3. Delete the SQL Server Jobs from sql agent

Signature

Thanks,
Eugene Zhitomirsky
MCT, MCDBA, MCP, OCP

> Hi,
>
[quoted text clipped - 15 lines]
>
> G

Reply to this Message

ChanKaiShi - 02 Jul 2008 22:10 GMT

Thanks,

I don't see that table (sysmaintplan_plans) neither in master or msdb

> try solution from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114
>
[quoted text clipped - 29 lines]
> >
> > G

Reply to this Message

EugeneZ - 03 Jul 2008 00:39 GMT

I see : sysmaintplan_plans is for sql server 2005

Tables that exists in SQL Server 2000 msdb are:
sysdbmaintplans
sysdbmaintplan_jobs
sysdbmaintplan_history
sysdbmaintplan_databases

Signature

Thanks,
Eugene Zhitomirsky
MCT, MCDBA, MCP, OCP

> Thanks,
>
[quoted text clipped - 33 lines]
> > >
> > > G

Reply to this Message