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

Posted on 2011-03-24
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'.
Question by:vikasbapat
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Accepted Solution

FireW0lf earned 50 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

Author Comment

ID: 35321250
close questions

Author Comment

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 !
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI


Expert Comment

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"

Expert Comment

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

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

Author Comment

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
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…

628 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