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