Related

Product Now Available: Managed PostgreSQL Databases Product
Postgres not able to start Question Question
how to connect to vagrant postgres server with pgamin3 Question Question

Question

SQL Server Error

Posted July 11, 2018 1.4k views
UbuntuPostgreSQL

Cannot connect to SQL Server. An error message: SQL Server Error 18456
Can anyone advise me of a solution to this. Many Thanks

Add a comment
By:
Patrick5Ble
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers
AHA July 11, 2018

Hey - Googling “Sql Server Error 18456” leads me here - https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-2017

Sounds like it is a Logon Failed error meaning your username or password is incorrect.

Reply Report
trals1r July 30, 2018

The error reason An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. can be returned in the following situation:
When the server is configured for mixed mode authentication, and an ODBC connection uses the TCP protocol, and the connection does not explicitly specify that the connection should use a trusted connection. To resolve this issue, include TRUSTED_CONNECTION = TRUE in the connection string or you can: fix sql error

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help