Login failed for user 'intraconnections'. (Microsoft SQL Server, Error: 18456)

Daniel Besong 20 Reputation points

TITLE: Connect to Server

Cannot connect to FTX1PRDSCSQL02.


Login failed for user 'intraconnections'. (Microsoft SQL Server, Error: 18456)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error



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

Accepted answer
  1. Olaf Helper 42,386 Reputation points

    SQL authentication failed. Server is configured for Integrated authentication only

    As the message says.

    The SQL Server are configured different, one in runs in "Mixed Mode" = Windows + SQL authentification

    The other runs in "Windows auth only mode"; you can not logon using any SQL login.

    You have to egualized all SQL Server settings, otherwise you will always trouble of any kind.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 42,386 Reputation points

    As the message clearly says, the SQL login "intraconnections" don't have permissions to logon to that SQL Server.

    Check the ErrorLog file for details.

    0 comments No comments

  2. MikeyQiaoMSFT-0444 1,255 Reputation points

    Hi,Daniel Besong

    As Olaf and Erland say,you need to provide the Errorlog of the attempted login failure, which contains more detailed step records.

    The specific path is as follows in the screenshot. Please choose your own instance name as the folder.User's image

    0 comments No comments