Welcome to part 8 in a series of posts which describe how to create a Microsoft Office Project Server 2007 Virtual PC image for demos and development work. Last time, we looked at how to install SQL Server 2005 SP1 inside our VPC image. This time, we’ll look at how to create the accounts necessary for Project Server operation.
Part 8: Creating the Project Server Accounts
Create the SQLService Local User Account
Select Start > Administrative Tools > Computer Management:
In the left pane of the Computer Management window, expand System Tools, expand Local Users and Groups, then select Users:
Select from the menu: Action > New User:
In the New User dialog box, enter the following information, then click the Create button:
User name: SQLService
Password: enter a password
Confirm password: repeat the password
User must change password at next logon: No
User cannot change password: No
Password never expires: Yes
Account is disabled: No
After the new user is created, the New User dialog box is cleared; click the Close button:
Select the new SQLService user in the right pane, then select from the menu: Action > Properties:
Select the Member Of tab in the SQLService Properties dialog box, then click the Add button:
In the Select Groups dialog box, enter the Administrators group into the text area, then click the Check Names button:
If the entry is typed correctly, it will be validated against the groups configured on the virtual server; click the OK button after the validation is complete:
The new SQLService user is now a member of the Administrators group, as shown in the SQLService Properties dialog box; click the OK button to accept the changes:
Add the SQLService User Account to SQL Server
Select Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio:
In the Connect to Server dialog box, leave the default settings and click the Connect button:
In the left pane of the Microsoft SQL Server Management Studio window, expand the server name, expand Security, right-click on Logins, then select New Login:
In the Login – New dialog box, click the Search button:
In the Select User or Group dialog box, enter SQLService into the text area, then click the Check Names button:
If the entry is typed correctly, it will be validated against the users configured on the virtual server; click the OK button after the validation is complete:
Ensure that the Windows authentication is selected, then Server Roles in the left pane:
In the right pane, select dbcreator and securityadmin, then click the OK button:
You should now have the accounts needed by Project Server to operate inside the virtual machine.
In Part 9, we’ll look at how to install and configure the Project Server 2007 application inside the VPC image.