A Complete Guide to SQL 2008 App-V Database Migration

Hi everyone, John Behneman here.  The purpose of this article is to outline the steps necessary to migrate or move a Microsoft Application Virtualization (App-V) Database from one SQL server 200X to SQL server 2008 R2. This article assumes that the App-V database name stays the same on the source and destination database servers although…

4

App-V database jobs fail with error – “Executed as user dbo. The server principal “sa” is not able to access the database under the current security context. [SQL State 08004] error 916”.

Here’s one more KB article we just published today. This one talks about an issue where App-V database jobs fail if you have the wrong DB selected I the SQL Server Jobs configuration: ===== Symptoms The App-V Management Server installation creates database jobs in the SQL jobs section. When one of the database jobs is…

1

Pre-creation of Server objects may yield certain sub-optimal values in the App-V SQL Database

Often, App-V administrators will leverage multiple App-V Management Servers sharing a common database. The process usually involves pointing additional server to the existing SQL server and database during installation. Key databases values that govern server behavior will be stored in the DBO.SERVERS and DBO.SOFTGRID_SERVERS tables. These settings can also be configured using the App-V Server…

1