vs how local programs connect to the server's database

Source: Internet
Author: User

When the data of our local database is used as a test, we need the data on the server, but it is very troublesome to open the database of the remote server to view the data every time, then how do we let the local database connect to the database on the server. The premise is that your local database version must be consistent with the version of the database on the server ha, my is SQL05 ha, do demonstration;

1. First open the database, log in using Windows identity

2. Run the Database Manager

Note that your port is 1433, then go to the Control Panel to find your firewall, the port is ready to put it, and then in your local database to enter the address of your server can access to the server database data Oh.

Note: Some pictures are larger, please right click to view the picture, I do not know what happened, my blog picture is too big to see how to set, know friends please leave a message, thank you ha ~

vs how local programs connect to the server's database

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.