Share via

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

Daniel Besong 20 Reputation points
2024-06-04T16:26:53.62+00:00

TITLE: Connect to Server

Cannot connect to FTX1PRDSCSQL02.

ADDITIONAL INFORMATION:

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

BUTTONS:

OK

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,361 questions
Accepted answer
  1. Olaf Helper 43,246 Reputation points
    2024-06-05T19:13:17.3533333+00:00

    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

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,246 Reputation points
    2024-06-04T17:42:46.2233333+00:00

    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
  2. MikeyQiaoMSFT-0444 1,925 Reputation points
    2024-06-05T03:18:21.8133333+00:00

    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