Prepare the PeopleSync Frontend database

Preparations for the PeopleSync Frontend

The PeopleSync Frontend needs a SQL Server login to connect to the PeopleSync database. The following steps will guide you through the process of creating the login and granting the necessary permissions.

Please write down the login and password you created in the following steps, as those will be needed during further setup.

Configure SQL Server for mixed authentication mode:

1. Open SQL Server Management Studio.

2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

3. On the Security page, under Server authentication, select SQL Server and Windows authentication mode, and then click OK.

4. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

5. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

Create a SQL Server login:

1. Open SQL Server Management Studio.

2. Open a new query window.

3. Type in the following command, set a password and hit Enter:
   CREATE LOGIN psweb
   WITH PASSWORD = '<enterStrongPasswordHere>',
   CHECK_POLICY = OFF;
   GO

Grant permission to access the PeopleSync Database:

1. Open SQL Server Management Studio.

2. In Object Explorer, expand the Databases folder.

3. Expand the PeopleSync database.

4. Right-click the Security folder, point to New, and select User….

5. In the Database User – New dialog box, on the General page, select SQL user with login.

6. In the User name box, enter the name psweb.

7. In the Login name box, enter the name psweb.

8. In the Default schema box, enter dbo.

9. In the Membership tab, select db_datareader and db_datawriter.

10. Click OK.