SQL Server 2005 How to open a database remote connection _mssql2005

SQL Server 2005 does not allow remote connections by default, and to enable MSSQL through remote connections, database backups require the following settings:

Steps/Methods
1. Open SQL Server Configuration Manager, log on using Windows identity

2. After you log in, right-click the "Properties" option. Select Security on the left, select SQL Server and Windows authentication mode on the right to enable mixed logon mode

3. Select "Connect", check "Allow remote connection this server", then click "OK"

4. Expand "Security", "Record Name", "New landing name", take MyLink as an example

5. Select "General" on the left, select "SQL Server Authentication" on the right, and set the password, and check the database you want to back up on the "default database" below.

6. Select "User Mapping" on the left and select the database to map to the right and tick in front

7. Select "Status" on the left and select "Grant" and "enable" in the right column, these two items are generally the default, but if the default is not the two must be changed, or not even on the! Click ' OK '

8. Select the database you want to back up, here take my_dbfen_0 as an example, right click "Properties"

9. Select "Permissions", select the database user MyLink, and grant the SELECT permission to the MyLink user. (To be normal success, this step must be set yo!) ）

10. This ssms has been set up, the first exit, and then log on with MyLink, success means that MyLink account has been enabled

11. Open SQL Server Configuration Manager. On the left, select the SQLExpress protocol under the SQL Server Network Configuration node, and the TCP/IP default on the right is "no", double-click Open the Setup Panel to change it to Yes

Here you can select the IP Address tab, set the TCP port, and the default is "1433"

If your database address is localhost, you can modify the database IP here.

12. On the left, select the client protocol under the SQL Native Client 100 configuration node to enable the TCP/IP protocol on the right.

At this point, we have completed the MSSQL database remote connection authorization. Now, we can use the "login name" and "password" just established to backup the MSSQL database on the multiple backup.