Solved

Batch file from remote server

Posted on 2012-03-26
6
330 Views
Last Modified: 2012-03-26
Experts - Please help!!

I have a need to run a batch file on a server (as if it was executed as an administrator on that server) from a remote server.

-- I cannot use TSQL to run the batch file as our IT department will not grant me the permissions to do it.
It is on a Windows 2008 R2 Server with SQL Server 2008 R2.

Any ideas?!

Thanks,
Dan
0
Comment
Question by:dantheanswerman
[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
6 Comments
 
LVL 9

Expert Comment

by:gery128
ID: 37766050
If you want to run it at specific interval or automatically, then you can use Windows Service to execute it.
0
 
LVL 2

Author Comment

by:dantheanswerman
ID: 37766062
Sorry for not being clearer while posing the question ...

Thanks for the idea... but it's gotta be on demand by a regular user with limited permissions.
0
 
LVL 2

Author Comment

by:dantheanswerman
ID: 37766103
To further clarify -- RDP (Remote Desktop Protocol) is out as we cannot (as far as I know) have a user login and run a batch file unless we give them enough access to do some serious damage to a server...
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 6

Expert Comment

by:awaggoner
ID: 37766114
I would suggest working with your IT department instead of trying to work around their security.

This sounds like more of a problem with internal policies instead of a technical issue.

If you can put forward a good case for the batch file being ran, then IT should be able to modify their security settings, or find a different method to perform the same functionality without affecting the server security.
0
 
LVL 16

Accepted Solution

by:
l33tf0b earned 500 total points
ID: 37766553
You may want to look into PSEXEC utility

http://technet.microsoft.com/en-us/sysinternals/bb897553

It allows you to run commands remotely as administrator on a remote machine.
0
 
LVL 2

Author Closing Comment

by:dantheanswerman
ID: 37767715
This is what I was looking for!
Thanks,

Dan
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

752 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