MattAnderson - Wednesday, December 4, 2013 6:12 PM:
I was able to install SQL Express, IIS, and Innovator. At the Innovator login screen I entered "admin" and "innovator", only the one database in the dropdown "InnovatorSolutions".
Get the error "The Database is not available."
I'm not familiar with SQL so not sure where to start.
Jennifer - Wednesday, December 4, 2013 6:23 PM:
Hi Matt,
I'd highly recommend watching this short tutorial video on installing Aras.
It's pretty comprehensive and gets about 90% of people with a challenge to a place where they can log in successfully.
Best,
Jennifer
MattAnderson - Friday, December 6, 2013 9:42 AM:
Yep, found a setting that I missed earlier.
Thanks
kpayne - Saturday, March 8, 2014 6:44 PM:
Hi Matt,
I'm running into the same "The Database is not available" error. I watched the video but still can't find my mistake. Do you mind sharing what you changed to fix your problem?
Thanks,
Kevin
Manu31 - Monday, April 14, 2014 12:45 PM:
Hi Kevin,
I faced this type of error and the solutions was : to modify the following parameters in the InnovatorServerConfig.xml file, like that :
<DB-Connection id="DEMO940 (displayed in the popup as a choice)" database="ArasSolutionsDemo940 (as defined in SQLServer : the real name of the database)" server="(local)SQLEXPRESS (look at an example, the connection string defined in SQL Server Management Studio" uid="innovator" pwd="(the password you defined during the installation procedure, not the sa password but the innovator password"/>
Another idea that comes to me is to try to execute the SQL procedure you use when you install Aras demo as follow :
- first, it's mandatory before the following, backup your database with SQL Server Management Studio
- in SQL Server Management Studio, right click on the database name, and select "New query"
- copy the following line in the new window opened :
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
- execute the command (!)
- in the same window replace the last command by :
exec sp_addrolemember 'db_owner','innovator'
- execute the command (!)
(no commit is necessary, SQL Server is in auto commit mode by default)
Hope this will help you.
Don't hesitate to contact me in case of problem.
Regards
Manuel
kpayne - Thursday, April 17, 2014 4:40 PM:
Hi Manuel,
Thanks for your response. I ended up resolving my issue by re-installing the software. I wish I had your response a few weeks ago though since I bet it would have fixed my issue.
Thanks!
Kevin
