Create New Development SQL Database

SOLVED

Hi, my company is using FAS Premier Depreciation and Tracking software.  We have an Application server with FAS installed and then we have a SQL server instance with the production DB on it.  We are in need of creating a 2nd SQL DB but on a differnet SQL Server Instance.  I am working with my SQL DBA on this.  I assumed I would launch the Database utility on the applicaiton server to accomplish this.  But when I do it prompts me for the SA password to the existing prodcution SQL server.  So my question is how do I create this 2nd development DB on a different SQL Server instance.  Once that is accomplished what are the steps to copy the prod data to the dev DB?  I am the system\network admin so I am not really familiar with working in the FAS application.  I don't even have much access in the application to do much.  MY SQL DAB has the SA to create the DB though.  Also, do we need the SA password if the DBA creates a user for me that has DB owner\create privledges?

 

Thanks,

 

Steve

  • 0
    verified answer

    You will need to redirect the Database Utility to the new SQL server to create a new System and Asset database by changing the engine name to the new SQL Server's name in the registry located at:

    32-bit system: HKEY_LOCAL_MACHINE\SOFTWARE\Best Software\MSBESTSYS

    64-bit system: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Best Software\MSBESTSYS

    Change the EngineName to match the name of the SQL server.

    To move the data, we always recommend the Company backup\restore process through the client, which can also be redirected by the process above.

    You do have to have SA or SA equivalent user to login with the Database Utility. The program will setup its own user with db_Owner rights to the databases. That user will have no SQL server roles. SA rights are needed in order for the Database Utility to perform all the functions it needs to setup the databases.