SQL Server Management Studio

SQL Server – Integration Services – Access is denied

Varinder Sandhu SQL, SQL-Server 2012, SQL-SSIS, Varinder Sandhu

If you are facing the access denied error while connecting to Integration Services as shown below : Error detail: Connecting to the Integration Services service on the computer “ComputerName” failed with the following error: “Access is denied.” (shown in given image) Connect the SQL Server Management Studio with “Run as administrator” option. After that you will able to connect SQL Server Integration Services Service.

Schedule Automatic Backup in SQL Server 2012 – Part1

Varinder Sandhu SQL, SQL-Advanced, SQL-Backup & Restore, SQL-Server 2012, Varinder Sandhu

You know it is very important to back up your SQL server database backup on the regular basis. So in this post, we will see how to schedule automatic backup in SQL server 2012. We will go step by step to schedule so that we all can understand each and every step clearly. Before scheduling automatic backup we have make sure the following two points: User should have the SYSADMIN privileges to schedule automatic backup. SQL Server Agent service should

SQL Server – Management Studio – Add an External Tool to the Tools Menu

Varinder Sandhu SQL, SQL-Advanced, SQL-General, SQL-Tips and Tricks, Varinder Sandhu

We can launch any Microsoft Windows or Microsoft .NET Framework application from SQL Server Management Studio. External applications can be added to, and run from, the Tools menu. To add an external tool to the Tools menu On the Tools menu, click External Tools. In the Title text box, type the name you want to appear in the Menu contents list. In the Command text box, type the program name. Include the path to the executable file if necessary. In the Arguments text