Skip to content

Latest commit

 

History

History
67 lines (48 loc) · 3.56 KB

File metadata and controls

67 lines (48 loc) · 3.56 KB
title Select Source Dialog Box | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology security
ms.topic conceptual
f1_keywords
sql12.swb.dmf.selectsource.f1
ms.assetid d664c2e5-dd0c-4da8-b27d-aa4ee4fc0ffd
author MikeRayMSFT
ms.author mikeray
manager craigg

Select Source Dialog Box

Use this dialog box to select the source of the policies to be run. To select one or more XML files that contain policies, select Files. To run the policies that are found on the instance of [!INCLUDEssNoVersion], select Server.

You can open this dialog box in several ways.

To open this dialog box

  • In Registered Servers, right-click Local Server Groups or any server under Local Server Groups, or any server under Central Management Servers, and then select Evaluate Policies. In the Policy Selection page of the Evaluate Policies dialog box, click the Browse (...) button.

  • In Object Explorer, expand Management, expand Policy Management, right-click Policies, and select Import Policy. In the Import dialog box, click the Browse (...) button.

  • In Object Explorer, right-click a server, database, or database object, select Policies, and then select Evaluate. In the Policy Selection page of the Evaluate Policies dialog box, click the Browse (...) button.

Options

Files
Select one or more XML files that contain policies.

Server
Enables you to select a server that contains the policies that you want to run.

Server type
Only [!INCLUDEssDE] servers contain policies. This box is read-only.

Server name
Select the server instance to connect to. By default, the server instance last connected to is displayed.

Authentication
Two authentication modes are available when you connect to an instance of the [!INCLUDEssDE].

Windows Authentication Mode (Windows Authentication)
Windows Authentication mode allows for a user to connect through a Windows user account.

SQL Server Authentication
When a user connects with a specified login name and password from a nontrusted connection, [!INCLUDEssNoVersion] performs the authentication itself by checking whether a [!INCLUDEssNoVersion] login account has been set up and whether the specified password matches the one previously recorded. If [!INCLUDEssNoVersion] does not have a login account set, authentication fails, and the user receives an error message.

Important

When possible, use Windows Authentication.

User name
Enter the user name to connect with. This option is available only if you have selected to connect by using Windows Authentication.

Login
Enter the login to connect with. This option is available only if you have selected to connect by using [!INCLUDEssNoVersion] Authentication.

Password
Enter the password for the login. This option is editable only if you have selected to connect by using [!INCLUDEssNoVersion] Authentication.

See Also

Policy Management Node (Object Explorer)
Administer Servers by Using Policy-Based Management