ODBC Error 6

Motty 11 Reputation points

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 ".


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

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

  2. YufeiShao-msft 7,061 Reputation points

    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:


    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