Hi, I have recently installed this software with the help of someone from Aras. I can log into the Innovator DB (l: admin p: innovator), but cannot login into the InnovatorSolutions DB. In trying to debug this with Aras, they recommended restoring the InnovatorSolutions DB. When that didn't help, we created a new DB called Solutions811 by going through the restore process again. I am not knoledgable in DB design, so I am not able to help myself diagnose the problem. Any thoughts as to what could be going on? P.S. I did have a few problems with the installation, so maybe that is why I am having the problems?
thanks,
Ken
Hello Ken.
Try to restore solutions DB and run the following SQL for the DB (for restored DB) using SQL Query AnalyzerEXEC sp_change_users_login 'Update_One', 'innovator', 'innovator'
After that modify InnovatorServerConfig.xml file (there should be C:\Program Files\Aras\Innovator\InnovatorServerConfig.xml if you used default settings during install). And add a new DB connection.
<DB-Connection id="my-solutions-DB" database="restored-DB-name" server="DBServer" uid="innovator" pwd="innovator?" dbType="SQL Server" />.
Try to login using this connection.
Let us know what is the result. If there is an error please provide the error message.