Installation fails (SQLLocalDB)

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

Re: Installation fails (SQLLocalDB)

Veeam Logoby jkpete » Wed Feb 11, 2015 10:22 pm

Haven't yet. will be trying tonight.
jkpete
Lurker
 
Posts: 2
Liked: never
Joined: Sun Feb 08, 2015 4:43 am
Full Name: Jeff

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Thu Feb 12, 2015 10:21 pm

Jeff,
Thanks. Awaiting for your reply.
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Install Error"Exception has been thrown by the target of an"

Veeam Logoby mbaumli » Fri Feb 13, 2015 5:42 pm

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.
mbaumli
Lurker
 
Posts: 1
Liked: never
Joined: Thu Feb 12, 2015 8:07 pm
Full Name: Michael Baumli

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Fri Feb 13, 2015 10:30 pm

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).
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Mon Feb 16, 2015 11:23 am

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
massimiliano.rizzi
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Mon Feb 16, 2015 1:54 pm

Massimiliano,
Thanks for providing the logs. Will investigate and follow up shortly.
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Mon Feb 16, 2015 2:12 pm

d.popov wrote: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
massimiliano.rizzi
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Mon Feb 16, 2015 5:24 pm

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.
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Tue Feb 17, 2015 8:25 am

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
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Tue Feb 17, 2015 6:06 pm

Dmitry,

sorry for the delay.

Please find below all relevant screenshots:

==================================================
Image
Image
==================================================

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
massimiliano.rizzi
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Tue Feb 17, 2015 6:17 pm

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 :wink:
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Wed Feb 18, 2015 11:05 am

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:

==================================================
Image
==================================================

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
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Wed Feb 18, 2015 2:01 pm

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:

==================================================
Image
==================================================

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.
massimiliano.rizzi
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Wed Feb 18, 2015 10:49 pm

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.
Dima P.
Veeam Software
 
Posts: 5834
Liked: 417 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby massimiliano.rizzi » Mon Feb 23, 2015 10:54 am

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’:

==================================================
Image
==================================================

Thank you again for your support.

Massimiliano
massimiliano.rizzi
Service Provider
 
Posts: 93
Liked: 10 times
Joined: Tue Jan 24, 2012 7:56 am
Full Name: Massimiliano Rizzi

PreviousNext

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: Google [Bot] and 18 guests