Share via

Unable to work on SSAS, its showing error

Sunil Sathyanarayana 0 Reputation points
2024-08-28T11:09:59.3033333+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,690 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,278 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeyQiaoMSFT-0444 2,790 Reputation points
    2024-08-29T10:10:12.5+00:00

    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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.