We can create a user without login since SQL Server 2005 version. This feature was introduced instead of Application Role. You may want to read my article “What is Application Role in SQL Server” Usually login and password information is written in the connection string and all users use the same username and password. When … Continue reading How To Create SQL User Without Login