Not listening on correct interface

Question

I have Windows 2012 R2 with SQL 2012 Analysis with all the patches installed.

I can open Analysis via SQL Server Management Studio locally. 

I can "telnet 127.0.0.1 2383"

Analysis Service  is only listening on loopback so it's not working with remote connections. SQL Database's 1433 works fine. (i have only one network card with one IP address)

netstat -ao | find ":23"

TCP   127.0.0.1:2383   sqlserver:0    listening    512

Any idea?

Answer 1

Do you have a firewall running, which may block the access? See Configure the Windows Firewall to Allow Analysis Services Access

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

No Firewall.

Answer 3

Try connecting from the local machine using SSMS, then right click on the server and view it's properties. Make sure that the Network\ListenOnlyOnLocalConnections property is not set to True (if it is you will need to change this and restart the service)

---

http://darren.gosbell.com - please mark correct answers

Answer 4

I've reinstalled it all together and it's working now.