SQL commands teach you how to set up SQL Server Database Remote sharing on your computer

Recently, I am working on a small project. I need to allow my colleagues to access the database under my computer, so I have to set up remote access to my database. It took a long time to complete the process, share your experience here. My environment is 64

Recently, I am working on a small project. I need to allow my colleagues to access the database under my computer, so I have to set up remote access to my database. It took a long time to complete the process, share your experience here. My environment is 64

Recently, I am working on a small project. I need to allow my colleagues to access the database under my computer, so I have to set up remote access to my database. It took a long time to complete the process, share your experience here.

My environment is 64-bit, win7, and the database is SQL SERVER2008.

Let's start. I will teach you how to use it ~

First, most of the online tutorials are about modifying the local sa user account, but my sa account is a bit faulty. the following error message appears when you change the password.

I have not been able to solve this problem through some other methods, but we can also not use the sa account, so we need to re-create an account, and follow me below

1. First open SQL server 2008, that is, SQL Server Management Studio

2. Connect to the database as a windows user, right-click the database and choose Properties]

3. Click security on the selection page on the left, and select SQL Server and Windows Authentication Mode on the right]

4. Click Connect on the selection page on the left, select allow remote connection to this server on the right, and click OK]

5. Right-click the object resource manager on the left and choose security> New> logon]

6. On the left-side Navigation Pane, select General. On the right, enter a logon name, select SQL Server Authentication, enter the password, and select force password policy]

Note that the entered password must be slightly complex; otherwise, the following error message will appear.

The password strength you wrote is best like this, for example: Uiop_098Mn, dog blood, haha

7. If you only want to connect one or more databases on your local machine to other LAN machines, select [user ing] on the left and select the database name you want to share on the right, select db_owner and public. If you want to share all your databases, skip this step.

8. Select status on the left, authorize and enable from top to bottom on the right, and click OK]

9. Right-click the database and choose [aspect]

10. Select "server configuration" for aspect items, and set "RemoteAccessEnabled" to "true" for aspect property items.

So far, you can use the newly created account to log on to SQL Server.

Next, open [SQL Server Configuration Manager]

1. Keep the three items in the figure as running

2. Select MSSQLSERVER protocol under SQL Server network configuration and set TCP/IP to enabled.

3. Switch to the [IP address] Page and set the TCP port in IPAll to '123'

4. Select [Client Protocol] under [SQL Native Client configuration] And set [TCP/IP] To enabled.

OK, and some other settings have been completed.

Finally, we need to perform some operations on the firewall.

1. Open the Firewall

2. Disable all firewalls

3. Then we need to manually add the remote access list

4. Click allow to run another program]

Go to the local sqlserver.exe file (C: \ Program Files \ Microsoft SQL Server \ MSSQL10.SQLEXPRESS \ MSSQL \ Binn \ sqlservr.exe) on the page through the browser in the 5th region. Select the path based on your local conditions. Very easy to find

Add sqlserver.exe to the firewall's allow list.

Then I ran to my colleague's computer. The Server name entered the IP address of my computer, select [SQL Server Authentication], and enter the new user name and password, click Connect.

This is really a hands-on tutorial. If you still haven't succeeded, please tell me ~

This article is from the "typical lions and male" blog. Be sure to keep this source