Run Bat file in Administrator Mode in Windows Server 2008

batch-filevbscriptwindows-command-promptwindows-server-2008

runas.exe /profile /user:administrator "C:\temp\SQLSP3.bat"

will run the SQLSP3.bat file in Administrative Prompt and it is asking Adminstrator password in Windows Server 2008.

SQLSP3.bat file has following code

C:\Temp\SQLSP3.exe /qs /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances

Is there any option which i can code the Administrator Password in any of the Script file ?

I don't want UAC to ask me the password. Everything needs to happen silently.
Please help me.

Best Answer

The problem with coding an administrator password into the script file is that you're exposing said password directly to the user. If you don't mind doing that, you're actually better off just giving admin rights to the user (even if it's temporary).

For this upgrade, I gather the rights you need are: Backup files and directories (SeBackupPrivilege) Debug Programs (SeDebugPrivilege) Manage auditing and security log (SeSecurityPrivilege)

If you can, use something like psexec - https://technet.microsoft.com/en-us/sysinternals/psexec.aspx to execute the upgrade remotely. Then you can deploy it from a remote system, where you can enter admin credentials and point the upgrade to the target system.

That's about as lightweight as you can get, so far as I know. Past that, you'll need to investigate remote deployment options. https://serverfault.com/questions/tagged/deployment

Related Solutions

How to Run a .bat File in a Scheduled Task Without a Window

You could run it silently using a Windows Script file instead. The Run Method allows you running a script in invisible mode. Create a .vbs file like this one

Dim WinScriptHost
Set WinScriptHost = CreateObject("WScript.Shell")
WinScriptHost.Run Chr(34) & "C:\Scheduled Jobs\mybat.bat" & Chr(34), 0
Set WinScriptHost = Nothing

and schedule it. The second argument in this example sets the window style. 0 means "hide the window."

Complete syntax of the Run method:

 object.Run(strCommand, [intWindowStyle], [bWaitOnReturn])

Arguments:

object: WshShell object.
strCommand: String value indicating the command line you want to run. You must include any parameters you want to pass to the executable file.
intWindowStyle: Optional. Integer value indicating the appearance of the program's window. Note that not all programs make use of this information.
bWaitOnReturn: Optional. Boolean value indicating whether the script should wait for the program to finish executing before continuing to the next statement in your script. If set to true, script execution halts until the program finishes, and Run returns any error code returned by the program. If set to false (the default), the Run method returns immediately after starting the program, automatically returning 0 (not to be interpreted as an error code).

Run bat file at startup

Windows Scheduler -- When my computer starts

I'm pretty sure you can the built-in Windows Scheduler to execute your batch file on startup.

Try this:

Start > Programs > Accessories > System Tools > Scheduled Tasks

Select the location of your batch file and on the next page select "When my computer starts".

You may also want to move it to somewhere OTHER than the startup folder to avoid "weirdness".

Good luck!

Best Answer

Related Solutions

How to Run a .bat File in a Scheduled Task Without a Window

Run bat file at startup

Related Topic