473,597 Members | 2,715 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

sql server master.dbo.xp_c mdshell error : access denied

1 New Member
Hello all,

I'm new.
I'm trying to run a scheduled task from SQL Server.
The meaning is to run it from a server to another server. Let's say that Server1 is where the command is executed and the scheduled task exists in the Server2. Here's what i do :

EXEC master.dbo.xp_c mdshell "net use \\Server2 password /user:username /persistent:yes"

exec master.dbo.xp_c mdshell 'schtasks /run /S Server2 /U username /P password /tn "TaskName"'

When i execute it i get this error : Error : access is denied.

Can you tell me what's wrong ?

Thank you very much.

Sep 23 '14 #1
1 2932
2,878 Recognized Expert Specialist
Check the account being used to run the command shell. And see if it has the necessary rights. Not because you run it does not mean it's using your account.

Good Luck!!!

~~ CK
Oct 8 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Andrew Alger | last post by:
Ok here is the story. Test Environment: 1 IIS Box Win 2k 1 SQL Box Win 2k Live Environment: 1 IIS Box Win 2k3 1 SQL Box Win 2k
by: Lyn Duong | last post by:
Hi, I have tried creating a linked server in microsoft sql 2000 to a db2 for vm database. I use a db2 v8 admin client, configure it via client configuration setup and then in Microsoft SQL Server 2000 enterprise manager, I create a linked server, I use ibm oledb driver for db2, datasource = mydatabase, product=my database, provider = db2oledb. When I try to access the database via an openquery to the linked server, I get an error from...
by: Michael Hetrick | last post by:
If I set authorization in a web.config file to only allow certain individuals access to pages, those users who are not named receive an access denied message: --------------------------------- Access is denied. Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.
by: Martin Strojek | last post by:
Hi, I have the following problem with developing some web site. I use Visual Studio 2003 to build a website. I tried Windows 2003 Server and switched now back to Windows XP with PWS but the error occurs in both installations. When I do a compile/build of my app and go to the browser and hit reload there comes an error:
by: rupaliannetsite | last post by:
Hi, I have C# application and SQL Server database. This application runs fine locally however when migrated to production server it gives "SQL server doesnot exists or access denied" error message. Need help urgently
by: markus.rietzler | last post by:
i want to do (multiple) file upload(s) and display a progress bar. with firefox and safari it is no problem at all. only IE makes some problems. my script is based on ajax-uploader, which can be found at www.srmiles.com/freestuff/ajax_file_uploader/ . you can do multiple file uploads. each upload will have it's own "form"-tag, so that each file is uploaded for its own. could be a good solution if there are "big" uploads.
by: bhing | last post by:
please help me.. i dont really understand whats happening in my server.... i have a website using php... when i try to access it this is the message.... Fatal error: Access denied for user 'apache'@'localhost' (using password: YES) why is that so? when in fact i dont have any apache user on my mysql.user, please.. i really need the answer asap.. tnx
by: jayman9782 | last post by:
Hey all, I'm having a common problem under different circumstances. A little background information: I am running an "in-house" ASP web application in .NET 1.1 with a back-end in SQL Server 2000. The application is on a separate server from the SQL server. About 99% of the time users are able to sucessfully log into the SQL server and the other 1% of the time they get this nasty message "SQL Server does not Exist or Access Denied". When I get...
by: Klaus Bilger | last post by:
Hi all, looks like I have a big problem to use a VB.NET function, please help me out ;-) I try to connvert a vbs to vb.net I use the getservice Function to list all services with the current status in a small vb application on a local machine the code works fine
by: Robert Bustos | last post by:
Hello everyone, I am a newbie here and I need some help. I am trying to install a bug tracking application called MantisBT on a Windows Server 2008 machine. It requires a Web Server - running Apache 2.2, PHP 5, and Mysql 5.5. Apache is running and I have verified that PHP and MySQL are communicating with one another. When trying to run the actual MantisBT application I get the following error message: APPLICATION ERROR #401 ...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.