question

Kristen avatar image
Kristen asked

File access from SQL 2008 / Windows 2008 R2

I am migrating some Admin SProcs to SQL 2008 / Windows Microsoft Windows NT 6.1 (7600). They need to check the filesystem.

I've set Surface Configuration : XPCmdShellEnabled to True, so I suspect that my problem is with file permissions.

What User ID am I looking for to set Folder / File permissions for?

EDIT: Control Panel tells me there is a user called "SQL Service"

If I try to add that user to the MSSQL folder I get "Name not found"

There is a user with permissions for the folder:

SQLServerMSSQLUsers$MyServerName$MSSQLSERVER

that user only has Read/List permissions - do I just need to increase that user to Full Control?

sql-server-2008permissions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Matt Whitfield avatar image
Matt Whitfield answered

The user ID to give permissions to is the user ID under which the service is running, which is not fixed.

Also be sure to check the effective permissions you get, as a deny will over-ride a grant.

An exact error message would probably help though.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.