Resolving Error 40607 – Windows logins are not supported in this version of SQL Server

This is based on my experience and resolution of the issue Windows logins are not supported in this version of SQL Server [Error 40607].

The issue was occurring while running the application which was associated with the database on another server. The problem was in the connection string. The developer had developed the application with Integrated Windows Security which did not work for this kind of application I believe where the server is not the same (localhost).

The Integrated Security should be set to false or should be removed altogether to overcome this issue. 

The User Name and Password information may be added:

<add name="DefaultConnection" connectionString="Data Source=DatabaseServerName;Initial Catalog=DatabaseName;MultipleActiveResultSets=True;User ID=DatabaseUserName;Password=DatabasePassword" providerName="System.Data.SqlClient" />

Let me know if this one was helpful.

About the Author

aditya bajaj
Music and Blogging get my love.

Be the first to comment on "Resolving Error 40607 – Windows logins are not supported in this version of SQL Server"

Leave a comment

Your email address will not be published.


*