TCP/IP connection to host localhost via port 8080 failed. Error: "The driver received an unexpected pre-logon response. Verify the connection properties and check that the instance of SQL Server is running on the host and that this port accepts

Source: Internet
Author: User
Tags mssqlserver
1. Click Start-All Programs--Microsoft SQL Server2005--configuration tools-->sql Server config  manager-Select left SQL Serve R 2005 Network configuration-double-click the MSSQLSERVER protocol and select TCP/IP right click to enable;
2. Select SQL Server 2005 on the left and select right-MSSQLSERVER-right-click to restart; wait for SQL to restart
Note: If you enable the TCP/IP network protocol, do not restart the server SQL service will not take effect,
Special NOTE: If the machine is not used for the server, do not open the TCP/IP services, especially the local area network, vulnerable to attack, useless when it is disabled.
Related Article

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.