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