- 1
Log in to SQL Server (Windows authentication), right-click after login, and select "Properties".
- 2
Select Security on the left, and select SQL Server and Windows authentication mode on the right to enable hybrid login mode.
- 3
Select "Connect", check "Allow remote connection to this server", we recommend "Maximum concurrent connections" as the actual situation, and then click "OK".
- 4
Expand Security, login name, SA, and right-select properties.
- 5
On the left, select General, select SQL Server authentication on the right, and set the password.
Select "Status", select "Enable" and click "OK".
Right-click the database and select facets.
In the "Facets" list box, select "Server Configuration," "Remoteaccessenabled" and "remotodacenabled" set to "True" and click "OK". Now that SSMs is set up, exit and log in with SA, success means that the SA account is enabled.
Start by configuring SQL Server Configuration Manager (SSCM), check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server browser are running.
Open the left SQL Server network configuration, open the protocol for your own DB instance name, and view the TCP/IP default on the right is disabled and modify it to Enabled.
Double-click to open TCP/IP to view the "all Listen" and "enabled" items in the Protocol tab under TCP/IP properties are set to Yes.
Select the IP addersses tab, IP1, IP2, Ipall set the TCP port to "1433", the TCP dynamic port is a null value, and is enabled as "Yes".
Also modify TCP/IP of the client protocol to Enabled.
Double-click to open TCP/IP on the right, open TCP/IP properties, set the default port to "1433", and enable "yes". When the configuration is complete, restart SQL Server 2008.
In the final step, you will need to map the SQL Server 1433 TCP port and the 1434 UDP port on the firewall.
END