Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts

Tuesday, March 7, 2023

Allow MSSQL server to be accessed from a network | How To

 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