Anonymous - Tuesday, August 21, 2007 12:50 PM:
I have built a new W2K3 R2 fully-patched, domain member virtual machine to test this application. Installed .net 2.0 and SQL 2005 Express. New user to SQL...
sa account is enabled, created another admin account also.
SQL and Windows authentication mode is enabled.
not using local host during install serversqlexpress
I have tried several ways to get the database to install.
1. Created innovator user manually. Created innovatorsolutions database, made innovator user the dbowner (and every other role). Confirmed I could log in using this account. The install proceeds to 99%, but then I get this error: The specified schema name "innovator" either does not exist or you do not have permission to use it. This is the preferable solution because I can specify an alternate (data drive) database location.
2. Removed the database and user created in #1, selected the Create a new database option. I get this error: User, group, or role 'innovator' already exists in the current database. I tried using different database and user names, but still get the same error. I have fished around the SQL interface, but I'm not sure where to clean things up. I remove the database and login created, but I don't know where else to look.
Thanks in advance,
Robert
Anonymous - Wednesday, August 22, 2007 2:25 PM:
After trying many other options, I manually created a schema called innovator and achieved a successful install.
