question

16517982 avatar image
0 Votes"
16517982 asked 16517982 commented

SSAS Tutorial- Unable to connect to local server

Hey guys,

I've working on Adventure Works Internet Sales tutorial (1500)(https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-2-get-data?view=asallproducts-allversions), and when I do "Create a connection" part, I have an issue.

It shows: unable to connect to my local SQL server, just as the following picture says:
85660-unable-to-connect.png



Can anyone tell me what do I need to do please? Many thanks!

Kind regards,
Zihan Luo

sql-server-analysis-services
unable-to-connect.png (101.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered 16517982 commented

Is SSAS = "SQL Server Analysis Services" installed in Tabular Mode on your local machine?
Is the service running and can you connect to using SSMS?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi there, thank you for asking my question. Yes, the service running fine and I can connect to using SSMS. Cheers, Zihan

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered 16517982 commented

Hi,

From only the description, based on my research , it could be that your Microsoft SQL server has been configured, that both the 'SQL Server Network Configuration' and 'SQL Native Client Configuration' property 'Force Encryption' is set to 'Yes'. The Controller application server does not trust the certificate that the Microsoft SQL server is using for encryption.


You coud try resolving this issue by installing the relevant TLS (or SSL) certificate (used by the SQL server) on the Controller server. Follow the steps that recorded in this article : Troubleshooting SQL Server Certificate issue.

Regards,
Lukas


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Zihan,
Have you tried above approach? Any success?

0 Votes 0 ·

Hi Lukas,

Thank you for your answer. Yes, I've tried above approach. While, it's still not working. Can I ask that is it because I didn't buy a Windows 365 member? Many thanks.

0 Votes 0 ·

Hi,

I would not assume so. But may I know how the Microsoft 365 is involved in the SSAS project? Or why you think this is involved?

0 Votes 0 ·
Show more comments