Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Are Named Instances and Dynamic Port Allocation supported when using Microsoft SQL Server?

April 26, 2017INSTANCES Microsoft named SQL Server supported

0

Posted

Are Named Instances and Dynamic Port Allocation supported when using Microsoft SQL Server?

1 Answer

0

Posted

Answer – Yes, however, the client accessing the Microsoft SQL Server must be using MDAC (Microsoft Data Access Components) 2.6 with Service Pack 2 or greater. To enter a Named Instance, use the following syntax: Server Name\Instance Name in the Server field. In this case, a Dynamic Port is used, so the Port field is disabled. • Question – After installing HP Report Generation Plug-in, the Report Generation and External Database Configuration options do not appear in the Navigation tree drop-down list. How do I get them to be displayedAnswer – This situation is due to a refresh issue. Closing and then reopening the browser resolves this issue.