I have a problem in SQL Server I can't add analysis service

Question

when I connect to analysis service, I get Error message as follow:

TITLE: Connect to Server

---

Cannot connect to ,.

---

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

---

No such host is known (System)

---

BUTTONS:

OK

---

Answer 1

Hi Ahmed Eltelbany,

Thank you for posting in the Microsoft Community Forums.

This error message indicates that you have encountered a problem when trying to connect to Analysis Services (usually referred to as SQL Server Analysis Services, SSAS). The error contains the following key information:

Unable to connect to server: This indicates that the client was unable to establish a connection to the specified server.

Make sure the server is running: This prompts you to check if the Analysis Services instance is running on the target server.

No such host is known: This is a system-level error, which usually means that the server name or address you provided could not be resolved by DNS, or the server is not visible on the network.

To resolve this issue, you can follow these steps:

1. Check the server name or address

Ensure that the server name or IP address you provided in the connection string is correct.

If you are using the server name, try using the IP address and vice versa.

Verify that there are no spelling errors.

2. Check the server status

Log in to the server where Analysis Services is located.

Verify that the Analysis Services service is running. You can check this in the Windows Service Manager.

If the service is not running, try starting it. 3.

3. Check network connectivity

Ensure that your client computers have access to the network where the Analysis Services server is located.

Use the ping command to test the network connection (if the server name resolves to an IP address).

Use the telnet command to test that the port is open (SSAS uses TCP port 2383 by default, but the exact port may vary by configuration).

4. Check the firewall and port settings

Verify that the firewall between the server and the client does not block ports used by SSAS.

On the server, check for any inbound or outbound rules that might prevent SSAS from communicating properly.

5. Check DNS settings

If you are using a server name instead of an IP address, make sure that the DNS server is able to resolve the name correctly.

Try using the nslookup command on the command line to resolve the server name.

6. Check the Client Configuration

Ensure that the correct version of the SSAS client library (such as ADOMD.NET) is installed on your client computer.

If you are using specific client applications (e.g., Excel, Power BI, etc.), make sure they are up to date and compatible with the version of the SSAS server.

Best regards

Neuvi