Mohamed Jmal
Mohamed Jmal

Reputation: 19

SSAS CUBE connection from Visual Studio

I am trying to connect to my local database Comms from Visual Studio on an analysis services project for creating a cube.

When I make connection on data source and test the connection I get this error :

Test connection failed because of an error in initializing provider.

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.

enter image description here

My instance is configured to accept remote connections with Windows and SQL Server authentication modes:

enter image description here

enter image description here

In the SQL Server Configuration Manager, I don't see anything in the SQL Server Native Client:

enter image description here

Where is the problem and how I can solve it ?

I want to connect with Analysis Services.

Upvotes: 0

Views: 561

Answers (0)

Related Questions