Setup Example With Separate METTEAM and SQL Servers

Your organization may have a server dedicated to SQL databases and you may have to setup the METTEAM server separate from your installation of SQL Server. The following goes over a couple examples of how the website and SQL server can be configured to make sure they connect properly. If they cannot connect, you will get an error 500 when trying to access the website.

I will be referring to the following example names for each instance which you can replace with what you have:

• Domain name:  flukecal
• METTEAM server name: metteamserver
• SQL server name: sqlserver
• Service username: metteam_svc

LocalSystem Account Running the METTEAM Application Pool

The default installation of METTEAM sets the IIS Application Pool to be run by the Identity LocalSystem which will not be able to connect to the METTEAM database.

To allow connection to the database, you will need to do the following steps:

1. Connect to the SQL server (sqlserver in my example) as an administrator using SQL Server Managment Studio (SSMS)
   
   
2. Drop down Security-->Logins
3. Right-click on Logins and select New Login...
   
   
   
   
4. In the General page, type the login name of <domain>\<METTEAM server name>$ which in my example is flukecal\metteamserver$.
   
   
   
   
5. Select the Server Roles page on the right.
6. Check the public and sysadmin roles and click OK
   

Running the METTEAM Application Pool with a Custom Account

If your organization requires or prefers a specific domain account to run the website, you will need to change the application pool to run under that account and also give rights to that account on the SQL server. 

To change the account that the METTEAM application pool runs on:

1. Login to the METTEAM application server
2. Open IIS
3. Select Application Pools
4. Right-click on the METTEAM application pool and select Advanced Settings...
   
   
   
5. Scroll down to the Process Model section
6. Select the field named Identity
7. Click the ellipsis button
   
   
   
   
8. Click the Custom account radial button and click Set...
   
   
   
   
9. Enter the domain\username of the account (flukecal\metteam_svc in my case) and enter in the password for it
   

Now you will need to add the user account to your SQL server instance

1. Connect to the SQL server as an administrator using SQL Server Managment Studio (SSMS)
   
   
   
2. Drop down Security-->Logins
3. Right-click on Logins and select New Login...
   
   
   
   
4. In the General page, type the login name of <domain>\<username> which in my example is flukecal\metteam_svc.
   
   
   
   
5. Select the Server Roles page on the right.
6. Check the public and sysadmin roles and click OK
   

 Your settings may vary due to security requirements.