Remote Report Server Database

If a remote database engine instance is being used, TCP/IP network connectivity will need to be enabled.

This can be accomplished by logging on to the database server and opening the SQL Server Configuration Manager tool, as shown in the following screenshot: 

Sql Server Configuration Manager: TCP/IP

Per the screenshot, the SQL Server Network Configuration dropdown menu provides access to the protocols of the database instance (MSSQLSERVER). Once the TCP/IP protocol has been enabled (right-click | Enable), the database instance will need to be restarted. This option is available from the SQL Server Services menu, as shown in the following screenshot:

SQL Server Configuration Manager: Restart service

Finally, the port that the SQL Server instance listens on will need to be opened. This is typically port 1433 for TCP/IP connections for the default SQL Server database instance.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.224.68.28