Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient permissions to debug"



Hi Paul,

>Can I check - does "application account" mean the windows/domain
>account that I'm logged on as?

yes, you are right.

>This is the account I log onto Windows with, so it will be the account
>that VS2005 is running under.
>I am using this account (with Windows Authentication) for my Data
>Connection to the remote SQL Server 2005.
>This account has been added as a login to SQL Server, and has been
>granted the sysadmin role.
>(the account is also in the administrators group on both client & server)
>...
>The server is a virtual machine (VMware) - does that make any difference?

The server in a virtual machine shouldn't matter, I remote debug with a
virtual machine's SQL server 2005 in our local domain, it works as
expected. I think maybe there has some problem on the account setting in
your virtual machine, does it also join the single domain which your
working machine resides?

I suggest you may test with the *sa* account of that virtual machine's SQL
server 2005, you can use that sa account in the corresponding data
connection.


Thanks !

Best regards,

Gary Chang
Microsoft Community Support
--------------------
Get Secure! ¡§C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.

.


Loading