Can't run a script in debug mode on SQL Server 2012

Posted on 2014-08-20
Last Modified: 2014-09-08
I'm running SQL Server Express 2012 on Win 8.1 with Eset firewall. When I try to run a query in debug mode, I get the message
Unable to start T-SQL Debugging. Could not connect to computer '(local)'. The debugger cannot connect to the remote computer. This may be because the remote computer does not exist or a firewall may be preventing communication to the remote computer. Please see Help for assistance.
I've tried suspending the Eset firewall but that doesn't help. Ideas?
Question by:BlearyEye
    LVL 39

    Expert Comment

    "Could not connect to computer '(local)'." - do you have a LOCAL SQL Server installation?
    LVL 23

    Expert Comment

    There are several things you need to do to get this working.  Follow the instructions here:
    LVL 1

    Author Comment

    lcohan: yes, it's local.

    nemws1: I'm running v. 2012 so the Configure part should be OK. I tried running with the firewall turned off, so the Firewall Rules shouldn't be an issue. I guess that leaves Requirements for Starting, so I need to figure out if I'm a "member of the sysadmin fixed server role".
    LVL 1

    Accepted Solution

    I found the answer: Have to connect as "localhost\..." rather than "(local)\...".
    LVL 1

    Author Closing Comment

    I found the answer on my own.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now