The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 3:49 PM
|
I am trying to do a trial upgrade of a production database. I have created a 2008 virtual machine with SQL 2005.
I made a copy of the production database and restored it to the SQL 2005 server. I fixed the Sysdba user, and changed the path in the syncserver table and changed the ping server name in system info to the test server name.
The connection in connection manager succeeds.
When when I try to connect to the 6.2 server using the 6.2 administrator program I get a message 'database login failed: invalid object name 'plugin''
I also am getting this error when I try to run the 7.5 upgrade.
Any Ideas?
Thanks in advance
Beth |
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 4:32 PM
|
How did you make the Copy of the DB?
The objects should be owned by sysdba (or belong to the sysdba schema).
|
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 4:49 PM
|
Thanks for your reply
Sysdba is the db owner.
I created sysdba and made it a owner of the Saleslogix DB
I did a back up of the original database and restored it to the new server.
Then I ran script to reset the sysdba user sp_change_users_login 'auto_fix', 'sysdba'
|
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 4:57 PM
|
If you connect ot the DB using Management Studio, login in as sysdba, are you able to query the tables without adding any prefixes?
e.g. SELECT COUNT(*) FROM ACCOUNT
If so, then the DB is indeed ok, and I would move to the next level: Check the Connection Manager configuration.
Make sure that the password for sysdba is being saved (depending on the version of SQL, there may be a situation where the Password doesn't stick regardless of having checked the "Save Password" checkbox.
So, just open Connection Manager, edit the connection and test it (without providing the PW, if it fails, it means that the PW didn't stick). Save it again, and make sure it sticks. |
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 5:23 PM
|
I logged into the database as sysdba
SELECT COUNT(*) FROM ACCOUNT doesn't work but it does work with SELECT COUNT(*) FROM sysdba.ACCOUNT
Sysdba os database owner and mapped to saleslogix DB
Connection manager can successfully authenticate to database. |
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 07 Oct 09 11:36 PM
|
try fixing the user again:
sp_change_users_login 'update_one', 'sysdba', 'sysdba'
You shouldn't have to prefix the database if you are logged in as sysdba unless something is still wrong. |
|
|
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 08 Oct 09 2:59 AM
|
Beth, you didn't restore db correctly. No amount of fixup will get this to work so just do this:
* Drop database
* Create new database
* Ensure sysdba has role of public/dbowner
* Restore database
* Fix sysdba user
This works. Also, you may want to beware of an easily missed option with SQL2008 - see here: http://www.empath-e.com/documents/Bulletins/081009.pdf |
|
|
| |
|
Re: Trial Upgrade 6.2 to 7.5
Posted: 23 Jul 10 10:43 PM
|
Thanks much for the solution to:
Set Persist Security Info = True
Reset ‘Integrated Security Info’
After doing both of these, I am now able to use admin ws to login my v7.0 db with the v7.5 admin ws so i can install the upgrade bundles 7.0 to 7.2 and 7.2 to 7.5.
Thanks again for your solution! |
|
|
| |
|