This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(166.4, 9%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Microsoft ODBC Driver for SQL Server Version 17.10.000 returns with error "Test failed"
Anyone can assist me with this issue or any ideas, currently it is installed on Windows 11 VM.
Core component of SQL Server for storing, processing, and securing data
So what are you doing when you get this error message? Any code snippet?
This is on a standalone VM with no access to the internet.
I should say I am working with SQL Express.
No code or snippets at all is preconfigured in the installation, after I install the software I have to run a Setup Assistant and this is when I get the error.
No code or snippets at all is preconfigured in the installation, after I install the software I have to run a Setup Assistant and this is when I get the error.
Then you will need to talk with the person or vendor responsible for that Setup Assistant and ask that person to troubleshoot in what situation that installation package might say "Test failed".
Please try this troubleshooting guide. Set encrypt option to yes (Encrypt=Yes) if your are connecting to Azure SQL instead of SQL Server. Try turning on/off the "Trust server certificate" option.
If you are trying to connect to named instance of SQL Server make sure you connect using computername\instancename and enable SQL Server Browser Service.
Make sure you enable TCP for the SQL Server instance.
![](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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
I'm following up to check whether your issue has been resolved. If you still have any questions or need further assistance, please don't hesitate to reach out we're happy to continue supporting you.
We truly appreciate your participation and thank you for being an active member of the community.
Best regards,
Lakshmi.
I'm following up to check whether your issue has been resolved. If you still have any questions or need further assistance, please don't hesitate to reach out we're happy to continue supporting you.
We truly appreciate your participation and thank you for being an active member of the community.
Best regards,
Lakshmi.