Can I debug a Stored Procedure in SQL Server Express Edition with Advanced Services?

Question

Trying to debug a stored procedure on a local SQL Server Express instance. I am running SSMS As Administrator. My login is in the sysadmin server role. My connection user is in the sysadmin server role. I get the message "Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance 'localhost\sqlexpress'."

Answer 1

Yes - I switched to using a Windows Authentication connection and it works now. So the answer is Yes, debugging works with SQL Express.