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(83.2, 75%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Hi all,
Have an application which connects to a SQL database via ODBC, using SQL authentication.
When trying to carry out one particular function within the application, I get the following error:
If I use Windows authentication, it's fine.
Does anybody know what could be causing this? Surely there should be a username appearing instead of just ".
Thanks
![](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(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Could you please validate all the answers so far and provide any update?
If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Regards
Review SQL Server ErrorLog if you find more details about the failed login attempt.
I'm getting the following:
Login failed for user 'NT SERVICE\SSISScaleOutMaster140'. Reason: Failed to open the explicitly specified database 'SSISDB'. [CLIENT: <local machine>]
I have added the above log in to the SQL instance but has made no difference.
Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only. [CLIENT: <IP add of server>]
I have checked in the server settings that authentication is enabled for both Windows and SQL.
I have checked in the server settings that authentication is enabled for both Windows and SQL
It seems the SQL Server service has not been restarted since the configuration change.
I have tried this and rebooted the server but sadly has not made any difference.
Then I think you should double-check that you are looking at the right server. Also, check the top of the errorlog. The authentication mode is written to one of the first ten lines when SQL Server starts.
Hi @Motty ，
After changing Server authentication to SQL Server and Windows Authentication mode, open server at object explorer ->expand security ->expand login ->right click on your login ->properties ->type new password ->confirm password and then disconnect SQL Server and restart your system
Troubleshooting the error:
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2016/cc645917(v=sql.130)?redirectedfrom=MSDN
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.