Solution:

This article explains how to move a Sage Pro ERP Microsoft SQL Server (SQL) accounting database from one SQL server to another.

Please refer to the attached document for detailed instructions on this process.

HOW TO Migrate Accounting Data Between SQL Servers 

How to transfer logins and passwords between instances of SQL Server