What should you do?

You administer a single server that contains a Microsoft SQL Server 2016 default instance.

You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions.

You need to ensure that the application login is unable to access other production databases.

What should you do?
A . Use the SQL Server default instance and configure an affinity mask.
B . Install a new named SQL Server instance on the server.
C . Use the SQL Server default instance and enable Contained Databases.
D . Install a new default SQL Server instance on the server.

View Answer

Answer: B

Explanation:

SQL Server supports multiple instances of SQL Server on a single server or processor, but only one instance can be the default instance. All others must be named instances. A computer can run multiple instances of SQL Server concurrently, and each instance runs independently of other instances.

References: https://msdn.microsoft.com/en-us/library/ms143531(v=SQL.105).aspx