Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

Batch file from remote server

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
dantheanswerman
Asked:
dantheanswerman
1 Solution
 
gery128Commented:
If you want to run it at specific interval or automatically, then you can use Windows Service to execute it.
0
 
dantheanswermanAuthor Commented:
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
 
dantheanswermanAuthor Commented:
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
 [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

 
awaggonerCommented:
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
 
Raymond PengSystems EngineerCommented:
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
 
dantheanswermanAuthor Commented:
This is what I was looking for!
Thanks,

Dan
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now