160
I am upgrading from SL 6.5 to SL 2011 and moving to a new DB server after installing sl 2011 and restoring my databases from my old systems, when I run the database maintenance application, the systems lists my system database but it does not list any of the application databases to upgrade. Has anyone experienced this? If so what did you do to resolve?
I have installed Windows 2008 R2, Microsoft SQL 2008 on a new 64 bit Dell
*This post is locked for comments
The issue is that in SQL, the Domain table in the system DB doen't see the new server. You have to have the new server there and in the Company table in the system DB.
This did solve my problem, I also made the change in the Company table
I am in the middle of performing the exact same upgrade.
There are many pitfalls along the way, especially if you are running business portal (HINT: you have to upgrade to 7.0 then to 2011 there is no direct path from 6.5 to 2011 if you are upgrading business portal as well).
Following moving the databases I would run the following queries against the systems database from SQL Management Studio:
1. Update Tables with New SQL Server Name - mbs2.microsoft.com/.../kbdisplay.aspx
UPDATE DOMAIN SET Servername = 'YOUR_NEW_SQL_SERVERNAME'
2. Clear out old registration information - mbs2.microsoft.com/.../kbdisplay.aspx
DELETE from REGISTRATION
DELETE from REGISTDETAIL
3. Clear out Customizations
The upgrade docs tell you to export your customizations prior to upgrade and then reimport them. I was having some strange issues with mine, so I ended up just clearing them all out and rebuilding them. To do that run the following queries
delete from custom
delete from custom2
delete from customvba
Have you checked the ServerName in the Domain table? It may still reflect the name of the old server.
Select DatabaseName, ServerName from Domain
--Update Domain Set ServerName = 'NewServerName' where ServerName = 'OldServerName'
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (