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

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

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