The original Requisite Pro is 2000, and there are multiple projects installed on the SQL Server database. Database Name: RequisitePro, User Name ReqPro, Password ReqPro, Database Login Name ReqPro
An error
In Requisite Pro 2002, there is an upgrade program RQDBUPGRADEWIZ.EXE, executing the program upgraded the original database, and the error cannot be found in the execution of a SQL statement.
Cause Analysis: The original database does not create login and users in accordance with the prompts in the installation instructions, causing the current object Owner to not belong to ReqPro, which is logged in by ReqPro, where the SQL statement does not specify the object Owner, thus causing an error that cannot be found.
Solution, reset the username, login, and Owner of each object.
Error
The last paragraph of running to the program is insufficient, with SQL TRACE tracks to a storage process (which one forgotten), check SQL Server manual, found that this storage process requires Server Administrator privileges, give ReqPro this Login Plus Server Administrator permissions is successful.
Note: But after successful upgrade, I found that when you create a new project, you first use the REQUSITE PRO's porting tool RqDataTransportWiz.exe to transplant existing projects into an Access database, then press SQL Server installation step to perform the installation script to create new The RequisiStePro database, re-transplant the items in the Access database to SQL Server.
