Which kind of connection authentication requires the user ID and password for login while connecting the database through the client application?

Last Updated on September 26, 2021 by Admin

For SQL Server 2005 and 2008, user can connect to the database engine of a specified server through the SQL Server Management Studio tool. Which kind of connection authentication requires the user ID and password for login while connecting the database through the client application?