Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance

"Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance ‘XXXX’. 
Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role."

Screen shot:
Solution:
Step 1 :Create new login.
Step 2 : Enter your windows user name

Step 3 : User name should be Domain\User Name

Step 4 : Go to Server roles

Step 5 : Select Public,Server Admin,Sys Admin
Step 6: Go to User Mappings and select Database

Step 7 : Assign role member ship as Public.
Step 8 : Select OK

Now try to debug it will be work.

Result:
Video Tutorial.

Post a Comment

0 Comments