"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:i88fc29o14g6if70lfm8r1drls8i92afja@4ax.com...
> Did you check the SQL Server error log for more information
> on the suspect database? Does the service account have full
> rights, access to the directories where the data and log
> files are located?
>
> -Sue
>
> On Wed, 26 Jul 2006 09:00:17 -0400, "Bill Papanestor"
> <bill@figtree.com> wrote:
>
>>I am trying to setup a domain user to that will be used to start-up the
>>SQL
>>server and agent services.
>>I am on a 2003 domain using SQL 2000 SP 4
>>
>>The domain user is not part of the local administrators group where the
>>SQL
>>Server is loacted but I have assigned the local policy privileges as
>>follows;
>>
>>Act as part of operating system
>>Bypass traverse checking
>>Lock pages in memory
>>Log on as a batch job
>>Log on as service
>>Replace a process level token.
>>
>>
>>Although the sql server service will start, one of the databases shows as
>>suspect. The database will not show a suspect if I start the service with
>>an account that is part of the local administrator group.
>>
>>I don't want the service account to be part of the local admin group. What
>>am I missing?
>>
>>
>>Thanks
>>Bill Papanestor
>>
>

"Bill Papanestor" <bill@figtree.com> wrote in message
news:OryD5yOsGHA.3832@TK2MSFTNGP06.phx.gbl...
> Sue,
>
> Great idea!!! I wish I thought of this.
>
>
> The logs do indicate that in this one database the following messages;
>
> udopen: Operating system error 5(Access is denied.) during the
> creation/opening of physical device h:\vamdata_tech\vamsystemdata.mdf.
>
> FCB::Open failed: Could not open device h:\vamdata_tech\vamsystemdata.mdf
> for virtual device number (VDN) 1.
>
> Device activation error. The physical file name
> 'h:\vamdata_tech\vamsystemdata.mdf' may be incorrect.
>
>
>
>
> "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:i88fc29o14g6if70lfm8r1drls8i92afja@4ax.com...
>> Did you check the SQL Server error log for more information
>> on the suspect database? Does the service account have full
>> rights, access to the directories where the data and log
>> files are located?
>>
>> -Sue
>>
>> On Wed, 26 Jul 2006 09:00:17 -0400, "Bill Papanestor"
>> <bill@figtree.com> wrote:
>>
>>>I am trying to setup a domain user to that will be used to start-up the
>>>SQL
>>>server and agent services.
>>>I am on a 2003 domain using SQL 2000 SP 4
>>>
>>>The domain user is not part of the local administrators group where the
>>>SQL
>>>Server is loacted but I have assigned the local policy privileges as
>>>follows;
>>>
>>>Act as part of operating system
>>>Bypass traverse checking
>>>Lock pages in memory
>>>Log on as a batch job
>>>Log on as service
>>>Replace a process level token.
>>>
>>>
>>>Although the sql server service will start, one of the databases shows as
>>>suspect. The database will not show a suspect if I start the service
>>>with
>>>an account that is part of the local administrator group.
>>>
>>>I don't want the service account to be part of the local admin group.
>>>What
>>>am I missing?
>>>
>>>
>>>Thanks
>>>Bill Papanestor
>>>
>>
>
>