502 Chapter 18 Workforce Scheduling
To enable remote SQL Server 2008 connections
1. On the Enterprise Server, click Start=>All Programs=>Microsoft SQL Server
2008=>Configuration Tools=> SQL Server Configuration Manager.
2. Under SQL Server Configuration Manager (Local), expand SQL Server Network Configuration and
click Protocols for <SQL Server instance name>.
3. In the right pane, right-click Named Pipes and click Enable.
4. In the right pane, right-click TCP/IP and click Enable.
5. Under SQL Server Configuration Manager (Local), click SQL Server Services.
6. In the right pane, right-click SQL Server (<SQL Server instance name>) and click Restart.
7. In the right pane, right-click SQL Server Browser and click Properties.
8. Click the Service tab and after Start Mode, select Automatic.
9. Click Apply.
10. Click OK.
11. In the right pane, right-click SQL Server Browser and click Start.
Granting SQL Server permissions
NOTE:
• If your enterprise uses remote SQL and SQL Authentication, you can skip this step, because the
required credentials are provided during the configuration of Contact Center Management
• If you do not currently have a copy of Microsoft SQL Server Management Studio installed, you can
download a free copy from http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-
4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
To grant SQL Server 2005 permissions
1. Click Start=>All Programs=>Microsoft SQL Server 2005=>SQL Server Management Studio.
2. Connect to the desired SQL Server.
3. In the left pane, expand the Security tree and select Logins.
4. If the desired user is not listed, right-click Logins and select New Login.
5. After Login name, type the name of the new user.
Optionally, click Search to search for the user name.
6. If you have users configured in groups on your domain, you can optionally add the group to add all
users at once.
If you want to grant SQL Server permissions to a domain group, you must click Search, click Object
Types, and select the Groups check box.
7. Click User Mapping.
8. Under Users Mapped to this login, select CCMData.
9. Click OK.
10. Under Database role membership for: CCMData, select db_owner.
11. Click OK.
12. Repeat steps 5-11 for all Workforce Scheduling users.
To grant SQL Server 2008 permissions
1. Click Start=>All Programs=>Microsoft SQL Server 2008=>SQL Server Management Studio.
2. Connect to the desired SQL Server.
3. In the left pane, expand the Security tree and select Logins.
4. If the desired user is not listed, right-click Logins and select New Login.
5. After Login name, type the name of the new user.
Optionally, click Search to search for the user name.
6. If you have users configured in groups on your domain, you can optionally add the group to add all
users at once.
If you want to grant SQL Server permissions to a domain group, you must click Search, click Object
Types, and select the Groups check box.