sshsu - Friday, May 15, 2009 2:46 AM:
Hi,
I use 'SQL Server Management Studio Express' to restore Innovator 910 demo database to new installed Innovator 9.1 application, and I got the error message as the screen capture in attach file.
System.Data.SqlClient.SqlError: ????????'InnovatorSolutions'???????????.(Microsoft.SqlServer.Express.Smo).
(Translation)
System.Data.SqlClient.SqlError: Backup set include backup data of other database other than current 'InnovatorSolutions' database. (Microsoft.SqlServer.Express.Smo).
How to fix it?
I got 9.1demo database from www.aras.com
http://www.aras.com/communityProjects/default.aspx?projectid=59D9F0D66ECC477DB67660F24198695D
Best Regards,
SS Hsu
PeterSchroer - Friday, May 15, 2009 9:01 AM:
Error message sounds like you are Restoring the database to replace the InnovatorSolutions database. SqlServer is warning you that the Backup file is from a database named Demo910, but you are restoring on-top-of (to replace) a database named InnovatorSolutions.
You have 2 choices... if you really want to replace the database named InnovatorSolutions, then check the box "Overwrite existing database", otherwise, restore the Backup file to a new database named Demo91.
pallavig - Monday, July 25, 2011 7:56 AM:
I want to restore database.When I follow all steps then error occurred as:-
I am unable to restore database.
Please answer my question and help me.
sshsu - Friday, May 15, 2009 7:39 PM:
Hi Peter,
Thank you for your quick response. Demo910 is now sucessfully retore to innovatorsolutions database. However I can't use default administrator ID to login (id: admin, password: innovator), and it keep on shows "Login failure, user 'innovator' fail to login."
What is the administrator 'admin' (or maybe 'innovator') password in Demo910 database?
Thanks,
SS
pallavig - Monday, July 25, 2011 8:00 AM:
I want to restore database.When I follow all steps then error occurred as:-
"Restore failed for Server "Server Name".
System.Data.SqlClient.SqlError:The media set has two media families but only one are provided.All members must be provided."
I am unable to restore database.
Please answer my question and help me.
PeterSchroer - Saturday, May 16, 2009 8:40 AM:
username=admin, password=innovator is the correct logon to the Demo910 database.
Login failure, user 'innovator' is a message from SqlServer. The aras Innovator server is not able to connect to SqlServer.
This is a common problem when we move a database backup image from one server to another server. it is due to the way Microsoft SqlServer creates the 'innovator' user account inside SQL. It has a different GUID in all systems, so you need to re-establish that the 'innovator' who owns the database backup is the same 'innovator' user in your SQL Server instance. Not difficult.
I put a SQL script into the ZIP file with the Demo910 distribution. FixDB.SQL and FixDB.bat you should edit the FixDB.SQL to put the name of the database (in case you changed the name from Demo910), and then run the FixDB.bat.
NOTE: if you are using SqlServer Express free version, sometimes the FixDB cannot connect, due to missing SQL programs or connection permissions in the free install. In this case, just open SQL Management Studio, and you can type the SQL commands manually.
sshsu - Tuesday, May 19, 2009 11:23 PM:
Dear Peter,
Thank you for your response. The Demo910 database is now installed to Innovator system successfully.
Thanks.
