Hi,
Am trying to debug a stored proc in SQL Server 2005, which is located at a remote location, from within my VS 2008 Team System (which is located in my local machine). The SQL Server and my machine are in 2 different domains. I tried to run visual studio using the Runas command for the User with which I am connecting to the remote sql server. But unable to open Visual Studio itself as I am getting an error saying my credentials are not correct.
If I am running VS directly (without using runas tool), I am able to connect to the remote sql server, but when I right click on the stored proc (from within VS) and select "step through code", it is returning an error saying - "cancelled by user". I guess here my VS is sending my Windows authenticated user details to the remote sql server, when I try to debug. Also my sql sever user has an sysadmin role.
Pls let me know as to how I can debug the remote stored proc from within my Visual Studio?
Thanx, Jai.