07-26-2013 08:32 PM
Hi there,
I am doing EV upgrade from 9.0.4 to 10.0.3, and moving the SQL database at the same time.
I am using server migration wizard, and stuck on the verify database instances. All Databases passed the verification (directory, storage, fingerprint) except EVMonitoring database. I have run the sql command to change the monitoring database server name as instructed in "moving sql database to another server" doc.
When I run "selelct SQLserver from MonitoringSettings" against EnterpriseVaultDirectory database, it does return the correct new sql database name.
My server migration wizard accetp all other database instances on the new sql server but not monitoring database.
Any help are appreciated.
cheers
ying
Solved! Go to Solution.
07-26-2013 11:05 PM
07-26-2013 10:14 PM
07-26-2013 10:31 PM
Hi JesusWept3,
Thanks for you reply. I could not reply to your message, thus started a new commnet.
How do I check the system DSN?
cheers
Ying
07-26-2013 10:33 PM
if you know you did it correctly and you see the correct info with your manual tests can you just skip past it?
07-26-2013 10:34 PM
07-26-2013 10:44 PM
@JesusWep3: no system DSN cofigured
@andrewB: can't skip server migration wizard if failed at any step
07-26-2013 11:02 PM
07-26-2013 11:05 PM
07-26-2013 11:13 PM
mmm, schemaVersion is 7.3.0.5 already.
I think I made the whole upgrade process too complecated by move database at the same time. I'd better step back and con. to use the old sql database.
07-29-2013 01:30 AM
The System DSN which you check for EV on 64 bit OS is little different. Because EV is 32 bit application.
For example, goto C:\Windows\SysWOW64 and run odbcad.32.exe.
This will show you 32 bit System DSN's, make sure its pointing to correct Server.
I hope this helps..