开发者

Login Failure Error while trying to Debug T-SQL

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'. 开发者_Go百科 Logon failure: unknown user name or password.

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


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜