Modify the database default port

Overview: A test database was built. In order to ensure the data consistency of each test terminal and collect the data of the test terminal in real time, a SQL Server database can be accessed by the extranet.

Implementation method: Using the Peanut Shell Intranet version (certification fee of 9 yuan)

Problem: After using the default port, it is found that the user name and password of the database are frequently violently tested, and the frequency of 20 times per second is reached.

Workaround:

1. Use the database Configuration tool to modify the default port of SQL Server to 4311

2. Restart the database

3, connected to the database place using the original server address after adding ", 4311" port number, such as the original use (192.168.1.100) is now changed to (192.168.1.100,4311)

The database connection string is changed to: "<add key=" Dbconn "value=" Data source=192.168.1.100,4311;initial catalog=testdb; User Id=userdb; password=password! "/>"

4, in the peanut shell outside the network mapping place made an external network 1011 port map to the intranet 192.168.1.100 4311 port

5, in the need to connect to the database Test terminal configuration file, the Peanut shell intranet version of the domain name in the domain after adding ", 1011"

6, further increase the password strength of all database user names

After the above configuration, I feel better.

Modify the database default port