Unable to work on SSAS, its showing error

Question

Hi All,

I have installed SQL Server 2022, Visual Studio 2022 and SSAS.

But I am getting error while trying to create the Data Source View. Here is the error:

TITLE: Microsoft SQL Server Native Client 11.0 ------------------------------ A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. Client unable to establish connection Registry information is corrupt or missing. Make sure the provider is installed and registered correctly. ------------------------------ BUTTONS: & Retry Cancel ------------------------------

I have tried checking TCP, Ports and other installations. they all seem to be fine.

Could you please help me in resolving this issue.

Thanks

Sunil

Answer 1

Hi，Sunil Sathyanarayana

Please confirm that the instance name in the connection string is correct and that the firewall is not causing any interference. You can try to reconnect SSAS following the example steps, Connect using Visual Studio

or refer to the troubleshooting methods in this link.

Regards

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.