Loading

Error: "Invalid username or password" Signing in to Microsoft SQL Server

Дата публикации: Dec 29, 2025
Описание

When you sign in to Microsoft SQL Server, the following error might occur:

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user '<username>'.
[Microsoft][ODBC Driver Manager] Invalid connection string attribute
Invalid username or password.

 

Signing in with the same credentials using SQL Server Management Studio will be successful.
 

Решение
  • Ensure that your user account has permission to access the Microsoft SQL Server database, or that it has permission to impersonate an account that does have access to the server database.
  • Check if the password being used with the account contains the following special characters: [] () , ; ? * ! @ =
Дополнительные ресурсы
Windows Active Directory (AD) accounts must have permission to sign in to Microsoft SQL Server or have impersonation permissions to sign in to the Microsoft SQL Server using different account credentials.

The following article from the Microsoft website lists that with ODBC connection strings, the password cannot contain the following special characters:  [] () , ; ? * ! @ =

https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords?view=sql-server-ver15
Номер статьи базы знаний

001474024

 
Загрузка
Salesforce Help | Article