They would need to access a Web App which in turn would have a SQL Server back-end.

Yes - I was thinking an AD Group / User. Add the group /...

It worked!

Do you know how I would have arrived at this as all my other servers are fine?? Seems like an order of installation /setup to me.

Many thanks again.

I have now run the setspn command and received the following message:

C:\Program Files\Resource Kit>SETSPN -L PAPOTH17

Registered ServicePrincipalNames for CN=PAPOTH17,OU=Application Servers,OU=Serve

rs,DC=intra,DC=blackburn,DC=gov,DC=uk:

MSSQLSvc/papoth17.intra.blackburn.gov.uk:1433

HOST/PAPOTH17

...

Thanks.

Where do I run the SETSPN -L command? At the command prompt?

Thanks for the response - yes all instances were selected when I used SP3, but for some reason my SP2 only selected the default? Hence the confusion.

Thanks for the response.

However, the issue is that if I try to apply a filter to this statement, say <= 2, it is automatically changed to <= TO_DATE(2, 'J')...

Yes that does make sense. As well as an AD group, you can't disable a user AD account either.

Maybe it would have been clearer if the options were hidden or...

Thanks all. The penny has dropped!

The thing that threw me was the Grant / Deny option on the status tab of the Login Properties dialog.

Thanks for the detailed response.

So if i don't want a SQL Server Login to access SQL Server itself I set the status to disabled and this will overide everything.

If a...

By using progression/inheritance are you meaning have all the tasks in one subplan and use the Precedence contraints?

Thanks for the confirmation. Yes I have separate system and user Maintenance Plans, with jobs scheduled to be run at different times.

This link explains all!

http://msdn.microsoft.com/en-us/library/ms143504(printer).aspx

Just a thought - has this changed in SQL 2005 - I'm sure I've done the same thing there without adverse effects?

Thanks John. Problem sorted and understood.

That's a good point. How can I see if i am a member of BUILTIN\Administrators?