The default on Sqlserver is for sql authentication to be disabled. If you want to use it, you must enable it on the Sqlserver and and sql user accounts.
Requirements for SQL connection testing
![](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, 8%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKO%3C/text%3E%3C/svg%3E)
k ogawa
0
Reputation points
『In the SQL connection test, Windows authentication can connect, but SQL Server authentication cannot connect』
SQL Server | Other
1 answer
Sort by: Most helpful
-
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 81,521 Reputation points Volunteer Moderator2025-09-29T15:12:57.9133333+00:00 -
![](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(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator2025-10-23T11:57:55.7833333+00:00 Hi @k ogawa ,
Thank you for reaching out to the Microsoft Q & A Forum.
Hi @Bruce (SqlWork.com) , Thank you for your prompt response.Hi @k ogawa , Could you please try the proposed solution shared by @Bruce (SqlWork.com)? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
-
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
2025-10-28T12:36:47.83+00:00 Hi @k ogawa ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Sign in to comment -