Host-based backup of VMware vSphere VMs.
Post Reply
champ_
Enthusiast
Posts: 26
Liked: never
Joined: Aug 18, 2014 9:20 am
Full Name: Roger
Contact:

All SQL server not showing up

Post by champ_ »

Hello,

When trying to do a application restore of a SQL server I don't see it when I choose Restore - vmware - application item - SQL server. I see a couple of SQL servers but not all SQL servers in the environment. Instead I have to check the box "show all vm (think this was the name)" in order to select the SQL server I want to do a restore from. How come I don't see that server unless I check the box?

Regards

Roger
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: All SQL server not showing up

Post by Vitaliy S. »

Hi Roger,

Did you use application-aware image processing for all SQL Server VMs?

Thanks!
champ_
Enthusiast
Posts: 26
Liked: never
Joined: Aug 18, 2014 9:20 am
Full Name: Roger
Contact:

Re: All SQL server not showing up

Post by champ_ »

Yes, I use application-aware image processing on all the sql servers.

regards
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: All SQL server not showing up

Post by Vitaliy S. »

Thanks, one more quick question to make sure we are on the same page. You're talking about this wizard where you only see a couple of VMs hosting SQL Server, correct?
champ_
Enthusiast
Posts: 26
Liked: never
Joined: Aug 18, 2014 9:20 am
Full Name: Roger
Contact:

Re: All SQL server not showing up

Post by champ_ »

Yes, that's correct.

Regards
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: All SQL server not showing up

Post by Vitaliy S. » 1 person likes this post

Can you confirm that AAIP has no warning messages for the VMs that are missing in that list?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: All SQL server not showing up

Post by veremin » 1 person likes this post

Is there anything specific about SQL servers not showing in the said wizard? Also, are you positive that account used to backup those SQL servers has necessary permissions? In other words, you won't get any issues, if you click "Test credentials" button on "Guest Processing" tab? Thanks.
alanbolte
Veteran
Posts: 635
Liked: 174 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: All SQL server not showing up

Post by alanbolte » 1 person likes this post

You may also need to make sure that the account in question has permissions within MS SQL Server itself and not just the OS; there are some known issues with detecting that kind of permissions issue at the moment so you may not see a warning.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: All SQL server not showing up

Post by Vitaliy S. » 1 person likes this post

And here is the list of permissions required.
champ_
Enthusiast
Posts: 26
Liked: never
Joined: Aug 18, 2014 9:20 am
Full Name: Roger
Contact:

Re: All SQL server not showing up

Post by champ_ »

Hi all,

I guess it has to do with UAC on the vm's....
geraldb
Enthusiast
Posts: 30
Liked: 2 times
Joined: Mar 14, 2012 3:56 pm
Contact:

[MERGED] : sql explorer detects only one instance

Post by geraldb »

Hi all,

yesterday we have updated to version 8 (latest patch).
When we try to restore application items from our database-server with 4 instances (2x SQL2005, SQL2008 R2 and SQL2012) we just see one SQL2005 Instance in the veeam sql explorer.

if we try to restore sql application items from version 7 backups (from the same database-server) we see all (4) instances in the veeam sql explorer ..

is this a bug ?

regards
Gerald
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: All SQL server not showing up

Post by veremin »

Hi, Gerald,

Kindly, check the answers provided above. Usual suspects include AAIP disabled for specific VM and account having insufficient privileges within SQL server.

Thanks.
Post Reply

Who is online

Users browsing this forum: ludsantos, TonioRoffo and 75 guests