<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=134816313595691&amp;ev=PageView&amp;noscript=1">

RemoteRelief BLOG

Let's talk business technology...

All Posts
Reading Time: 1 minutes
 
Published on 3/9/20 12:46 PM

Execute Any SQL Server Script using RemoteLink sessions and Powershell Scripts.

Introduction

When it comes to SQL, users will be asking about their scheduled jobs, related data, or they may want to troubleshoot an issue. The user may or may not be able to access the SQL Server database from their computer. The user will need a tool that will allow them to use their own SQL script to pull the desired information.

Process

With RemoteRelief, you will have access to specified tools on your RemoteLink server that allows the user to execute any SQL Script against the RemoteLink database. Whether the user schedules it or runs it on-demand, the RemoteLink session will be able to execute multiple SQL scripts if needed (depending upon your needs).

RemoteRelief will provide the user with a custom PowerShell script that will accept their SQL Script(s). RemoteRelief will provide the user with a tool on the RemoteLink server to execute any SQL Script against the RemoteLink database. It can be scheduled or ran on-demand, the RemoteLink session will be able to execute multiple SQL scripts if needed. These scripts could be a simple “SELECT” or a Stored Procedure execution.

What You Need

There is just one requirement: The user will need to make sure that the RemoteLink service account has appropriate access to the RemoteLink database when running any SQLs. If the account has ‘read only’ access and your script is trying to create a ‘temp’ or ‘backup table’, it may fail. *Side Note: The user will need to ensure the scripts are accurate before pushing them to all devices via RemoteLink server or it too may fail.

Need Help?

RemoteRelief has SQL, SQL Database, and RemoteLink subject matter experts (SME), who aid clients in setting up and automating these types of processes. If you would like more information, subscribe to our tech blogs. If you are interested in a demonstration or learning more about operational data movement, RemoteLink features, automation and reporting capabilities click here to speak with an SQL SME.

 

Enjoy this article? Don't forget to share.

 
Neeraj Mehta
Author: Neeraj Mehta
Senior Database Consultant at RemoteRelief: Enthusiastic technology team player with sound business acumen of retail and point of sale processes. Plan, develop, and implement IT solutions using SQL Server to deliver best experience for end-users.

Related Posts

Database Administration for the Modern Age

We cant hide the fact that we are living in the middle of the internet explosion era, data has evolved to...
Bryan Afonso Reading Time: 2 minutes

Workspace IoT Endpoint Management

Remote Relief delivers secure Workspace IoT endpoint management at scale.  Internet of Things (IoT) techn...
Bryan Afonso Reading Time: 2 minutes

Simplifying Cybersecurity Solution & Delivery

Valuable data is everywhere, it's on premises, in the cloud, on mobile devices and in transit. Unfortunat...
Bryan Afonso Reading Time: 2 minutes