Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3946
  • Last Modified:

Error : xp_create_subdir() returned error 183, 'Can't Create file when that file already exists'

I'm going to create directory using xp_cmdshell , But I got following error: "xp_create_subdir() returned error 183, 'Can't Create file when that file already exists' !
But there isn't exist any file at the given Physical location !
I'm using SQL SERVER 2008 on Windows 7 (64 bit) & using SQL Server service account ='Local System'.
0
vikasbapat
Asked:
vikasbapat
  • 3
  • 3
1 Solution
 
FireW0lfCommented:
1. Check the folder permissions on your network share
2. LOCAL SYSTEM is precisely that - the local system. You need to use NETWORK SYSTEM
0
 
vikasbapatAuthor Commented:
close questions
0
 
vikasbapatAuthor Commented:
Folder permissions are granted to 'everyone' & also now i'm using Service Account as NETWORK SYSTEM but still i'm facing the same error !
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
FireW0lfCommented:
Okay, so folder share permissions are "Everyone" - "Full Control"

In Security do "Everyone" also have "Modify" or "Full Control"? Try adding NETWORK SYSTEM in the Security tab and give it "Full Control"
0
 
FireW0lfCommented:
Ooops I mean of course NETWORK SERVICE not SYSTEM

 Sorry, was thinking about my holidays...  ;-)
0
 
vikasbapatAuthor Commented:
Thank you.
I will try this one !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now