Error 1067: Veeam services not starting

[raymix]

Hi folks

Please check this screenshot before you read on - http://imgur.com/a/PAt4N

The problem: Veeam endpoint free 1.5 is not starting

What have I tried:

• Full uninstall of all 4 components (SQL and Veeam)
• Recreate database (regedit setting - https://www.veeam.com/kb2057)
• Reboot

I can't seem to get Veeam service to start no matter what I do. This happened suddenly after Windows 10 upgrade from initial to 1607 and then rolled back (due to FTP issues).
When recreating database, both MDF and LDF files are actually deleted and I can see them slowly being recreated (grows in size).
The error happens instantly when I try to start service.
The error takes some time when I start service with database recreate registry enabled, it goes to around 75% when starting service and then stops with error 1067.

Before I applied fixes, every time I tried to restart service, the log would end with:

Code: Select all

2017-08-28 16:18:54.85 spid9s      Starting up database 'tempdb'.
2017-08-28 16:18:54.96 spid16s     The Service Broker endpoint is in disabled or stopped state.
2017-08-28 16:18:54.96 spid16s     The Database Mirroring endpoint is in disabled or stopped state.

I will appreciate any help with this mystery. The PC is in production, so I can't even reboot it without some planning, just something to keep in mind, but if fix requires a reboot, will do my best to reboot it.

Full fresh error.log that was generated a minute ago when I tried to start service:

Code: Select all

2017-08-30 12:10:02.64 Server      Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
May 14 2014 18:34:29 
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586: )

2017-08-30 12:10:02.64 Server      (c) Microsoft Corporation.
2017-08-30 12:10:02.64 Server      All rights reserved.
2017-08-30 12:10:02.64 Server      Server process ID is 7796.
2017-08-30 12:10:02.64 Server      System Manufacturer: 'Dell Inc.', System Model: 'Precision Tower 3620'.
2017-08-30 12:10:02.64 Server      Authentication mode is MIXED.
2017-08-30 12:10:02.64 Server      Logging SQL Server messages in file 'C:\WINDOWS\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\error.log'.
2017-08-30 12:10:02.64 Server      The service account is 'HWI\1YRXTB2$'. This is an informational message; no user action is required.
2017-08-30 12:10:02.64 Server      Command Line Startup Parameters:
 -c
 -S "MSSQL11E.LOCALDB"
 -s "LOCALDB#5BC306D8"
 -d "C:\WINDOWS\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\master.mdf"
 -l "C:\WINDOWS\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\mastlog.ldf"
 -e "C:\WINDOWS\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\error.log"
2017-08-30 12:10:02.75 Server      SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2017-08-30 12:10:02.75 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2017-08-30 12:10:02.75 Server      Detected 3954 MB of RAM. This is an informational message; no user action is required.
2017-08-30 12:10:02.75 Server      Using conventional memory in the memory manager.
2017-08-30 12:10:02.85 Server      Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2017-08-30 12:10:02.86 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2017-08-30 12:10:02.88 Server      Software Usage Metrics is disabled.
2017-08-30 12:10:02.88 spid4s      Starting up database 'master'.
2017-08-30 12:10:02.93 spid4s      73 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2017-08-30 12:10:02.94 spid4s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2017-08-30 12:10:02.94 spid4s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2017-08-30 12:10:02.96 Server      CLR version v4.0.30319 loaded.
2017-08-30 12:10:02.98 spid4s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2017-08-30 12:10:02.98 spid4s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
2017-08-30 12:10:03.00 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
2017-08-30 12:10:03.00 spid4s      SQL Trace ID 1 was started by login "sa".
2017-08-30 12:10:03.01 spid4s      Server name is '1YRXTB2\LOCALDB#5BC306D8'. This is an informational message only. No user action is required.
2017-08-30 12:10:03.01 spid11s     Server local connection provider is ready to accept connection on [ \\.\pipe\LOCALDB#5BC306D8\tsql\query ].
2017-08-30 12:10:03.01 spid11s     Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.
2017-08-30 12:10:03.01 spid11s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2017-08-30 12:10:03.01 spid4s      Failed to verify Authenticode signature on DLL 'C:\Program Files\Microsoft SQL Server\110\LocalDB\Binn\\ftimport.dll'.
2017-08-30 12:10:03.01 spid9s      Starting up database 'mssqlsystemresource'.
2017-08-30 12:10:03.02 spid9s      The resource database build version is 11.00.5058. This is an informational message only. No user action is required.
2017-08-30 12:10:03.02 spid15s     Starting up database 'VeeamBackup'.
2017-08-30 12:10:03.02 spid14s     Starting up database 'msdb'.
2017-08-30 12:10:03.04 spid9s      Starting up database 'model'.
2017-08-30 12:10:03.05 spid14s     2 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.06 spid14s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.06 spid14s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2017-08-30 12:10:03.06 spid9s      1 transactions rolled forward in database 'model' (3:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.06 spid9s      0 transactions rolled back in database 'model' (3:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.06 spid9s      Recovery is writing a checkpoint in database 'model' (3). This is an informational message only. No user action is required.
2017-08-30 12:10:03.07 spid9s      Clearing tempdb database.
2017-08-30 12:10:03.07 spid15s     Recovery of database 'VeeamBackup' (5) is 0% complete (approximately 30 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2017-08-30 12:10:03.12 spid15s     Recovery of database 'VeeamBackup' (5) is 0% complete (approximately 19 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.
2017-08-30 12:10:03.12 spid15s     Recovery of database 'VeeamBackup' (5) is 0% complete (approximately 19 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2017-08-30 12:10:03.12 spid15s     Recovery of database 'VeeamBackup' (5) is 4% complete (approximately 1 seconds remain). Phase 2 of 3. This is an informational message only. No user action is required.
2017-08-30 12:10:03.18 spid9s      Starting up database 'tempdb'.
2017-08-30 12:10:03.21 spid15s     262 transactions rolled forward in database 'VeeamBackup' (5:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.22 spid15s     0 transactions rolled back in database 'VeeamBackup' (5:0). This is an informational message only. No user action is required.
2017-08-30 12:10:03.22 spid15s     Recovery is writing a checkpoint in database 'VeeamBackup' (5). This is an informational message only. No user action is required.
2017-08-30 12:10:03.33 spid16s     The Service Broker endpoint is in disabled or stopped state.
2017-08-30 12:10:03.33 spid16s     The Database Mirroring endpoint is in disabled or stopped state.
2017-08-30 12:10:03.33 spid16s     Service Broker manager has started.
2017-08-30 12:10:03.35 spid4s      Recovery is complete. This is an informational message only. No user action is required.

[Vitaliy S.]

Hi Raimonds,

Do you have a support case opened for this issue? If yes, then what's the ID?

Thanks!

[raymix]

Hi Vitaly

I'm afraid I am not a paying customer.
I'll seek help elsewhere.

Thank you

[Dima P.]

Hi Raimonds,

Try latest Veeam Agent for Windows 2.0 instead of 1.5

I am not a paying customer.

We provide free (best effort support) for this product so you are authorized to open a case directly from UI (Control Panel > Support > Technical Support requires email address registration).

[raymix]

Hi Dima

Thank you so much for the reply, you're right on the spot as usual. Sorry about skipping on support case ID, I thought it was only for registered paid customers only.

I've uninstalled all 3 Local DB (SQL) applications and Veeam.
Deleted MDF and LDF files
deleted Microsoft localdB folder under system32\config\profile\...
Installed Veeam 2.0 and it worked right away, no reboot required.

Thank you

[Dima P.]

Raimonds,

Thanks for the heads up and glad you nailed it!