dbForge SQL Complete can not debug in SSMS 18.8

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
yangjiayi
Posts: 1
Joined: Mon 15 Feb 2021 07:42

dbForge SQL Complete can not debug in SSMS 18.8

Post by yangjiayi » Mon 15 Feb 2021 07:51

I'm using SQL Server 2019 and Azure SQL MI.
I want to use Debug, but it doesn't work.
I checked the manual below, but it still doesn't work.
https://docs.devart.com/sqlcomplete/cod ... ugger.html

Is there anything missing?
Unable to attach the Transact-SQL debugger. Make sure you have met the following requirements:

- Both server-side and client-side components for Transact-SQL debugger are installed.
- Debugging firewall exceptions on the client and server sides are enabled.
- Your login is a member of the sysadmin fixed server role.
- Your database is not in the single-user mode.

To learn more, please refer the following page:
https://docs.microsoft.com/en-us/sql/re ... l-debugger
What should I do to use Debug?

alexa

Re: dbForge SQL Complete can not debug in SSMS 18.8

Post by alexa » Tue 16 Feb 2021 10:57

You have to check that the Transact-SQL Debugger is configured correctly http://technet.microsoft.com/en-us/library/cc646024.aspx

Also, please check that:
- The Database Engine SQL document is connected by using either a Windows Authentication or SQL Server Authentication login that is a member of the sysadmin fixed server role
- The Database Engine SQL document is connected to an instance of the Database Engine from SQL Server 2005 Service Pack 2 (SP2) or later. Please note that you can not run the debugger when SQL document is connected to an instance that is in single-user mode.

Please also see the following article http://msdn.microsoft.com/en-us/library/w1bhybwz%28v=VS.90%29.aspx

Please note that these are the requirements of the debugger of SQL Server, but not dbForge SQL Complete. So, you would need to refer to respective SQL Server forums on this.

jcastillo666
Posts: 3
Joined: Mon 07 Feb 2022 01:32

Re: dbForge SQL Complete can not debug in SSMS 18.8

Post by jcastillo666 » Mon 07 Feb 2022 01:50

I have the same problem using dbForge Studio. Has anyone solved this problem?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: dbForge SQL Complete can not debug in SSMS 18.8

Post by dzhanhira » Mon 07 Feb 2022 17:26

jcastillo666 wrote: Mon 07 Feb 2022 01:50 I have the same problem using dbForge Studio. Has anyone solved this problem?
Could you please provide more information regarding your case? You can submit a ticket via our contact form: https://www.devart.com/company/contactform.html

Kounavi
Posts: 2
Joined: Sun 12 Jun 2022 13:10

Re: dbForge SQL Complete can not debug in SSMS 18.8

Post by Kounavi » Sun 12 Jun 2022 13:20

Hello.
I have tried all the above steps including:
  • Checking that databse is not in single user mode => SELECT user_access_desc FROM sys.databases WHERE name = '<DB_NAME>');
  • Being part of the sysadmin role => SELECT IS_SRVROLEMEMBER('sysadmin'); and
    SELECT r.name as Role, m.name as Principal
    FROM master.sys.server_role_members rm
    INNER JOIN master.sys.server_principals r on r.principal_id = rm.role_principal_id and r.type = 'R'
    INNER JOIN master.sys.server_principals m on m.principal_id = rm.member_principal_id;
  • Having the debugger installed => I think that is obvious
Can the people from Devart instruct us or post a video with the detailed steps in case we are doing something wrong?

Kounavi
Posts: 2
Joined: Sun 12 Jun 2022 13:10

Re: dbForge SQL Complete can not debug in SSMS 18.8

Post by Kounavi » Sun 12 Jun 2022 19:13

Well, I am not certain if that is the reason why my debugging worked again but I installed the SSDT w/ VS 2017 installer along w/ the latest v17.x of SSMS and that did the trick. I don't know if that worked due to the fact I am using an SQL Server 2017 Express Edition but had VS 2019 and VS 2022 installed.

So my suggestion is to try and install the relevant version of SSDT tools for your SQL Server edition either w/ the VS installer or by downloading them here for older releases of SQL Server.

MS keeps all SSMS versions here in case you need older version of SSMS too as you can install them side by side w/ other versions of SSMS.

Be aware of the Considerations & Limitations section for those upgrading older versions of SSDT w/ the exception of 2019 and 2022 which do not have standalone installers but are rather integral to their respective VS version.

Post Reply