Debugging error "cannot communicate with sqlserver or start t_ SQL debugging"

Source: Internet
Author: User

On the weekend, I added a course, engaged in "remote debugging and using vssqlserver Stored Procedures", and changed the Administrator account password of the local machine to the same password as that of the remote server, in the "control panel", set "Manage My network password ",

By default, the user name and password used to remotely connect to the remote server are set. In addition, the system permission is granted to the floating cloud client user on the remote server, the user is added to the database, and the corresponding sys permission is granted. For details, see the preceding section.

During debugging today, the system prompts "cannot establish communication with sqlserver". I searched the internet and found that a connection was established to the remote database in the service resource manager of vs on weekends. You can just take it out.

This error occurs when you Cannot initialize the transact-SQL application debugging for the SQL server instance named in the error dialog box. This usually means that the server is offline.

If the application does not need to access the specified server, you can disable application debugging or multi-layer debugging for the server to debug without using the server.

Disable application debugging on the server
  • In server resource manager, right-click the connection enabled for application debugging and clear the application debugging settings.

    If there are more than one connection to the same server, only one connection is marked for application debugging, but the setting applies to all connections established between the program and the server. If there are many connections, it may be easier to select a connection, open "application debugging" on the connection, and then close it.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.