Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-03-24
6
Medium Priority
?
3,703 Views
Last Modified: 2012-05-11
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
Comment
Question by:vikasbapat
  • 3
  • 3
6 Comments
 
LVL 4

Accepted Solution

by:
FireW0lf earned 200 total points
ID: 35206151
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
 

Author Comment

by:vikasbapat
ID: 35321250
close questions
0
 

Author Comment

by:vikasbapat
ID: 35330738
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 4

Expert Comment

by:FireW0lf
ID: 35331061
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
 
LVL 4

Expert Comment

by:FireW0lf
ID: 35331192
Ooops I mean of course NETWORK SERVICE not SYSTEM

 Sorry, was thinking about my holidays...  ;-)
0
 

Author Comment

by:vikasbapat
ID: 35442160
Thank you.
I will try this one !
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question