Solved

Batch file from remote server

Posted on 2012-03-26
6
327 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
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

810 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