SQL Server Error: Unable to start the Transact-SQL debugger ...could not connect to Database instatnce

Last Reply 10 months ago By dharmendr

Posted 10 months ago

I am getting the following error:

Unable to start the Transact-SQL debugger ...could not connect to Database instatnce 192.xxx.x.xxx.Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role.

 

I am debugging the stored procedure.Any help will be appreciated.

Posted 10 months ago

Hi chetan,

Step 1 : Expand the Security

Step 2 : Right click of Logins

Step 3 : Select New Login

Step 4 : Enter your windows user name (User name should be Domain\User Name)

Step 5 : Go to Server roles -> Select Public

Step 6: Go to User Mappings and select Database (Which database against you want to debug)

Step 7 : Assign role member ship as Public and DYNGRP

Step 8 : Select OK

Now try to debug it will work.


Posted 10 months ago

hi sir,i am getting like this

Windows NT user or group PC26/chetan not found