Permissions

The iPXE Anywhere Web Service installation wizard checks if the user account executing the installation has sufficient privileges to create the SQL database, but the user account does not actually create the database. The SQL database is created by the "2Pint Software iPXE Anywhere Web Service" at service startup.

Prior to installing the iPXE Anywhere Web Service, the following permissions are required:

Installer Account Permissions

• Local administrator rights on the server which will be hosting the iPXE Anywhere Web Service

• db_creator permissions for the SQL database Instance

• db_datawriter permissions for the master database

Machine Account Permissions

After the installation wizard is complete, the "2Pint Software iPXE Anywhere Web Service" will start and attempt to connect to SQL. At service startup, the service will check for the iPXE Anywhere database, and if it does not exist it will attempt to create it. The service runs as the user context "NT AUTHORITY\SYSTEM" or the Local System Account.

• If SQL is installed on the same machine as the iPXE Any Where Web Service, the account: NT AUTHORITY\SYSTEM must be granted dbcreator permissions. The service will also grant the local system account db_owner permissions to the iPXE Anywhere database.

• If SQL is installed in a remote SQL server, the Domain Machine Account ($ComputerAccount) must be granted dbcreator permissions. The service will also grant the domain computer account db_owner permissions to the iPXE Anywhere database.