Microsoft describes process of enabling or disabling a Server Network Protocol for MSSQL server as follows: Using SQL Server Configuration Manager To enable a server network protocol In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration. In the console pane, click Protocols for <instance name>. In the details pane, right-click the protocol you… Read More »
Today’s task is to backup database in one MSSQL server and restore database on another server. There is no direct connection between this setup, so backup can be transferred only via ftp. First, create a blank target database. Then, in “SQL Server Management Studio” restore wizard, look for the option to overwrite target database. It… Read More »
If you need to open incoming connection in firewall to SQL server or for other service then : To open a port in the Windows firewall for TCP access On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules,… Read More »