How to add NTFS computer account permissions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Security (SS2K8) » How to add NTFS computer account permissions

How to add NTFS computer account permissions

Rate Topic

Display Mode

Topic Options

Author

Message

foxxo

Posted Monday, August 06, 2012 9:19 PM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 6:13 PM
Points: 712, Visits: 1,053

I'm having an issue with a SQL 2008 R2 cluster. Recently I had to move the system databases off a faulty LUN to a newly added drive. This all went fine, until a scheduled fail-over event when the SQL instance would not start on the opposite server due to a permissions error (OS error 5) on the master.mdf file. Failing back to the original server works fine.

Looking at the old drive NTFS permissions, the only difference is that it has "MSSQL$InstanceName" user with full read/write access to the MSSQL\Data folder.

The new drive has full read/write permissions for a local windows group which has the SQL Server service account (domain\svcSQLaccount) as a member. This service account is running the SQL instance.

How do I get the "MSSQL$InstanceName" as an account to enable it full access to the new drive? The account does not appear when attempting to add it via NTFS security permissions on the folder.

Post #1340981

foxxo

Posted Tuesday, August 07, 2012 7:06 PM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 6:13 PM
Points: 712, Visits: 1,053

Following up to this in case anyone ever reads it.. a simple fix.. add the user "NT Service\MSSQL$InstanceName" which then appears as "MSSQL$InstanceName" to the DATA folder NTFS permissions.

Post #1341643

« Prev Topic | Next Topic »

Permissions