Intel EMA Azure SQL server problem

[Yauheni]

Hello, I use Azure resources for my EMA server (version 1.14.1.0)

-Azure VM

-Azure SQL server

I have configured my Intel EMA server and got it worked. Then I am trying to set up replica sql server and getting next problem when trying to change database server:

It is very strange because this user is Server admin which I used during initial set up process.
In azure sql I cannot add some other admin user.

[Yauheni]

1) Edition Windows Server 2019 Datacenter
2) Azure Sql server General Purpose (GP_S_Gen5_1)
3) Both virtual servers in Azure
4) Different servers

[Arun_Intel1]

Hi Yauheni,

Greetings!

We see that the EMA server and the General purpose SQL on the Azure are on different virtual machine (Different servers) where you are trying to replicate or duplicate the SQL server, upon which you are getting an error which says "The Specified installer user does not have the required access to continue. Please grant the user required role and try again".

We would like to inform you that we would be able to backup the SQL server but not duplicate it, as there would be two SQL's to which EMA server would be pointing.

Hence we would be able to back up the SQL server if required.

Best Regards

Arun_intel

[Yauheni]

This is just a read-only replica of EMADatabase in different region for disaster recovery, and EMA server is pointing to only 1 server not 2.

For what reason there is an option to update database settings? Only for switching to empty database and or new sql server?

And strange behavior is when I don't change any option in update database settings window and just click update I see the same error.

[Arun_Intel1]

Hi Yauheni,

Greetings!

Please share the latest EMA server logs so that we can go ahead and analyze the situation and share our response, and also confirm that where and how the SQL database would be located.

Steps to collect the EMA server logs are as given below:

Default Path:[System Drive]\Program File(x86)\Intel\Platform Manager\EmaLogs

Please send me the files without the date called:

EMAlog-Webserver.txt

EMAlog-Swarmserver.txt

EMAlog-Ajaxserver.txt

EMAlog-Recoveryserver.txt

EMAlog-Manageabilityserver.txt

Best Regards

Arun_Intel

[Yauheni]

Hello, We use Azure sql server 

"type": "microsoft.sql/servers",
"kind": "v12.0",

"name": "EMADatabase",
"type": "microsoft.sql/servers/databases",
"sku": {
"name": "GP_S_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 1
},
"kind": "v12.0,user,vcore,serverless"

I have shared logs in zip file. Looking forward for your reply.

[Arun_Intel1]

Hi Yauheni,

Greetings!

Thank you for sharing the requested logs, we are analyzing the logs and will share our findings shortly.

Best Regards

Arun_intel

[Arun_Intel1]

Hi Yauheni,

Greetings!

We would request you to follow Azure's requirements to replicate or backup the database when we use Azure SQL.

Please refer the customer to section 5 SQL Server Deployment

https://www.intel.com/content/dam/support/us/en/documents/software/manageability-products/intel-ema-web-deployment-guide-fo-azue.pdf#page=29

Best Regards

Arun_intel

[Yauheni]

I got it, what about my previous question:

For what reason there is an option to update database settings? Only for switching to empty database and or new sql server?

And strange behavior is when I don't change any option in update database settings window and just click update I see the same error.

I still want to know why I can't switch to another server from EMA installer or even just update settings with the current server.

[Arun_Intel1]

Hi Yauheni,

Greetings!

In Intel Endpoint Management Assistant (EMA), the option to update database settings is provided to allow administrators to modify the database configuration without having to reinstall the entire application. This can be useful in several scenarios, such as:

1. Switching to a New SQL Server: If you need to migrate your database to a new SQL Server instance, you can use the update database settings option to point EMA to the new server without having to go through a full reinstallation process.
2. Changing Database Credentials: If the credentials for accessing the SQL Server database change (e.g., due to a password update or a change in the user account), you can update these settings to ensure that EMA can continue to connect to the database.
3. Modifying Database Connection Parameters: If there are changes in the network configuration, such as a change in the server's IP address or hostname, you can update the connection parameters accordingly.

Regarding the strange behavior you are experiencing, where you see the same error even when you don't change any options and just click update, this could be due to several reasons:

• Validation Issues: The update process might include validation checks that are failing, even if no changes are made. This could be due to incorrect or outdated information in the current settings.
• Permissions: Ensure that the account you are using to update the settings has the necessary permissions to make changes to the database and the EMA configuration.
• Configuration Errors: There might be underlying configuration errors that are not directly related to the settings you are trying to update. These errors could be causing the update process to fail.

To troubleshoot this issue, you can try the following steps:

1. Verify Current Settings: Double-check the current database settings to ensure they are correct and that the database is accessible.
2. Test Connection: Use a database management tool to test the connection to the SQL Server using the same credentials and connection parameters.
3. Consult Documentation: Refer to the Intel EMA documentation for any specific requirements or known issues related to updating database settings.

In summary, the option to update database settings in Intel EMA is designed to provide flexibility in managing the database configuration. However, the link shared would be helpful for resolving the issue.

Best Regards

Arun_intel

[Yauheni]

Hello, the strangest thing is if I let EMA installer create EMAdatabase on the azure SQL server in the very end I get error (logs attached). It says 

But EMA installer created it!

Keep in mind that I use sql administrator account during install ( the most powerful user on azure sql server possible). Looks like something wrong with installer, but this way is recommended from intel-ema-web-deployment-guide-fo-azue

If I create EMAdatabase by myself before install and just let installer use this database and alter it installer finishes successfully with several exceptions, but it works. In this case  I cannot change any option in update database settings window.

Please, check this process on your side or let's make a call and I show you this problem. Waiting for your reply.

[Arun_Intel1]

Hello Yauheni,

Greetings!

Thanks for sharing the details,

As per the screen shot warning seen, we see that you are trying to fresh install EMA. and are using different virtual machines for installing EMA and for the SQL db.

Please confirm if you are creating an Azure VM for the database and the Server OS of this virtual machine or if you are using the embedded Azure SQL database.

Best Regards

Arun_intel

[Yauheni]

Hello, 

Yes, I use virtual machine for EMA server and for database azure sql server with database inside

"type": "microsoft.sql/servers",
"kind": "v12.0",

"name": "EMADatabase",
"type": "microsoft.sql/servers/databases",
"sku": {
"name": "GP_S_Gen5",
"tier": "GeneralPurpose",
"family": "Gen5",
"capacity": 1
},
"kind": "v12.0,user,vcore,serverless"

If if understand correctly what you mean yes we use the embedded Azure SQL database.

[pujeeth]

Hello Yauheni,

Greetings!

Thanks for sharing the details, we are checking on this issue and will get back to you with an update as soon as possible.

Regards,

Pujeeth

Intel Customer Support Technician

intel.com/vPro

[Arun_Intel1]

Hello Yauheni,

Greetings!

We would like to connect through a web meeting, therefore you would receive an email about the same.

Kindly acknowledge the same.

Best Regards

Arun_intel

[pujeeth]

Hello Yauheni,

Greetings!

Thank you for the update. We are coordinating with the team to check availability and will provide you with an update as soon as possible.

Thanks & Regards

Pujeeth

Intel Customer Support Technician

intel.com/vPro

[Arun_Intel1]

Hi Yauheni,

Greetings!

Kindly acknowledge to the email sent.

Best Regards

Arun_intel

[Yauheni]

Hello,

Thanks for your reply. Yes, I got the email and answered to it.

[Arun_Intel1]

Hi Yauheni,

Greetings!

As per our conversation in the meeting, we have sent out an email with details.

Thank you for contacting Intel!

Best_Regards

Arun_intel