EMA Install Troubleshooting

[aridolfi]

Hello,

I am trying to install a new EMA instance and running into some issues.

I've been able to successfully get the software installed in a single server instance, with SQL being housed on a different server. However, in the logs of the install, I receive a warning: "Unable to add service user to database. Please give the service user correct access to Intel(R) EMA database.". This is using Windows Authentication for the dB setup. Once the install completes, the site refuses to load with a runtime error displaying "Server Error in '/' Application". There are a number of event log entries referencing .NET and the various executables of EMA.

I have since uninstalled the software and attempted to reinstall using SQL authentication; sa account for both the installer and EMA Service accounts. However, I can't get past that page of the installer. Getting error "Cannon connect to default database. The SQL connection is probably wrong."

Can anyone assist me in getting the software installed and provide best-practice guidance on the installation for EMA?

Application server is Windows Server 2022

SQL Server is Windows Server 2022 with SQL Server Standard 2022. 

Thank you. 

[vij1]

Hello Aridolf,

Greetings!

Thank you for your continued interest.

You are attempting to install Intel EMA on a Windows Server 2022 application server with SQL Server housed on a separate Windows Server 2022 machine running SQL Server Standard 2022. During the installation, you encountered a warning about the service user not having the correct access to the Intel EMA database when using Windows Authentication. After switching to SQL Authentication, you faced an error stating "Cannot connect to default database. The SQL connection is probably wrong."

Follow these steps to install Intel® EMA:

1. Install Microsoft Server 2019 or 2022
2. Add Server Role: Web Services (IIS)
   • Details in section 1.3.5 of the Intel® EMA Server Installation and Maintenance Guide.
3. Download and install URL-rewrite
   • Details in section 1.3.5 of the Intel® EMA Server Installation and Maintenance Guide.
4. Download and install Microsoft SQL Server Enterprise 2017 or higher
   • SQL Express is supported for testing with less than 500 units.
   • Details in section 1.3.3 of the Intel® EMA Server Installation and Maintenance Guide.
5. Download and install SQL Server Management Studio (SSMS)
6. Configure SQL Server:
   • Open SQL Configuration Manager.
   • Go to SQL Server Network Configuration.
     • Open Protocols for SQL Express.
       • Enable: TCP/IP and set IPAII.
     • Go to SQL Server Services.
       • Change the SQL Server Browser state to Automatic and start the service.

1. Open SQL Server Management Studio:
   • On Server name: Type (Server Name\SQL Database Name) if the database is on the same server.
   • For Encryption, select Optional.
   • Select the Security folder.
     • Open the Admin Account of the server.
       • Under Server Roles, assign dbcreator.
       • Under User Mapping, assign Master.
         • Under Database role membership, assign:
           • db_datareader
           • db_writer
           • db_owner

1. Download and install Intel® EMA
   • Keep a copy of Section 1.6 Important File and Directory Locations from the Intel® EMA Server Installation and Maintenance Guide.
     • Example: c:\inetpub\wwwroot

Regards,
Vijay N
Intel Customer Support Technician.

[aridolfi]

Vijay, thanks for the response.

Let me walk through your instructions to ensure I'm following them correctly as I'm still having issues.

1. Install Microsoft Server 2019 or 2022 - This is complete on SERVER1.domain.com (App) and SERVER2.domain.com (SQL). Both are running 2022. 
   
   
2. Add Server Role: Web Services (IIS) - This is complete on SERVER1.domain.com. IIS Role installed, Authentication setup to match guide: Anonymous and Windows are enabled. The rest are disabled. 
   
3. Download and install URL-rewrite - This is complete on SERVER1.domain.com. Downloaded and installed URL Rewrite Module 2.1 x64 from here LINK . Programs and Features shows the version as 7.2.1993. 
   
4. Download and install Microsoft SQL Server Enterprise 2017 or higher - I have SQL 2022 Standard to work with installed on SERVER2.domain.com 
   
   
5. Download and install SQL Server Management Studio (SSMS) - This is complete on SERVER2.domain.com 
   
   
6. Configure SQL Server:
   • Open SQL Configuration Manager.
   • Go to SQL Server Network Configuration.
     • Open Protocols for SQL Express.
       • Enable: TCP/IP and set IPAII. - TCP/IP is Enabled. What do I need to do with IPAll?
     • Go to SQL Server Services.
       • Change the SQL Server Browser state to Automatic and start the service. - This is complete. 

1. Open SQL Server Management Studio:
   • On Server name: Type (Server Name\SQL Database Name) if the database is on the same server.
   • For Encryption, select Optional.
   • Select the Security folder.
     • Open the Admin Account of the server.
       • Under Server Roles, assign dbcreator.
       • Under User Mapping, assign Master.
         • Under Database role membership, assign:
           • db_datareader
           • db_writer
           • db_owner
             This is complete. However, I'm using a Security Group for this step. The SG is currently has the dbcreator, public, and sysadmin roles. The user mapping has master selected with db_datareader,
             db_datawriter, db_owner, and public selected.
             

I changed the DB name to IntelEMA and the installer creates it without issue, but the Security Group is never added under the DB's Security\User folder structure.

I'm getting the same end result. Installer is complaining that it was unable to add the service user. Numbers of errors in Event Log referencing .NET Runtime and Application Errors  all referencing EMA executables. 

Let me know if you need any logs or additional information to continue troubleshooting. 

[vij1]

Hello aridolfi,

To proceed further with your Intel® EMA setup·       

Will the authentication be through Microsoft Active Directory, Entra ID (formerly Azure AD), or Local EMA accounts

Additionally, please ensure the following configuration and prerequisites are met:

1.     SQL Server Network Configuration:

o  Set the port for the database under SQL Server Network Configuration → Protocols for MSSQLSERVER → TCP/IP → IPAll section.

o  Make sure the port is set to: 1433

2.     .NET Framework Requirement:

o  Intel EMA requires .NET Framework 4.8.

o  We recommend updating the OS of both the EMA Application Server and SQL Server to ensure compatibility and security.

Looking forward to your response.

Best regards,

Vijay N

Intel Customer Support Technician

intel.com/vPro

[aridolfi]

I'd prefer to auth with Active Directory. 

I double checked the IPAll and verified it is set to port 1433.

Both the SQL and App server are running 2022, which should have .NET 4.8 included. Verified all Windows updates are installed on both machines. I was on CU18 on the SQL side, but just updated to CU19. 

[vij1]

Hello Aridolf,

Thank you for sharing the details. kindly allow us some time to check this, and we will get back to you with an update.

Regards,

Vijay N

Intel Customer Support Technician.

[vij1]

Hello Aridolfi,

Greetings!

Could you please confirm the location of your Active Directory (AD) and SQL database?

Are they hosted on the same virtual machine (VM), or are they deployed separately?

Looking forward to your response.

Best regards,

Vijay N

Intel Customer Support Technician

intel.com/vPro

[aridolfi]

Vijay,

AD, SQL, and the EMA application are on different VMs.