Describe how SQL Server 2012 supports authentication for connecting to the database server.

What will be an ideal response?


SQL Server 2012 supports two types of authentication for connecting to the database server:
Windows authentication and SQL Server authentication. The logins associated with authentication on a SQL Server instance are distinct from the security principals known as database users that are defined for each database. Each login may be mapped to one or more database user. For database objects, permissions are granted to a database user and not to the login that is used for authentication.

Computer Science & Information Technology

You might also like to view...

Taking the time to align and space objects evenly will give a document a more professional appearance.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

What are the six basic art elements?

What will be an ideal response?

Computer Science & Information Technology

Which control is both a list box and a text box control?

A. Bound image control B. Unbound image control C. Combo box D. Option group

Computer Science & Information Technology

Which option below is not one of the three main methods for cleaning up metadata?

A. Active Directory Users and Computers B. wbsadmin.exe C. Active Directory Sites and Services D. ntdsutil.exe

Computer Science & Information Technology