Share via

Unable to connect to localhost in Visual Studio 2019 (tabular model designer)

Amey Pathare 0 Reputation points
2024-02-17T16:48:59.9966667+00:00

I want to create Tabular Project in Visual Studio 2019. After opening Visual Studio 2019 i click on "Create New Project". Then i had clicked on "Analysis Services Tabular Project". Then configure new project and when i was about to click on "OK" in tabular designer it throws an error "An error occurred while connecting to the server." [ I had installed SSAS extension in Visual Studio and in my system services all the SQL Services are Running ]. Please Help iam attaching the images. Screenshot 2024-02-17 215406

IMG_20240217_220327673~2

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,249 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dominion Chukwuma 5 Reputation points
    2024-02-17T16:59:04.23+00:00

    It's in C:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Log or similar. You'll have to path down into it, as that folder is ACL'd for the service only by default and you'll have to grant yourself access.