Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL User cannot access file system with functions or queries

Avatar of Matt Bartlett
Matt BartlettFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL ServerSQL
4 Comments1 Solution140 ViewsLast Modified:
I have a user that is trying to run an SQL function that includes:
xp_dirtree @directory, 10, 1

in SQLServer 2008.

The function works fine on other accounts that people use but on this users account it doesn't seem to allow their SQL user account to access the file system.

I cannot work out if the access to the file structure is a setting within SSMS on the user account there or if it something within the file permissions on the file server or something within the settings of the users domain account.

The Set-up is SQL Server 2008.
File Server is Windows Server 2012 R2
SQL Server is Windows Server 2008 R2
The User has "Owner" level permission on the database where the function and output tables are stored.
The User has "modify" permissions

Any help would be great.

Kind Regards

Avatar of Daniel_PL
Daniel_PLFlag of Poland imageDB Expert/Architect
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers