tigrao - Thursday, December 16, 2010 10:56 AM:
Hi,
I have installed an instance of Aras functioning normally.
Now I want to add a new database.
I received a file Database2.bak.
I did the step by step what the Aras' manual of installation and configuration saids, I have created a new database based on the Database2.bak file and changed the InnovatorServerConfig.xml to:
<operating_parameter key="debug_log_prefix" value="C:Arquivos of programasArasInnovatorInnovatorServerLogs"> </ operating_parameter>
<DB-Connection id="Core" database="Core" server="(local)" uid="root" pwd="innovator" dbType="SQL Server" />
<DB-Connection id="Database2" database="Database2" server="(local)" uid="root" pwd="innovator" dbType="SQL Server">
but when I try to login in database Database2 displays the following error: "Can not open database 'Database2' requested by the login. The login failed. Login failed for user root"
I read the following documents but none helped me in this problem:
Installation Guide.pdf; Login Security.pdf; How To Restore a Database from BAK file.pdf
Help me please. Thanks.
dennis - Thursday, December 16, 2010 5:26 PM:
Have you run these three stored procedures after you restored the backup?
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
exec sp_grantdbaccess 'innovator','innovator' (this one will probably error and that is ok)
exec sp_addrolemember 'db_owner','innovator'
tigrao - Wednesday, January 5, 2011 1:39 PM:
ok, thank you Dennis Lindinger.
your help has served me very.
the problem was solved with your help.
cheers
