To allow MSSQL server to be accessed from a network, you need to perform the following steps:
Enable TCP/IP protocol on your MSSQL server:
Open SQL Server Configuration Manager
Expand SQL Server Network Configuration
Select "Protocols for MSSQLSERVER"
Right-click on "TCP/IP" and select "Enable"
Restart the MSSQL service for changes to take effect
Configure the Windows Firewall to allow incoming traffic on MSSQL port:
Open Windows Firewall with Advanced Security
Click on "Inbound Rules"
Click on "New Rule"
Select "Port" and click "Next"
Select "TCP" and enter the MSSQL port number (default is 1433)
Select "Allow the connection" and click "Next"
Select the appropriate network profile and click "Next"
Enter a name for the new rule and click "Finish"
Enable SQL Server Authentication:
Open SQL Server Management Studio
Right-click on the server instance and select "Properties"
Select "Security"
Under "Server Authentication", select "SQL Server and Windows Authentication mode"
Click "OK"
Create a login account for remote connections:
In SQL Server Management Studio, expand "Security"
Right-click on "Logins" and select "New Login"
Enter the login name and password for the new account
Under "Server Roles", select "sysadmin"
Click "OK"
After completing these steps, your MSSQL server should be accessible from other computers on the network using SQL Server Management Studio or other MSSQL client tools.
#MSSQL
#howto
#microsoft
#follow365
