Start Analysis Services on the server remotely from the local computer


Emraan

I need to start Analysis Services on a server remotely from my local computer.

I also want to make it a batch command.

Remote server: sqgdbfhhs001. Analysis Services: MSSQLServerOLAPService.

Any help would be greatly appreciated.

Thanks, IRK

Emraan

I got the answer. :)

Step 1) Enter the following text in Notepad and save it as a .bat file

PowerShell.exe -Command "&{Start Processing PowerShell.exe -ArgumentList' -ExecutionPolicy Bypass -File ""%~dpn0.ps1""' -Verb RunAs}"

sc\sqgdbfhhs001 stop "MSSQLServerOLAPService" sc\sqgdbfhhs001 start "MSSQLServerOLAPService"

Step 2) Create a shortcut to the .bat file. Step 3) Right-click the shortcut's Properties, click Advanced, and then click the "Run as administrator" checkbox.

Thanks, IRK

Related


Clone git from local computer to my server?

matrix I use git to version control a project on my local computer. I bought a server, installed git, and now I want to clone my local project onto the server (as opposed to what we usually do). I don't have gitlab or github here. How can I do this? How to dow

Clone git from local computer to my server?

matrix I use git to version control a project on my local computer. I bought a server, installed git, and now I want to clone my local project onto the server (as opposed to what we usually do). I don't have gitlab or github here. How can I do this? How to dow

Automatically sync files from server to local computer

Amit Currently , as a backup method, I run a job crontabon my computer every Friday at 3am . The job runs a bash script that runs a rsynccommand to sync files from the server to my external hard drive. The rsync command uses this --include-fromflag to get a li

Connect to server from local computer - SSH

newbie girl Here is the process I use: $ cd .ssh bash: cd: .ssh: No such file or directory $ ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/home/user/.ssh/id_rsa): - ENTER - Enter passphrase (empty for no passphrase):

Automatically sync files from server to local computer

Amit Currently , as a backup method, I run a job crontabon my computer every Friday at 3am . The job runs a bash script that runs a rsynccommand to sync files from the server to my external hard drive. The rsync command uses this --include-fromflag to get a li

Connect to server from local computer - SSH

newbie girl Here is the process I use: $ cd .ssh bash: cd: .ssh: No such file or directory $ ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/home/user/.ssh/id_rsa): - ENTER - Enter passphrase (empty for no passphrase):

Link the server to Analysis Services

testtest11 After defining a linked server on SQL Server 2016 (13.0.1711.0): EXEC master.dbo.sp_addlinkedserver @server = N'CUBELINKEDSERVER', @srvproduct=N'MSOLAP', @provider=N'MSOLAP', @datasrc=N'POWER', @catalog=N'Model' /* For security reasons the linked s