To create a remote server, you first need to change the operating system and firewall settings so that it is possible to use port requests that will be involved in the work of the remote server.
Instructions
Step 1
Go to the Start button menu and select Run. To create a remote server, you need to configure remote connections so that they are allowed and recorded in the report server database. Enter the following on the command line: Microsoft SQL Server 2008 R2.
Step 2
In the window that appears, open the "Configuration Tools" tab. In it, go to the "SQL Server Configuration Manager" section. Then find the node "SQL Server Network Configuration". Expand it by double-clicking the left mouse button.
Step 3
Select "Protocols" to make a remote server. In it, enable the TCP / IP protocol. Restart the SQL Server services for the configured settings to take effect. Go to the "Start" button menu. Now you need to enable remote administration in the firewall of your system.
Step 4
Select Run. Enter the following on the command line: netsh.exe firewall set service type = REMOTEADMIN mode = Enable scope = ALL and press Enter. Go to the Start button menu again.
Step 5
Select "Control Panel". This time, you need to configure DCOM permission for remote access to WMI utilities. Double click on the "Administration" item. In the window that opens, go to the "Component Services" tab.
Step 6
Find the "Computers" node, expand it, select "My Computer". In the "Actions" item, find the "Properties" tab. To configure a remote server, select COM Security, and then click the Edit Restrictions button in the Launch and Activation Permissions section.
Step 7
Enter your username and click OK. Expand User or Group Permissions. Check the boxes next to Remote Activation and Remote Access. Click the OK button. Then change the WMI server settings. Return to the "Computer Management" item in the "Administrative Tools" section.
Step 8
Open the Security tab. Expand the folders located there, then highlight the Admin folder and click the Security button again. Activate the items: "Enable account", "Enable remotely", "Read security". Click the OK button.
