Asked by:
After ugrade windows 10 pro from ver.1709 to 1803, our erp system cannot connect SQL Server

Question
-
Dear All
After windows 10 pro (ver.1803) install, our erp system cannot connect SQL Server.
error message :
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
But Other PC (winxp, win7, win8 and win 10(not 1803) ) is OK. Only window 10 (1803) is still not work.
Thomas
Friday, May 18, 2018 6:01 AM
All replies
-
Already talked about here:
https://social.msdn.microsoft.com/Forums/en-US/80d86b3b-28ff-4abe-945f-a1efccb5cf8e/rs41803windows-10-1803-wont-run-odbc-sql-connected-application-from-network?forum=windowsgeneraldevelopmentissues
- Proposed as answer by Tony_Tao Thursday, May 24, 2018 7:55 AM
Saturday, May 19, 2018 9:54 AM -
Hi,
This is a hot issue, please waiting for the subsequent update.
Thank you for understanding.
Best Regards,
Tao
Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
- Proposed as answer by Tony_Tao Thursday, May 24, 2018 7:55 AM
Monday, May 21, 2018 8:02 AM -
There's news about that?Tuesday, May 29, 2018 10:14 AM
-
On our side, we definitely solved the problem.
1) Disabled SMB V1 and enabled SMB V2/V3 on each computer/server involved into network share and SQL connections issues. Instructions here. Don't forget to reboot every machine after changes.
2) Then we still encountered random SQL connections results. We solved that by modifying the SQL connection string : replacing the server name by its fixed IP address. No more SQL connections issues.
Hope this helps.
Denis
From here:
https://social.msdn.microsoft.com/Forums/en-US/80d86b3b-28ff-4abe-945f-a1efccb5cf8e/rs41803windows-10-1803-wont-run-odbc-sql-connected-application-from-network?forum=windowsgeneraldevelopmentissues&prof=required- Edited by Leo_Visser Tuesday, May 29, 2018 10:36 AM
Tuesday, May 29, 2018 10:35 AM -
More than 2 weeks later... still no solution from MS!?!?!?Wednesday, June 6, 2018 9:42 AM
-
Microsoft KB4284848 released yesterday.
- Addresses an issue where some users may receive an error when accessing files or running programs from a shared folder using the SMBv1 protocol. The error is "An invalid argument was supplied".
https://support.microsoft.com/de-lu/help/4284848/windows-10-update-kb4284848
Hope this helps.
Mario
- Edited by Mario.90 Wednesday, June 27, 2018 8:16 AM
Wednesday, June 27, 2018 8:12 AM