xgecko - Wednesday, November 9, 2011 3:40 PM:
I have tried to install Innovator on my SBS 2008 server running SQL Server 2008 R2 X64. I ended up doing the install with the Configure only option then restored the demo93_v2 database. When I try to log in using the innovator login I keep getting Invalid Object name 'USER'.
I am not clear on how to proceed. We were burned recently by another system so the ability to fully evaluate Innovator at little or no cost is critical to our success. We need to be able to get it up and running so we can evaluate it or we will have to look elsewhere. Can anyone help us get this going?
Thanks!
RobMcAveney - Thursday, November 10, 2011 3:44 PM:
Sounds like Innovator is able to connect to the database, but can't find the USER table. Check the database configuration in InnovatorServerConfig.xml (in your install directory). Try to connect manually with those parameters and make sure the USER table is present and owned by the innovator db user. You may also need to sync the db user with the SQL Server login, using the following SQL:
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
exec sp_grantdbaccess 'innovator','innovator'
exec sp_addrolemember 'db_owner','innovator'
xgecko - Thursday, November 10, 2011 4:12 PM:
I logged in as innovator and saw the USER table. However, when I run the script you gave me I get the following error:
Msg 15023, Level 16, State 1, Line 1 User, group, or role 'innovator' already exists in the current database.
I tried changing the owner but that fails as well.
RobMcAveney - Friday, November 11, 2011 11:36 AM:
That error is expected if the database is already configured properly. Nothing else jumps out at me as an obvious problem. My advice would be to reinstall with the standard database, using the Create option in the installer and the InnovatorSolutions template. Get that running first, then you can add the demo database in afterwards. That way you should at least have a running database to use as an example.
