Luehman wrote:What should I put in these fields?
I assume my SA for the SQL Login field however I do not know the Report SQL one....
Ummm... no, not the sa user.
That should have been be JiwaUser and JiwaFinancials123.
Those messages you got:
- Code: Select all
Msg 15138, Level 16, State 1, Line 1
The database principal owns a schema in the database, and cannot be dropped.
Is what is I think is preventing you from progressing further. You've now got some SQL Users (JiwaUser, JiwaLogin, JiwaReports) with bad SID's AKA orphaned users.
The easiest way to move forward from where you are is by using SQL Server Management Studio (SSMS) to drop the users, and then running the script I last provided (It may present errors that it can't drop users that don't exist, but the rest will run ok - those errors can be ignored and would be expected after using SSMS to drop them).
Also, when you created the instance of SQL Server, did you choose mixed mode authentication? Because that's what we require. You can change that also via SSMS - but do that before anything else if you don't currently have mixed mode authentication.
Again - you can always engage us to take your V6 database and we can hand you back an upgraded one for V7. There is a limit as to how much free support we can provide in these forums. These forums are the Technical / Programming forums aimed at assisting, educating and empowering developers, and not really aimed at assisting customers to self-upgrade.