Remove From My Forums

App-V Database in a mirror

Question
0

Sign in to vote

I have set up a database mirror with the APP-V database and it all seems to work well to a point, the databases failover well enough. The management server will continue to connect to the database when I failover the database.

The clients however will only work when the database is on the primary. I have followed all the guides to add the registry setting which adds the failover database. I can't figure out what is going wrong as the clients are pointing at the management server, the management server has the primary SQL box as the primary database with the two registry entries for SQLFailoverServerName and SQLFailoverServerPort which have the failover SQL boxes. But the clients just dont work and I cant figure out why. If anyone else has this working do you have any tips?

Thursday, May 3, 2012 10:28 AM

Answers

1

Sign in to vote
Hello,

See these general guidelines;

http://technet.microsoft.com/en-us/library/ff660790.aspx

http://www.miru.ch/2010/11/app-v-database-mirroring/

http://madvirtualizer.wordpress.com/2011/05/13/app-v-4-5-sp2-server-fails-to-connect-to-failover-database-instance/

Nicke Källén | The Knack| Twitter: @Znackattack
- Proposed as answer by Aaron.ParkerModerator Wednesday, May 9, 2012 10:18 PM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:07 AM
Thursday, May 3, 2012 10:45 AM
1

Sign in to vote
To be clear and not get this wrong I have the following

1 x app-v management server

2 x SQL boxes one primary one mirror

I need to run the setspn as setspn -A MSSQLSvc/sqlcluster01 domain\machinename$ for both of the SQL boxes? I think I have read everything correctly.
- Proposed as answer by Aaron.ParkerModerator Wednesday, May 9, 2012 10:18 PM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:07 AM
Thursday, May 3, 2012 11:55 AM

All replies

1

Sign in to vote
Hello,

See these general guidelines;

http://technet.microsoft.com/en-us/library/ff660790.aspx

http://www.miru.ch/2010/11/app-v-database-mirroring/

http://madvirtualizer.wordpress.com/2011/05/13/app-v-4-5-sp2-server-fails-to-connect-to-failover-database-instance/

Nicke Källén | The Knack| Twitter: @Znackattack
- Proposed as answer by Aaron.ParkerModerator Wednesday, May 9, 2012 10:18 PM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:07 AM
Thursday, May 3, 2012 10:45 AM
0

Sign in to vote

the only thing I havent done is the set spn. Where do I do this and for both of the SQL servers?

Thursday, May 3, 2012 10:58 AM
1

Sign in to vote
Hello,

This is from the first link I posted;

Important

The App-V system uses Kerberos authentication. Therefore, when you configure SQL mirroring where Kerberos Authentication is enabled on the SQL Server and the SQL Server service runs under a domain user account, you must manually configure an SPN. For more information, see “When SQL Service Uses Domain-Based Account” in the article Configuring App-V Administration for a Distributed Environment (http://go.microsoft.com/fwlink/?LinkId=203186).

See this link aswell (I googled; App-V setspn)

http://blogs.platani.nl/?p=900

Nicke Källén | The Knack| Twitter: @Znackattack
- Edited by znack Thursday, May 3, 2012 11:37 AM
Thursday, May 3, 2012 11:36 AM
1

Sign in to vote
To be clear and not get this wrong I have the following

1 x app-v management server

2 x SQL boxes one primary one mirror

I need to run the setspn as setspn -A MSSQLSvc/sqlcluster01 domain\machinename$ for both of the SQL boxes? I think I have read everything correctly.
- Proposed as answer by Aaron.ParkerModerator Wednesday, May 9, 2012 10:18 PM
- Marked as answer by Aaron.ParkerModerator Saturday, November 17, 2012 11:07 AM
Thursday, May 3, 2012 11:55 AM
0

Sign in to vote

Took a semi blind plunge and seems to be working now

Thursday, May 3, 2012 1:10 PM
0

Sign in to vote

You will get a complete overview from this link:

http://my.safaribooksonline.com/book/-/9781849684484/6dot-scaling-up-app-v-implementations/id286788611

Microsoft Application Virtualization Advanced Guide

Wednesday, May 16, 2012 9:18 PM

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Answered by:

App-V Database in a mirror

Question

Answers

All replies