ODBC Error 6

Motty 11 Reputation points
2022-02-28T14:35:48.06+00:00

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:

178561-image.png

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,896 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 41,411 Reputation points
    2022-02-28T14:55:02.797+00:00

    Review SQL Server ErrorLog if you find more details about the failed login attempt.


  2. YufeiShao-msft 7,061 Reputation points
    2022-03-01T07:45:56.273+00:00

    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.

    0 comments No comments