cancel
Showing results for 
Search instead for 
Did you mean: 

Environment duplicating : connection to SystemDb has failed

Solved
Occasional Contributor

Environment duplicating : connection to SystemDb has failed

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

3 Replies
MEGA Partner

Re: Environment duplicating : connection to SystemDb has failed

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

Occasional Contributor

Re: Environment duplicating : connection to SystemDb has failed

Hi Hassan,

 

Thank you for your reply.

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

 

Regards,

Asmaa

MEGA Partner

Re: Environment duplicating : connection to SystemDb has failed

Hi,

 

Yes, it is applicable with SysDB as well.

 

 Regards,

Asim