patternsqlMinor
Configure SQL Server Analysis Services (SSAS) to run on same IP as SQL Server instance
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
NIC Configuration
The Windows Server NICs are configured as follows:
- 10.2.0.1
- 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:
- Shared Memory : Enabled
- Named Pipes : Disabled
- TCP/IP : Enabled
TCP / IP Properties 'Instance01' - Protocol Tab
- Enabled : Yes
- Keep Alive : 30000
- Listen All : No
With the above settings each 'Instance nm' will have to be configur
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.
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.