0

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.

Improve this question
4
  • Please do not upload images of code/data/errors when asking a question. Commented Jan 20, 2024 at 12:34
  • The latter images are for the data engine, not Analysis Services, they aren't related to the problem if you are trying to SSAS. Commented Jan 20, 2024 at 13:14
  • Perhaps the host name MED-JAML isn't resolvable via DNS? If it's running on the same computer that's running Visual Studio, what happens if you try .\MEDJMAL? Instance name resolution also requires that the SQL Browser service is enabled, running, and has been restarted since the last installation of any SQL Server instances or any changes to their Server Protocol settings. Commented Jan 20, 2024 at 23:15
  • Thanks for your helps. I have changed the provider, ant it works now, I can connect with Visual Studio Commented Jan 21, 2024 at 12:55
Related questions
873
"The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
4342
How do I UPDATE from a SELECT in SQL Server?
1370
Difference between Build Solution, Rebuild Solution, and Clean Solution in Visual Studio?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.