Post reply

SQL Connectivity

  • August 19, 2025 at 4:31 am

    #4637421

    Hi everyone,

    I'm currently working on building an MCP integration for SQL Server. Most components are functioning as expected, but I'm running into a connectivity issue during authentication.

    The error message I'm seeing is:

    Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only. [CLIENT: 192.168.0.138]

    However, the SQL Server is configured for mixed mode authentication, and I’m able to connect without any issues using SSMS with both sa and other test accounts.

    Has anyone encountered this before or have insights into what might be causing this discrepancy? Any guidance would be appreciated.

    TIA

     

  • August 20, 2025 at 5:10 am

    #4637953

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • August 20, 2025 at 1:44 pm

    #4638159

    i think you may have toggled mixed mode authentication, but that setting requires a stop and start of the SQL service, as it is only loaded at that time.

    it will not apply until you stop and start the SQL service,whether enabling or disabling it. you just need to do that real quick.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply