SQL Server authentication vs. Trusted connection

  • I maintain an application written years ago, where the database is on a Windows 2012 R2 Server and the database is SQL Server 2012. The people who configured this application made it so that it used SQL Server Authentication. I've always taken it to be the case that SQL Authentication was the only way of accessing the database. I'm in a friendly dispute with a fellow developer, who believes that a SQL Server configured to only accept SQL Authentication can accept a user connecting to it via a .NET application, if the application uses trusted connections.

    I didn't believe it, but thought I would ask an AI chatbot about it. I was surprised that the bot said it was possible to programmatically connect to a SQL Server database using trusted connections, even though the database is only configured to accept SQL Authentications.

    So, I thought I would ask here, because I know that GenAI can hallucinate. So, is it possible to programmatically connect to a SQL Server 2012 database using trusted connections, when that database is configured to only use SQL Authentication?

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing post 1 (of 1 total)

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