Prev: Problem with the cursor and dbname
Next: SQL 2000 accessing DB2
From: ChanKaiShi on 2 Jul 2008 12:18
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


From: EugeneZ on 2 Jul 2008 16:57
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
--
Thanks,
Eugene Zhitomirsky
MCT, MCDBA, MCP, OCP


"ChanKaiShi" wrote:

> 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
>
>
From: ChanKaiShi on 2 Jul 2008 17:10
Thanks,

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

"EugeneZ" wrote:

> 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
> --
> Thanks,
> Eugene Zhitomirsky
> MCT, MCDBA, MCP, OCP
>
>
> "ChanKaiShi" wrote:
>
> > 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
> >
> >
From: EugeneZ on 2 Jul 2008 19:39
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
--
Thanks,
Eugene Zhitomirsky
MCT, MCDBA, MCP, OCP


"ChanKaiShi" wrote:

> Thanks,
>
> I don't see that table (sysmaintplan_plans) neither in master or msdb
>
> "EugeneZ" wrote:
>
> > 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
> > --
> > Thanks,
> > Eugene Zhitomirsky
> > MCT, MCDBA, MCP, OCP
> >
> >
> > "ChanKaiShi" wrote:
> >
> > > 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
> > >
> > >
 | 
Pages: 1
Prev: Problem with the cursor and dbname
Next: SQL 2000 accessing DB2