This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hey guys,
I've working on Adventure Works Internet Sales tutorial (1500)(https://learn.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:
Can anyone tell me what do I need to do please? Many thanks！
Kind regards,
Zihan Luo
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?
Hi there, thank you for asking my question. Yes, the service running fine and I can connect to using SSMS. Cheers, Zihan
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
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
Hi Zihan,
Have you tried above approach? Any success?
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.
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?
Of course, you can. That's because I have to fill my Microsoft account user name and password to login in, I'm just guessing there might be an impact between the two.