Hi Calvo

i do not have capability to call MS.

I found some info on some more policies that may be issue so i will try adding those in

I posted on a...

Anyone

still no luck

tree tries, three failures

Updating permission setting for folder 'C:\Program Files\Microsoft SQL Server\100\DTS\' failed.

The folder permission setting were supposed to be set to

'DA;OICI;FA;;;BA)(A;OICI;FA;;;SY)(A;OICI;FA;;;CO)(A;OICI;0x1200a9;;;BU)

Thanks

Well..

thanks for your time Calvo

I am trying again to see how far i can get

Jim

Thanks Calvo

the sevice is there

the problem is that this damn AFB has locked everything down so it is very difficult to even install software now because they have tweeked these...

Yes

i tried to use my service account but it would not take it due to some more security

(Windows 2008 R2 really stinks)

i used one of the defaults: NT AUTHORITY/NETWORK

and...

H iCalvo

Are you a local admin?

Yes

Try putting the service account in the local admin group to allow it to change permissions on directories.

Which service account are you referring to ?

Jim

Thanks for the advice GSquared

I will look into it

Jim

Thanks Elliot

nothing in 2005

Jim

Thanks GSquared

i am beginning to think that these Maint Plans, though a good idea, have a lot to be desired

i hate to re-write everything i have done in SSMS and...

Thanks GreyBeard

Hi Sean

that was it

thanks

one other quirk when i type some incorrect sql in the sqlcmd window i get a "~" after the number

how do you get out of that...

i could not figure how to put the code in and use a code tag

any instructions would be appreciated

Jim

Yes

sorry about that

Okay

Thanks Steve

Jim

Thanks Steve

when I installed sql server 2005 there were a few documents I was able to locate

same for 2008, which mostly used sql server 2005

windows 2008 r2 running sql server...