3

I'm trying to run the debugger on some T-SQL that lives inside just a new query (.sql). I've never tried running the debugger on this server. We log into this dev server with sa and I work remotely over vpn.

\When I try to debug, I get Unable to start T-SQL Debugging. Could not connect to computer 'servername'. Logon failure: unknown user name or password.

No idea how to resolve this. I can run queries but just can't debug.

PositiveGuy
  • 46,620
  • 110
  • 305
  • 471

1 Answers1

3

Debugging requires SSMS to be running as a Windows local or domain account, and the query window itself must connect to the server using Windows Auth, or a user in the sysadmin role. Since you say things like "remotely" and "vpn" I'm going to guess you're connecting to this server using a SQL Server login, not a Windows login. You might want to see this question to work around the vpn issue.

Community
  • 1
  • 1
Aaron Bertrand
  • 272,866
  • 37
  • 466
  • 490