new1234.jpg
Home > VMware > VMware: vCenter Datamigration: Msg 3013, BACKUP DATABASE is terminating abnormally

VMware: vCenter Datamigration: Msg 3013, BACKUP DATABASE is terminating abnormally

One of my colleagues was migrating vCenter 4.0 database to vCenter 4.1 by using the Datamigration Tool located at the vCenter Installation CD. After running the Backup.bat script he received the following error:

DB logs: Msg. 3013, Level 16, State 1, Server <name> , Line 1 BACKUP DATABASE is terminating abnormally

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..

 

image

Resolution:

Note: To verify some of these settings, it is necessary to install Microsoft Studio Manager Express on the source server (the server you are migrating from). You can download this utility from the Microsoft Download Center.

  1. Ensure that the SQL Server service itself is running on the existing vCenter Server. Having this service disabled or not running can cause this issue and prevent the script from running. To ensure that it is running:

    1. Click Start > Run, type services.msc and click OK.

    2. Right-click SQL Server (SQLEXP_VIM), then click Start.

  2. Ensure that there are no firewalls blocking access to the SQL Server instance on the vCenter Server. If you are unsure, disable these services during migration, or make an exception on your firewall to allow this service to run. Ensure that TCP Port 1666 is allowed access to the service. Configuring specific firewalls is beyond the scope of this article. Consult your firewall vendor for more information.

  3. Ensure that Named Pipes and TCP/IP protocols are enabled on the server. To ensure they are enabled:

    1. Launch the SQL Server Configuration Manager utility and go to SQL Server 2005 Network Configuration.

    2. In the left-hand pane, highlight Protocols for SQLEXP_VIM.

    3. In the right-hand pane, right-click Named Pipes and select Enable, then right-click TCP/IP, and select Enable

    4. Click Properties.

    5. On the IP Address tab, ensure that Enable is set to Yes for each network adapter that is listed.

    6. Click OK to close the TCP/IP Properties dialog.

    7. In the left-hand pane, select SQL Server 2005 Services, right-click SQL Server (SQLEXP_VIM), then click Restart.

  4. Ensure there are no Invalid entries in the Named Pipes Protocol under SQL Server 2005 Network Configuration. To check if there are invalid entries:

    1. Launch the SQL Server Configuration Manager utility and navigate to SQL Server 2005 Network Configuration.
    2. Click Protocols for SQLEXP_VIM and then double-click Named Pipes in the right panel.
    3. On the Protocol tab, notice the value of the Pipe Name item. If the value contains an entry similar to \\.\pipe\MSSQL$SQLEXPRESS\sql\query , rename the entry to \\.\pipe\sql\query .
  5. Source: VMware

sanderdaems

Sander Daems is founder and author of this blog and working as a Lead (Sr.) Consultant by UNICA ICT Solutions. Sander has over 15 years experience in IT, primary focus: virtualization and modern worksplace.

More Posts - Website

Follow Me:
TwitterLinkedIn

  1. Gaulin
    September 24th, 2010  (Quote) at 14:35  (Quote) | #1

    Sander is the greatest!!!

  2. September 25th, 2010  (Quote) at 02:39  (Quote) | #2

    first reply here, thanks

  3. September 25th, 2010  (Quote) at 09:05  (Quote) | #3

    Nice sharing, thnx

    Regards,
    Mariano

  4. Oscar
    September 26th, 2010  (Quote) at 03:18  (Quote) | #4

    Great blog post, I’ve been waiting for something like that =D

  5. Pieter
    September 26th, 2010  (Quote) at 23:07  (Quote) | #5

    Great post! I want you to follow up to this topic

  6. Thomas
    September 28th, 2010  (Quote) at 06:08  (Quote) | #6

    Thank you very much for this solution!

    Gr.
    Thomas

  7. Murk Maxwell
    September 29th, 2010  (Quote) at 16:49  (Quote) | #7

    I motivated by you, your opinion and posts, again, thanks for this nice post.

    – Murk

  8. mister iks
    November 29th, 2010  (Quote) at 17:24  (Quote) | #8

    Changing the Pipe Name did the trick for me, thx!

  9. January 20th, 2011  (Quote) at 13:23  (Quote) | #9

    Thnx Sander

  1. No trackbacks yet.