I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.

võ thị tuyết ngân 20

Screenshot (273)

I got an error that I cannot connect to SQL while demoing olap. I cannot connect to SQL and it asks me to enter "user id" and "password"

Erland Sommarskog 112.8K Reputation points

2024-09-14T09:18:54.5966667+00:00

No, it does not ask you to enter user-id/password, but it is giving you the options to change the credentials you are trying to connect with. That is not going to help in this case, as the error message means that the SQL Server instance you are trying to connect to does not exist or is not running.

I have never worked with SQL Server Analysis Services, so I can't help you with the details, but there is something in your configuration you need to review.

1 answer

LucyChenMSFT-4874 5,060 Reputation points

2024-09-16T01:27:17.2133333+00:00
Hi @võ thị tuyết ngân,

Thank you for your reaching out and welcome to Microsoft Q&A!

From the error message you provided, could you please verify:

The instance is running in SQL Server Configuration Manager

SQL Server Browser is running in SQL Server Configuration Manager

Try to connect to SQL Server with SSMS

If the port number of the SQL Server Service is blocked by a firewall

In addition, we need more information to locate the cause of error accurately. Could you please post the detailed Application log in the [Window Log] to help us narrow down the issue?

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications
Please sign in to rate this answer.
võ thị tuyết ngân 20 Reputation points

2024-09-16T08:22:20.83+00:00

This is my version of the sql and visual code, please help me fix the above error

LucyChenMSFT-4874 5,060 Reputation points

2024-09-16T08:32:33.8166667+00:00

Hi @võ thị tuyết ngân,

Thank you for you kindly feedback！

Could you please try to connect to SQL Server with SSMS and show us the results?

In addition, we need more information to locate the cause of error accurately. Could you please post the detailed Application log in the [Window Log] to help us narrow down the issue?

võ thị tuyết ngân 20 Reputation points

2024-09-16T08:43:13.5533333+00:00

This is my connect to SQL Server bằng SSMS

võ thị tuyết ngân 20 Reputation points

2024-09-16T08:54:15.6066667+00:00

This is my event view

LucyChenMSFT-4874 5,060 Reputation points

2024-09-16T09:11:23.37+00:00

Hi @võ thị tuyết ngân,

Thank you for your kindly feedback!!

Please follow the steps in this official documentation and try to troubleshoot the issue.

From the information you provided, we got the error message '18456', this issue is usually related to login. You can post the detailed error logs here to help us narrow down the issue.

https://sqlblog.org/2020/07/28/troubleshooting-error-18456

võ thị tuyết ngân 20 Reputation points

2024-09-16T10:37:35.05+00:00

I still haven't solved that error.When running data source view in visual code it shows this error "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."

Erland Sommarskog 112.8K Reputation points

2024-09-16T20:27:20.2833333+00:00

You still have not shown us how have configured the connection to SQL Server in the data source. All we can do is give you advice about troubleshooting. We don't have access to your environment, so we can do the troubleshooting for you.

võ thị tuyết ngân 20 Reputation points

2024-09-17T09:15:26.5033333+00:00

This is my configured the connection to SQL Server.Help me resolve this error, please

Erland Sommarskog 112.8K Reputation points

2024-09-17T20:52:32.24+00:00

That is your connection in SSMS, which seems to be working. But this obviously not what you are using when you are working with the Data Source Wizard in the screenshot above. Please show all steps in the wizard before you get the error.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.