Share via

Creating SQL Server Logins with the SQL Server Workflow Template Instantiation Wizard

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

If you are using a template created by a different team or at a different location, it is likely that you must add SQL Server logins for individuals who will be using the new application. Therefore, the wizard makes it possible for you to create SQL Server logins, assign these logins as database users, and designate roles for them.

To create SQL Server logins using the Workflow Template Instantiation wizard

  1. Open the Workflow Manager for SQL Server, select a server, and click Refresh.
  2. On the Templates tab, click Instantiate Template.
  3. Select a template, and proceed through the wizard.
  4. On the Identify Roles page, click New SQL login.
  5. In the Name field, enter the Windows account (in the form DOMAIN\User) to grant access to SQL Server. Optionally, select a server from the List names from Domain field, and select the Show all users check box. Double-click under the list of Available names to populate the User name dialog box.
  6. When you have the user name entered, click OK.
  7. Now, you can add SQL logins to the Database users list using the Add button.
  8. To designate a role for the login, select a SQL Server login from the list of database users, and select roles under Roles for selected user.
  9. Proceed through the wizard, and click Finish.

The wizard then creates your SQL Server user accounts.

See Also

Creating SQL Server Logins | Creating SQL Server Logins with Enterprise Manager | Creating User and Group Accounts