Forum Discussion

GrahamHyland's avatar
GrahamHyland
Level 4
13 years ago
Solved

Cannot Upgrade FSA store after I moved server

Hello,

I am in the process of upgrading to EV10 from EV8 on different servers

Steps taken so far

Upgrade current 2k3 EV8 to EV9

Build new 2k8r2

Run server migration

All worked !!

However I need to upgrade the FSA Vaults and I also need to fix a SQL collation issue before I can go to V10

The FSA Migrator Report States that it cannot connect to svsymantec Which is the old servername before I ran the above steps.

I cannot figure out where its picking up this parameter.

Any suggestions?

Graham

 

Enterprise Vault
Information Governance
Troubleshooting
Upgrade
  • TonySterling's avatar
    TonySterling
    13 years ago

    As a workaround to get upgraded you could always use the hostfile to point svsymantec to vsvsymantec

  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    So in the registry the SQL Server name is vsvsymantec, is that your SQL Server? 

    Is EV up and running? 

  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    Here are the steps to update the registry:

    Step 7 – Update the Directory database in the Registry (Enterprise Vault Server)

    1. Click Start > Run, type regedit and click OK.

    For 32bit systems, HKEY_LOCAL_MACHINE\Software\KVS\Enterprise Vault\Directory\DirectoryService.  

    For 64bit systems, HKEY_LOCAL_MACHINE\Software\Wow6432Node\KVS\Enterprise Vault\Directory\DirectoryService

    2. Double-click the SQLServer Name string value.

    3. Enter the name of the new SQL server in the value data field and click OK.

    4. Start the Enterprise Vault Directory Service, this will also start the Admin Service.

    How to move the Enterprise Vault (EV) SQL databases

    Article:TECH35744  |  Created: 2004-01-25  |  Updated: 2012-10-03  |  Article URL http://www.symantec.com/docs/TECH35744

     

  • GrahamHyland's avatar
    GrahamHyland
    Level 4
    13 years ago
    Yes that is my SQL server, it is actually the localhost - For some reason FSASumaryMigrator is looking for svsymantec (old SQL server) and not vsvsymantec (new SQL Server)
  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    Can you run this in SQL?

    USE EnterpriseVaultDirectory

    SELECT SQLServer, DatabaseName FROM VaultStoreEntry

  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    Hmm, have you always used the SQL alias?

    Also, what about this?  SELECT * FROM FSAReportingDatabase

  • TonySterling's avatar
    TonySterling
    Moderator
    13 years ago

    As a workaround to get upgraded you could always use the hostfile to point svsymantec to vsvsymantec