Problems of database configuration when locomotive is in storage SQL Server

Source: Internet
Author: User

Server directly with local, click Get Database list, pop-up error: "Database error [Dbnetlib][connectionopen (Connect ()).] SQL Server does not exist or is denied access resolved ";

Workaround:

1) Expand the SQL Server 2005/2008 Network Configuration node and expand the Protocol node to the right of the Protocol to enable TCP/IP protocol----In the TCP/IP protocol properties to the right of the Protocol--in the IPAll-- Set the TCP port to 1433.

2) Restart SQL Server, if the firewall is not limited, now OK. Server 2008 Here is, locate Configuration Manager, then "SQL Server Network Configuration", enable "TCP/IP", right-click on its properties, find "IP address", pull down the bottom, change the ipall to 1433, Or use this port directly (fill in the server address of the locomotive at this time: 127.0.0.1,60193---behind this port is your port. )
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.