Clearly you won't be able to create the share and permissions using the account that you're trying to add. That would just be stupid.

You need to use another account - an administrator account might be a good idea - on the remote computer to create the share and set up appropriate security both on the folder itself and on the share. Only then will you be able to access it using your sql server account.

Hi mr_mistyou are right(you understand my problem, how could i create an folder, who having the permission/rights of an account, which is at remote side).Now what i did is, I create a folder at client( with Administrator Permission/Rights, full controls). but when try to access, same problem.

Hi samuelclayYou are talking about the SQL Server Agent Account. What i did is, the SQL Server Agent Service has account is 'Rep'(have Admin rights) to logon. I mean, this service uses the 'Rep' account.But still the same Problem.

Hi PesoStill i am not able to understand how to create such folder?-------------Please excuse me, if the problem is on my side( as i had tried my best to sove this)Please....pleasecan some body tell me Step by step procedure to over come this problem?orwhat special need to be done?

"still i am not able to cerate the Shared folder(at client, VSNET1), with account at remote(VSNET5, SQL Server) user(Rep).""how could i create an folder, who having the permission/rights of an account, which is at remote side"If I understand you correctly, user Rep has administrators rights in VSNET5. Does user Rep has administrators rights as well in VSNET1 ?

Hi khtanDoes u mean, both Client as well as Server should have same accounts 'Rep' ?if so, no i have only one account with name as 'Rep', the SQL Server M/C.should i try to create on the both m/c, with same account name 'Rep' ?

OMG!The account REP, that is a Windows account, right?Go to the client machine. Open Windows Explorer. Click on the directory where you want to save data to, from the SQL Server machine.Now open the context menu (right click) and select "Sharing..."In the sharing tab, click "Share this folder". In the security tab, if everyone already has full control, click OK. If not, add everyone to this folder.

Not only the SHARE has to have the proper permnissions, also the folder for which the share is created.If you create a new folder under c$ (as pppp or any other name), the parent folder (c$) also need to have everyone and "set child permissions" option set.

Man, i dont know where the things are going wrong, i too check the root c$, its already having the 'everyone' share rights(with child permissions too), i too add the 'Administrator + Rep' but the same problem.Regards,Thanks.Gurpreet S. Gill

Jen Basically, i had created two SPs, one generates the Backup(table+data) & other Restore 4om that backup. Now the client wants, if he is using the client connectivity tool(SQL Talk in my case), the backup should be stored in the client hard drive, not on the server because not all person having rights to touch the SQL Server.

They want the backup at client folder, right, understand ?

The SP uses the commands like BCP, SQLCMD, SCPTXFR.EXE & to execute then all xp_cmdshell is used.

Now tell me the solution to store at client end. i try the UNC path format but getting this problem