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.