Unable to do remote SQL Stored Procedure debugging from VS2010

This post describes an interesting scenario that I came across when working with on Visual Studio Project based issue. In this situation, customer was unable to debug stored procedures on a remote SQL Server using Visual Studio. The SQL Server was running on a Virtual Machine that was in a different domain than the domain…

1

Unable to edit the connection string information in Excel 2003 Forms

Last week while i was trying to edit an Excel form based application to modify the connection string information , I felt like I was at a dead end for a few hours.  I was trying to edit the connection string to point the application to a different SQL Server. The Excel form application had that…

0

An issue that occured when a SSIS Execute Process task was calling a remote batch file.

This post describes an interesting scenario that I came across when working with a SSIS package developer.  The main issue was that we were unable to run the SSIS package that contains a execute process task calling a batch file stored on a remote server machine (without being prompted by a warning window). The following warning…

2