Installation fails (SQLLocalDB)

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

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Tue Dec 23, 2014 5:03 pm

ender,
Just to clarify, you tried to remove the Endpoint loacldb instance via PSTools, right?
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby ender » Tue Dec 23, 2014 6:10 pm

Yes. It was removed successfully, but after restart the install failed in the same way (if I tried reinstalling without restarting first, the installer failed sooner, and did a rollback).
ender
Novice
 
Posts: 3
Liked: never
Joined: Tue Dec 23, 2014 10:50 am

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Tue Dec 23, 2014 9:22 pm

Got it, thanks for the heads up - forwarding back to QA. Let you know the results as soon as possible.
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Wed Dec 24, 2014 11:35 am

Hello ender,
According to QA the issue you faced is related to the installation of the .NET Framework and it’s not similar to the OP problem. Could you please provide us the full setup logs (C:\ProgramData\Veeam) and Windows Event logs (Custom View > Administrative events)? You can upload it to dropbox or onedrive and send me PM with the download link. Thank you in advance.
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby Regnor » Mon Jan 05, 2015 9:41 am 1 person likes this post

d.popov wrote:Hello Max,
I am sorry for taking so long to respond. We reviewed the application list you've sent and it seems none of these could lock the local db. What you can try to do is manually delete the endpoint instance and re install the Veeam Endpoint from scratch. Here is an instruction:

- Before you go ,please, double check you have the Microsoft SQL Server 2012 Express LocalDB
- Check Veeam Endpoint Backup is not listed in the ‘Programs and Features’ If yes – uninstall it
- Download PSTools: http://download.sysinternals.com/files/PSTools.zip
- Install it. (for ease of use it could be unpacked to C:\PSTools\)
- Go to Run > cmd as administrator
- cd C:\PSTools (or the folder you used for during unpacking)
- Run PsExec.exe –i –s cmd.exe (the user agreement message may pop up )
- New command line would appear. Make sure its running under nt authority\system by running whoami
- In the new command prompt type in “C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe” delete VeeamEndPoint (with quotes)
- If you see the message “LocalBD instance “VeeamEndPoint” deleted” then you can procceed to the new Veeam Endpoint Installation.

Let me know if that works. Thank you.


Hello Dima,

it worked :)
I have deleted the LocalDB and after that could successfully install VEB.
I also already created a backup and restored it baremetal without any problems :)
Regnor
Veeam ProPartner
 
Posts: 101
Liked: 21 times
Joined: Mon Jan 31, 2011 11:17 am

Re: Installation fails (SQLLocalDB)

Veeam Logoby Mike Resseler » Mon Jan 05, 2015 9:55 am

Regnor,

Thanks a lot for letting us know! Enjoy "playing" ;-) with VEB and keep us informed

cheers

Mike
Mike Resseler
Veeam Software
 
Posts: 3498
Liked: 390 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Mon Jan 05, 2015 1:57 pm

Hi Max,
Thanks for the heads up – now we have a confirmed resolution. Kudos to our QA team and again big thanks to your for testing.
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby Regnor » Mon Jan 05, 2015 5:59 pm

d.popov wrote:Hi Max,
Thanks for the heads up – now we have a confirmed resolution. Kudos to our QA team and again big thanks to your for testing.

Also give the QA team a big thank you from me
Regnor
Veeam ProPartner
 
Posts: 101
Liked: 21 times
Joined: Mon Jan 31, 2011 11:17 am

Re: Installation fails (SQLLocalDB)

Veeam Logoby tallpr24 » Mon Jan 19, 2015 4:40 pm

Hi, im having the same issue, except that when i run the command to remove db, its sayd db not found (probably removed when i did the veeam endpoint uninstall). i have uninstalled everything including ms sql applications, but yet , when i try to re installe veeam endpoint backup its still gets stuck on starting services.

any help would be greatly appreciate it.
"Life would be so much easier if we only had the source code."
tallpr24
Influencer
 
Posts: 11
Liked: never
Joined: Thu Dec 11, 2014 7:23 pm
Full Name: kenneth santiago

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Mon Jan 19, 2015 8:40 pm

Kenneth,
Just to clarify – you used the described solution via PS tools? In addition, we received several cases with antivirus blocking the setup – so any scanner installed in your environment?

Please, share the full setup logs C:\ProgramData\Veeam and Windows Event logs Custom View > Administrative events via any suitable cloud storage (Dropbox/OneDrive/Google Drive)? Thank you
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Tue Jan 20, 2015 5:08 pm

Guys,
We have prepared the following instructions for anyone who faced the installation issues. It’s kinda massive’ so we’ve spliced it into two cases.
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby Dima P. » Tue Jan 20, 2015 5:10 pm 1 person likes this post

Please note: this solution is considered to be obsolete

Errors:
Code: Select all
Error occurred during LocalDB instance startup: SQL Server process failed to start

Veeam.Backup.Common.CSqlException: Microsoft SQL server hosting the configuration database is currently unavailable. Possible reasons are heavy load, networking issue, server reboot, or hot backup.
Please wait, and try again later.


Preparation:

1. Before you go, check:
- Your antivirus is not blocking the installation process.
- Microsoft SQL Server 2012 Express LocalDB is installed. If you have any installation issues - the best option is to install the version included in the setup
- SYSTEM accout has full access permissions to systemprofile folder C:\Windows\System32\config\systemprofile

2. Download, install and open PS Tools:
- Download PSTools: http://download.sysinternals.com/files/PSTools.zip
- Install it, for ease of use it could be unpacked to C:\PSTools\
- Go to Run > cmd as administrator
- cd C:\PSTools (or the folder you used for during unpacking)
- Run PsExec.exe –i –s cmd.exe (accept the user agreement message may pop up )
3. Uninstall Veeam Endpoint Backup BETA via Control Panel > Programs and Features


Resolutions:

Case A: Instance was corrupted during setup and must be deleted:

1. Download, install and open PS Tools like described in preparation step 2
2. Delete corrupted instance by typing the following commands in PS Tools command prompt:

Code: Select all
whoami
//Response nt authority\system
 “C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe” delete VeeamEndPoint
//Response: “LocalBD instance “VeeamEndPoint” deleted”

3. Reboot and to install Veeam Endpoint Backup.

Case B: The Case A solution did not help. Instance creation continues to fail during Endpoint setup.

1. Install the following components (reboot if required for each component):
- Microsoft System CLR Types for SQL Server 2012 (is included in Endpoint setup)
- Microsoft SQL Server 2012 Management Objects (is included in Endpoint setup)
- Microsoft SQL Server 2012 Express LocalBD (is included in Endpoint setup)
- Microsoft SQL Server 2012 Native Client
- Microsoft SQL Server 2012 Command Line Utilities

2. Add the following string values for SQL instance login/password in the registry via regedit.exe
Code: Select all
 HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Endpoint Backup
//the following string values generated by QA
"SqlLogin"="VeeamLogin"
"SqlPassword"="75f00cdb-d8db-45ab-8024-8cc576df15b1"

3. Download, install and open PS Tools like described in preparation step 2
4. Re create the instance by typing the following commands in PS Tools command prompt:
Code: Select all
 whoami
//Response nt authority\system
 “C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe” delete VeeamEndPoint
//Response: “LocalBD instance “VeeamEndPoint” deleted”
SqlLocalDB create VeeamEndPoint
//Response: “LocalBD instance “VeeamEndPoint” created with version 11.0.”
SqlLocalDB start VeeamEndPoint
//Response: “LocalBD instance “VeeamEndPoint” started”
SqlLocalDB info VeeamEndPoint
//Response example (12345678 is an example – you will have other output): “Instance pipe name: np:\\.\pipe\LOCALDB#12345678\tsql\query”
//Copy np:\\.\pipe\LOCALDB#12345678\tsql\query from the previous query
sqlcmd -S np:\\.\pipe\LOCALDB#12345678\tsql\query
// Command prompt cursor will change to 1>
// Type in each line and hit enter one by one
USE [master]
GO
CREATE LOGIN [VeeamLogin] WITH PASSWORD=N'75f00cdb-d8db-45ab-8024-8cc576df15b1', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'VeeamLogin', @rolename = N'sysadmin'
GO
EXIT
// Command prompt cursor revert back to normal
SqlLocalDB stop VeeamEndPoint
// Response “LocalBD instance “VeeamEndPoint” stopped”


Additionally:
- Microsoft SQL Server 2012 Native Client and Microsoft SQL Server 2012 Command Line Utilities can be found here: http://www.microsoft.com/en-US/download ... x?id=29065

If the LocalDB and sqlcmd fail:
During LocalDB and sqlcmd installation path variables are automatically pushed into the system. If SqlLocalDB or sqlcmd commands fail, you may need to type a full path instead:
- SqlLocalDB should be replaced by “%Program Files%\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe” (with quotes)
- sqlcmd should be replaced by “%Program Files%\Microsoft SQL Server\110\Tools\Binn\SqlCmd.exe” (with quotes)

Still having installation issues?
Collect and share:
- 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)
- Pack and send it via any available cloud storage (Dropbox/Google Drive/OneDrive etc)
- Ping me via PM or posting to this thread
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Installation fails (SQLLocalDB)

Veeam Logoby john_miee » Sat Feb 07, 2015 9:00 am

Hi!
I have a similar problem.
All that described above - did not help me. Can you help me?
My system: Windows 7 -x64 (RUS)
Version of Veeam endpoint beta:8.0.0.1822
john_miee
Lurker
 
Posts: 1
Liked: never
Joined: Sat Feb 07, 2015 8:49 am
Full Name: John

Veeam EndPoint install fails on Windows 8.1 Laptop

Veeam Logoby jkpete » Sun Feb 08, 2015 6:15 pm

I recently installed and setup Veeam EndPoint on my Windows 7 PC with no problems. But we have a new Windows 8.1 Laptop that the install fails. The only Antivirus that was running was Windows Defender but I disabled that.

I am running the install from an account with Administrator permissions.
The Install seems to install the DB just fine but fails at the point when it tries to start the EndPoint Service. "Veeam.Setup.Wizard has stopped". If I continue beyond this point and try to start the "Veeam EndPoint Backup" and start the gui/Control Panel I get an error "Veeam.EndPoint.Tray has stopped working". I can't get the gui to stay up.

The "Create Recovery Media" seems to start fine
The "Volume restore" gui seems to start fine
The FLR gui doesn't start
The "Configure Backup"gui doesn't start

If I go into services I can see the The EndPoint Backup service is running. If I manually stop it I can actually start the gui but if it says that the service has failed....once I start the service again the Gui fails and reports the error "Veeam.EndPoint.Tray has stopped working"


Any help would be greatly appreciated.

Thanks
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. » Mon Feb 09, 2015 8:48 pm

John,
Awaiting for the logs from you via PM.

Jeff,
Have you tried the solution described above? If you sill have the installation issues please follow the Still having installation issues? procedure and send me a log package via PM.
Dima P.
Veeam Software
 
Posts: 6743
Liked: 482 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

PreviousNext

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 1 guest