Installation fails (SQLLocalDB)

[jkpete]

Haven't yet. will be trying tonight.

[Dima P.]

Jeff,
Thanks. Awaiting for your reply.

[mbaumli]

I am getting an installation error on clicking "An error has occurred: Exception has been thrown by the target of an invocation.

There is another more detailed screen which gives additional information, but the error is rather lengthy

But the log shows this:
Windows Installer installed the product. Product Name: Veeam Endpoint Backup BETA. Product Version: 8.0.0.1822. Product Language: 1033. Manufacturer: Veeam Software AG. Installation success or error status: 0.

I would log a support case, but this is a "free" beta product and assumed that there was no support for this product. If this is wrong, please let me know.

[Dima P.]

Hello Michael,
You are welcome to submit a support case. I am tracking the similar issues in this thread, kindly, please take a look at this post. In addition, to the described procedure please check that SYSTEM account has full access permissions to systemprofile folder (C:\Windows\System32\config\systemprofile).

[massimiliano.rizzi]

Hello Dmitry,

I recently tried to install Veeam Endpoint Backup on a HP MicroServer ProLiant Gen8 running Windows Server 2012 Essentials and I think I am having a similar problem with Microsoft SQL Server 2012 Express LocalDB installation/configuration.

Since the problem is on a server, may I kindly ask the support team to review the logs before I go ahead and attempt to perform the instructions you have prepared for anyone who faced installation issues.

I have collected and shared all relevant logs and I am sending you the link via PM.

Thank you in advance for your support.

Massimiliano

[Dima P.]

Massimiliano,
Thanks for providing the logs. Will investigate and follow up shortly.

[massimiliano.rizzi]

Massimiliano,
Thanks for providing the logs. Will investigate and follow up shortly.

Hello Dmitry,

thank you for your follow-up.

Looking forward to hearing from you.

Thank you again for your support.

Massimiliano

[Dima P.]

Massimiliano,
Can I ask you to do the following:

- Download and install Microsoft® SQL Server® 2008 Management Studio Express
- Check HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup for the following values: SqlInstancePipeName and SqlLogin / SqlPassword
- Try to open Endpoint database via Management Studio with SqlInstancePipeName as a server name, SqlLogin / SqlPassword as login and password using SQL authentication.
- Check Under Security > Logins what accounts are listed

Send me a screenshot of exising accounts via this post or PM. Thank you.

[massimiliano.rizzi]

Hi Dmitry,

thank you for your reply.

I will perform the steps above and let you known the result as soon as possible.

Regards,
Massimiliano

[massimiliano.rizzi]

Dmitry,

sorry for the delay.

Please find below all relevant screenshots:

==================================================


==================================================

Management Studio seems not to be able to connect to LocalDB from within this HP MicroServer ProLiant Gen8 running Windows Server 2012 Essentials. The same procedure works from within another server.

Thanks and Regards,
Massimiliano

[Dima P.]

Massimiliano,

Anything from TrendMicro installed on your machine? Could you shut it down and then reinstall the product – its #1 troubleshooting step from the guide above

[massimiliano.rizzi]

Hi Dmitry,

thank you for reply.

I confirm Trend Micro Worry-Free Business Security Services is installed on this machine. I have to say that I have successfully installed Veeam Endpoint Backup on a number of Microsoft Windows 7 SP1 64-bit endpoints and they are all running Trend Micro Worry-Free Business Security Services.

As part of #1 troubleshooting step from the guide above, I have just unloaded the Worry-Free Business Security Agent using the “Security Agent Uninstall Tool” (a tool Trend Micro provides to manually unload and/or uninstall their Agent).

I have not yet tried to reinstall Veeam Endpoint Backup because Management Studio is not able to connect to the LocalDB instance even after unloading the Worry-Free Business Security Agent, so I doubt Veeam Endpoint Backup will install successfully if the product cannot connect to the LocalDB instance.

The LocalDB instance itself seems good:

==================================================

==================================================

Unfortunately I am not a SQL guy and I am having a hard time in the attempt to detect what's wrong with the unsuccessful connection to the LocalDB instance.

Thanks and Regards,
Massimiliano

[massimiliano.rizzi]

Dmitry,

as part of trying to connect SSMS 2008 to the LocalDB instance using named pipes, I managed to get the address of the Veeam Endpoint Backup LocalDB instance by running the following commands:

==================================================
1. "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" start VeeamEndPoint
2. "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info VeeamEndPoint
==================================================
Please find below the results:

==================================================
C:\Windows\system32>"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info VeeamEndPoint
Name: VeeamEndPoint
Version: 11.0.2100.60
Shared name:
Owner: NT AUTHORITY\SYSTEM
Auto-create: No
State: Running
Last start time: 18/02/2015 14.15.03
Instance pipe name: np:\\.\pipe\LOCALDB#5055F163\tsql\query
==================================================

The above command returns “np:\\.\pipe\LOCALDB#5055F163\tsql\query” as the instance pipe name, while HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup returns “np:\\.\pipe\LOCALDB#8C5F36B7\tsql\query”.
When I try to open the Endpoint database via Management Studio using the instance pipe name returned in the "SqlLocalDB.exe info VeeamEndPoint" command above I do get a “Login failed” error:

==================================================

==================================================

Based on the results, Case B of the troubleshooting steps from the guide above (delete and re create the instance) should be the way to go.

Looking forward to hearing from you.

Thank you again for your support.

Massimiliano

EDIT: I just realized the portion of the Instance pipe name after LOCALDB# will change each time the instance of LocalDB is started.

[Dima P.]

Massimiliano,

I just realized the portion of the Instance pipe name after LOCALDB# will change each time the instance of LocalDB is started.

My bad, I should have mentioned that every time Endpoint service is restated SQL access credentials and pipe name are changed, but Its reflected in the registry. I’ve noticed that TrendMicro could affect the Endpoint setup and even corrupt the Endpoint database instance but it happens very sporadically.

[massimiliano.rizzi]

Hello Dmitry,

sorry for the delay, I was out of the office for the last couple of days for a training.

I received your PM and performed the following step-by-step instructions:

==================================================
- Uninstalled Endpoint
- Rebooted the machine
- Disabled Trend Micro Worry-Free Business Security Services
- Added to HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup key Name = Recreatedatabase Type = DWORD Value = 1 via regedit.exe
- Started Endpoint setup again
==================================================
I noticed that the pipe name is changed in the registry, however the installation program still fails to start the service ‘Veeam Endpoint Backup service’:

==================================================

==================================================

Thank you again for your support.

Massimiliano

[Dima P.]

Massimiliano,
Thanks for the update. Please send me the fresh portion of troubleshooting logs via PM.

[massimiliano.rizzi]

Massimiliano,
Thanks for the update. Please send me the fresh portion of troubleshooting logs via PM.

Hello Dmitry,

PM sent.

Thanks and Regards,

Massimiliano

[massimiliano.rizzi]

EDIT: I just noticed the message below highlighted from windows event viewer (Custom View > Administrative events), however I don’t know whether it is actually relevant:
==================================================

==================================================

[Dima P.]

Massimiliano,
Thanks - forwarded your logs to QA team. By the way, any chance that the affected machine is in domain with some password GPO (or maybe local policy)?

[massimiliano.rizzi]

Massimiliano,
Thanks - forwarded your logs to QA team. By the way, any chance that the affected machine is in domain with some password GPO (or maybe local policy)?

Dmitry,

sorry for the delay.

Indeed, the affected machine I am trying to install Veeam Endpoint Backup on is running Windows Server 2012 Essentials. It is the domain controller at the root of the forest and domain.

The affected machine is acting as a file server (we have not installed other applications) and all GPOs come out of the box with Windows Server 2012 Essentials without any customizations/additional GPOs.

Is there any particular Group Policy setting I should also look into ?

Thanks and Regards,

Massimiliano

[Dima P.]

Hi Massimiliano,
Thanks for the update! In several cases we have confirmed the generated SQL password to be the root of the issue (as the password does not meet some default GPO requirements). It will be corrected in GA, meanwhile please check the hotfix and solution I've sent you and let me know it helps. Thank you.

[massimiliano.rizzi]

Hi Massimiliano,
Thanks for the update! In several cases we have confirmed the generated SQL password to be the root of the issue (as the password does not meet some default GPO requirements). It will be corrected in GA, meanwhile please check the hotfix and solution I've sent you and let me know it helps. Thank you.

Hello Dmitry,

thank you for your quick reply.

I am attempting to reply via PM to the message containing the hotfix and solution you sent me via PM as well, however my replies get stacked up in the Outbox folder of my User Control Panel. I don’t know whether you’re receiving them.

The х64 bit folder containing the .dll pack also contains a subfolder named “х64” (there also is a subfolder named “х86”). The “х64” subfolder contains two files: “NtfsLib.dll” and “VeeamAgent.exe”. Do I have to grab and copy them as well ?

Thanks and Regards,

Massimiliano

[Dima P.]

Massimiliano,
Yes, all the files should be replaced.

[massimiliano.rizzi]

Massimiliano,
Yes, all the files should be replaced.

Dmitry,

I followed your instructions containing the hotfix and solution you sent me via PM and I confirm everything is ok

Thank you again for your kind support.

Massimiliano

[Dima P.]

Massimiliano,
Awesome! Thank you for your time!

[stoal76]

Can I please have a copy of this hotfix as I am getting the following error when installing Endpoint RC on a Windows 2011 essentials server

Log Name: Application
Source: VeeamEndpointBackupSvc
Date: 10/03/2015 1:01:32 p.m.
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer:
Description:
Service cannot be started. Veeam.Backup.DBCreator.DatabaseException: Unable to connect to SQL Server np:\\.\pipe\LOCALDB#8E61A0D8\tsql\query. Login failed for user 'VeeamLogin'.
at Veeam.Backup.DBCreator.DatabaseConnector.Connect(DatabaseConnectorOptions options)
at Veeam.Backup.DBCreator.DatabaseIsCompatibleTester`1.Test(Exception& error)
at Veeam.Backup.DBCreator.DatabaseIsCompatibleTester`1.Test()
at Veeam.EndPoint.CEndPointServiceImpl.PrepareSqlInstance(DatabaseFile databaseFile)
at Veeam.EndPoint.CEndPointServiceImpl..ctor(CVbOptions options, CTerminationMediator terminator, CExternalEventsWatcher externalEventsWatcher)
at Veeam.EndPoint.EndPointService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

[Vitaliy S.]

Hi Shane, keep in mind that you can get it via our support team (cp.veeam.com) as well. Thanks!

[Dima P.]

Hi Shane,
Just to clarify, you installed the latest RC built (released last Friday) ? Is it possible to share the screenshot of the error you received? Thank you in advance.

[stoal76]

The Veeam RC version that I installed is 1.0.0.1921

Here is a screenshot of the installation error

https://onedrive.live.com/?cid=DEC48D57 ... 128696&v=3

If I run the commands below it looks like the SQL Local DB is not being created in the installation process.

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" start VeeamEndPoint
The specified LocalDB instance does not exist.

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info VeeamEndPoint
Printing of LocalDB instance "VeeamEndPoint" information failed because of the following error:
LocalDB instance "VeeamEndPoint" doesn't exist!

[Dima P.]

Shane,
Thank you! For further troubleshooting could you please collect the following information and share via any available cloud storage with me (send me a download link via PM):

- The full setup logs from C:\ProgramData\Veeam
- Windows Event logs from windows event viewer (Custom View > Administrative events)
- LocalDB error log from %systemroot%\system32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\ (it should look like error.log, error1.log, error2.log etc)