Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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,621 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
[X]
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
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

 [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

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

704 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