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,080 questions
{count} votes

Accepted answer
  1. Olaf Helper 42,386 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 No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 42,386 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 No comments

  2. MikeyQiaoMSFT-0444 1,255 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 No comments