Migrating to Vault 2012. Backup Error

[Anonymous]

Hi all,

I need help in my Vault migration.

We are running vault 2011. I am trying to migrate it to vault 2012 on another machine. I need to back up the vault for this.

I am following the procedure shown in the documents. This is what I have done

1. Open ADMS 2011
2. Log in as administrator.
3. Select the Vault
4. From Tools--- backup
   Select Backup
5. In the Back up dialog box (See Pic 2)
   Check Path to backup folder on C drive of the server
   Check "Validate Data".
   Uncheck Back up Standard content Center Libraries
6. Click  OK

The validation of data starts.

After the completion of validation, following error is displayed :

"Failed to check pending changes from workgroup AUTODESK\AUTODESKVAULT. Error a network related or instance specific error occured while establishing a connection to SQLServer. The server was not found  or was not accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections. (provider: SQL Network Interfaces, error : 26-error locating server/Instance Specified)"

I have attached a screen image (Error.jpg)

Any help is greatly appreciated

Regards

Lalit

[paul.gunn]

Hi Lalit,

Based on your error message it sounds like the SQL server machine was renamed at some point [i.e. the SQL server was previously named AUTODESK]. This causes some problems for SQL as it's internal records still contain the old name and the old name is subsequently reported to applications like Vault.

This is resolvable but I don't think there is a simple single-step solution - as some of the vault database records will likely also have the incorrect old name at this point. My best suggestion would be to contact product support with this issue so they can help you get the problem resolved..

Paul

[Anonymous]

Paul,

Thanks for your reply.

We are a team of three client machines and one server.

We did not change the name of the server machine at any point.

Last year we did migrate from vault 5 to vault 2011 by going through the route of vault 5----vault 2009-----vault 20011.

I followed the procedure and the data migrated well. We have been using the vault without any problem for a year now.

Yesterday when I ran the diagnostic tools on server it gave me a error of login failed for user "sa". I changed the sa password to "AutodeskVault@26200". after that the diagnostic did not show any error.

 I am attachihng the latest log file for your perusal.

If you can guide me a little it will be a great help

Regards

Lalit

[paul.gunn]

Hi Lalit,

If there was no machine rename involved then this is a very puzzling case. I cannot explain why such an error might occur without any material changes to the server - and the diagnostic tool is not really providing any insight. I do recommend you to contact product support on this issue - detailed analysis is needed to understand the cause and solution for this issue.

Paul

[Anonymous]

Paul ,

Thanks for your reply.

One point I want to make is: when we installed vault 2011 . I could login to the server (PILOT) from two client machines and could not login from two separate client machines.  We resolved this problem by using the ip address instead of the Server name (PILOT) in the login screen on the client machines.  Can that be an issue. We posted that problem on the forum and Dave Mink Helped us . the Link to the question is following

http://forums.autodesk.com/t5/Autodesk-Vault/Could-not-find-the-data-management-servces-on-the-serve...

Is uninstalling the Vault 2011 (server) and reinstalling it a possible solution? Only thing is we dont have the ability to back up before uninstling the vault.

Thanks

[paul.gunn · Accepted solution]

Hi Lalit,

My guess is that a reinstall would not particularly help based on what you are seeing - however I could be wrong. The problem is that we don't really understand what is going on with your system.   This is why I continue to recommend product support involvement - there needs to be some analysis of what the cause of the problem is. Once the problem is understood it becomes much easier to determine the appropriate solution.

Paul