Environment duplicating : connection to SystemDb has failed

[abaidas]

Hi community;

we want to make a test environment from a production environment. Here what we did :

1- In SQL Server, we restored a copies of production databases ProdEnv_SystemDb and ProdEnv_DataDb into a new databases TestEnv_SystemDb and TestEnv_DataDb

2- In MegaSupervisor we created a new environment :

             name=TestEnv

             storage =Sqlserver

            restore enabled

the problem is that the connection test to SystemDb fails unless all the parameters (instance, user, password) are correct. We don't have any details about the error. 

Thanks for your help.

Best regards.

Asmaa

[AHassan]

Hi,

Yes, it is applicable with SysDB as well.

 Regards,

Asim

[abaidas]

Hi Hassan,

Thank you for your reply.

Is the duplication procedure, described in the post, applicable for SystemDb repository too?

Regards,

Asmaa

[AHassan · Accepted solution]

Hi Asmaa,

Performing a duplication via SQL Server tools (physical duplication) will not work or at least not recommended.

Please see the below post:

http://community.mega.com/t5/Infrastructure-Exploitation/How-to-duplicate-SQL-Repositriy/m-p/13776#M...

Regards,

Asim