imitchell - Friday, July 8, 2011 3:16 PM:
Hello,
We wanted to dable with AML so we took an existing Aras DB backup of our production system, brought it to a new machine, did a restore, and installed Aras. The default passwords (as identified in the Aras install doc) didn't work, nor did some of the account from the production system.
I probably did something non-standard here, but any thoughts?
On Both Machines - Aras 9.1, SQL Server 2005 Express, SQL Server Management Studio Express.
Thanks,
Ian
Brian - Tuesday, July 12, 2011 5:50 AM:
Hi Ian,
You need to run three queries in SQL Server Management Studio against the new database to enable the default logins.
Paste these into a new Query and execute them one at a time.
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
exec sp_grantdbaccess 'innovator','innovator'
exec sp_addrolemember 'db_owner','innovator'
Then try logging in again.
Cheers,
Brian.
imitchell - Monday, August 8, 2011 11:46 AM:
Thank Brian - so the above worked on one scenario but it not on another (which follows):
Did not previously put Aras on the machine.
Did a restore of same backup file as the scenario where it worked.
Tried to run the above commands but got a "login does not exist" error.
The innovator account was restored "without login" so it was an orphan account.
Do I need to install Aras first so the innovator account is created up front?
Brian - Wednesday, August 10, 2011 5:37 AM:
Hi Mitchell,
Yes you need to install Innovator on the machine before the database restore will work.
The install process creates the "innovator" login.
Cheers,
Brian.
imitchell - Wednesday, August 10, 2011 8:37 AM:
Thanks Brian,
I did that a few days and it did indeed work. I was not sure if that was considered an acceptable solution so I did not post it here. In retrospect, I should have posted it so that you would not have to spend the time to respond (or to correct me if it was not the best solution). Sorry about that!
Thanks much,
Ian
imitchell - Wednesday, August 17, 2011 7:37 AM:
So to recap the steps in the case where I want to restore a db to new machine:
Install Aras (creating "fake" DB)
Restore the actual DB
run the 3 sql commands
Update the InnovatorServerConfig.xml file
Launch Aras and login
Is this correct?
Brian - Wednesday, August 17, 2011 6:55 PM:
By new machine I assume you mean a machine that you want to act as an Innovator Server.
If so then yes you need to have installed Aras first as this creates the Innovator user in the SQL Server instance.
The other steps are correct.
Cheers,
Brian.
Manmeet - Tuesday, April 26, 2016 1:09 AM:
Hi Brian,
I have followed the steps as Ian has outlined above.
But these are not working for me. Please help me about this. I explained the problem below:
Launch Aras and after I am able to login into the ARAS Innovator Server.
Whenever I access any object or item, for example, If I try to access Users tab,
It starts to show loading in Status Bar. Please advise why data is not being shown? Please let me know if you need more information.
Thanks,
Manmeet Singh
