Cannot connect to SQL Server. An error message: SQL Server Error 18456 Can anyone advise me of a solution to this. Many Thanks
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.