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
LVL 2
dantheanswermanAsked:
Who is Participating?
 
Raymond PengConnect With a Mentor Systems 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
 
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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

Dan
0
All Courses

From novice to tech pro — start learning today.