HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
samerunsqlanalysisinstanceservicesserverssasconfigure

Problem

TL;DR

I would like to add SQL Server 2014 Analysis Services to a specific instance of SQL Server and to configure it in such a way, that the Analysis Services (SSAS) and future Reporting Services (SSRS) will only pick up requests on the instance-specific IP, in order to allow the SQL Server Browser Service to remain in the state stopped.

Prerequisites

I have the following prerequisites regarding a single Windows Server running multiple SQL Server 2014 instances:

Basic Information

  • 2 x NICs
  • 12 x IP Addresses
  • 10 x SQL Server Server Service Instances (running)
  • 10 x SQL Server Agent Server Service Instances (running)
  • 1 x SQL Server Browser Service (not running)



NIC Configuration

The Windows Server NICs are configured as follows:

  • 1 x NIC (Backup Network)


- 10.2.0.1
  • 1 x NIC (LAN)


- 10.2.0.2 (Windows Server)
- 10.2.1.1 (SQL Server "Instance01"/ CNAME: servername-ins01)
- 10.2.1.2 (SQL Server "Instance02"/ CNAME: servername-ins02)
- 10.2.1.3 (SQL Server "Instance03"/ CNAME: servername-ins03)
- 10.2.1.4 (SQL Server "Instance04"/ CNAME: servername-ins04)
- 10.2.1.5 (SQL Server "Instance05"/ CNAME: servername-ins05)
- 10.2.1.6 (SQL Server "Instance06"/ CNAME: servername-ins06)
- 10.2.1.7 (SQL Server "Instance07"/ CNAME: servername-ins07)
- 10.2.1.8 (SQL Server "Instance08"/ CNAME: servername-ins08)
- 10.2.1.9 (SQL Server "Instance09"/ CNAME: servername-ins09)
- 10.2.1.10 (SQL Server "Instance10"/ CNAME: servername-ins10)

SQL Server Configuration Manager

The SQL Server Configuration Manager is configured as follows for each "Instance nm" of SQL Server:

  • Protocol for 'Instance01'


- Shared Memory : Enabled
- Named Pipes : Disabled
- TCP/IP : Enabled

TCP / IP Properties 'Instance01' - Protocol Tab

  • Protocol


- Enabled : Yes
- Keep Alive : 30000
- Listen All : No

With the above settings each 'Instance nm' will have to be configur

Solution

Analysis Services always listens on all IPs unless it's a clustered instance or running in a VM. So you can't disable the browser service in this configuration.

If you can live with IIS and HTTP access you can configure multiple IIS websites running instances of the Analysis Services Data Pump.

Context

StackExchange Database Administrators Q#220810, answer score: 4

Revisions (0)

No revisions yet.