Solved

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

Posted on 2011-03-24
6
3,284 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 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
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

920 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now