locked
How to sequence MS SQL Server 2012 with app-v 4.6 . RRS feed

  • Question

  • How to sequence  MS SQL Server 2012 with app-v 4.6 .

    N R Raju

    Wednesday, January 2, 2013 5:15 AM

Answers

  •  

    How to Sequence SQL Server 2012 in Microsoft Application Virtualization

    Application Name:  SQL Server 2012   

    Sequencer Version:  App-V 4.5 & App-V 4.6 SP1

    App-V Client Version Tested On: App-V 4.6 SP1

    Operating System Sequenced On: Windows 7 SP1;

    Pre-requisites:

    You must have the following to sequence Visual Studio 2010 for use with Microsoft Application Virtualization:

     A volume license for Visual Studio 2010

     Microsoft Application Virtualization 4.6 SP1 or a later version

     Microsoft .NET Framework 4 Full Profile natively installed on the App-V Sequencer and App-V Clients to which the sequencing will be deployed.

     If you are using Windows 7 or Windows Server 2008 R2, you must use Windows 7 SP1 or Windows Server 2008 R2 SP1 or later on the App-V Sequencer and App-V Clients.

    Client Operating Systems Successfully Deployed To: Windows 7 SP1;

    Steps to Sequence the Application:

    Sequence SQL Server 2012 Client

    Note: Please complete all sequencing steps logged in as a local administrator.

    1. Install Microsoft .NET Framework 4 Full Profile on the Sequencer machine. Using Microsoft Update, install all updates for Windows and .NET Framework.

    2. Make sure that the following update was installed by Microsoft Update on the Sequencer machine. If not, install it manually. 2468871 Update for the .NET Framework 4

    3. On the Tools menu, click Options. Click on the Exclusion Items tab.

    4. Add the following exclusions:

    Exclude Path

    Mapping Type

    %CSIDL_WINDOWS%\Assembly\NativeImages_v4.0.30319_32

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v4.0.30319_64

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v2.0.50727_32

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v2.0.50727_64

    VFS

    \Registry\Machine\SOFTWARE\Microsoft\.NETFramework\v2.0.50727\NGENService\Roots

    VRG

    \Registry\Machine\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v2.0.50727\NGENService\Roots

    VRG

    \REGISTRY\MACHINE\Software\Microsoft\Fusion

    VRG

    For Windows XP and Windows Server 2003, also add the following exclusions:

    Exclude Path

    Mapping Type

    %CSIDL_WINDOWS%\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices

    VFS

    %CSIDL_WINDOWS%\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices

    VFS

    5. On the File menu, click Save As Template… to save these exclusions as a project template.

    6. On the File menu, click New from Template… to start sequencing using the newly created template.

    7. Complete the initial pages of the New Package Wizard.

    8. Start monitoring the installation.

    9. Install SQL Server 2012:

    a. Be sure to specify the install location as Q:\SQL2012.

    b. Install SQL Server 2012 (Select Client components) Only.

    On the App-V Client

    Be sure to complete the following steps on all App-V Clients to which the sequencing will be deployed.

    1. Install Microsoft .NET Framework 4 Full Profile. Using Microsoft Update, install all updates for Windows and .NET Framework.

    2. Make sure that the following update was installed by Microsoft Update. If not, install it manually. 2468871 Update for the .NET Framework 4

    3. Run services.msc and disable the Windows Presentation Foundation Font Cache service.

    Note: I have launched the Sql Server 2012 (Client components)

    Sequenced package in on WIN7 ENT System Without any Errors.


    N R Raju

    Tuesday, January 8, 2013 11:20 AM

All replies

  • Hello,

    I suggest you read the App-V Whitepaper for App-V 4.6 - the sequence guide. There is a section that deals with limitations - it explains why somethings can not be done. Several of those apply to MS SQL Server 2012

    Available here;

    http://www.microsoft.com/en-us/download/details.aspx?id=27760

    If you ask a similiar question in the future, I also suggest that you share the following (as opposed to ask a one-liner without a question mark);

    -Why are you attempting todo something

    -With as much detail as possible, how have you attempted todo something

    -What possible behaviors have you experienced while you performed your specific steps as.


    Nicke Källén | The Knack| Twitter: @Znackattack

    Wednesday, January 2, 2013 6:33 AM
  •  

    How to Sequence SQL Server 2012 in Microsoft Application Virtualization

    Application Name:  SQL Server 2012   

    Sequencer Version:  App-V 4.5 & App-V 4.6 SP1

    App-V Client Version Tested On: App-V 4.6 SP1

    Operating System Sequenced On: Windows 7 SP1;

    Pre-requisites:

    You must have the following to sequence Visual Studio 2010 for use with Microsoft Application Virtualization:

     A volume license for Visual Studio 2010

     Microsoft Application Virtualization 4.6 SP1 or a later version

     Microsoft .NET Framework 4 Full Profile natively installed on the App-V Sequencer and App-V Clients to which the sequencing will be deployed.

     If you are using Windows 7 or Windows Server 2008 R2, you must use Windows 7 SP1 or Windows Server 2008 R2 SP1 or later on the App-V Sequencer and App-V Clients.

    Client Operating Systems Successfully Deployed To: Windows 7 SP1;

    Steps to Sequence the Application:

    Sequence SQL Server 2012 Client

    Note: Please complete all sequencing steps logged in as a local administrator.

    1. Install Microsoft .NET Framework 4 Full Profile on the Sequencer machine. Using Microsoft Update, install all updates for Windows and .NET Framework.

    2. Make sure that the following update was installed by Microsoft Update on the Sequencer machine. If not, install it manually. 2468871 Update for the .NET Framework 4

    3. On the Tools menu, click Options. Click on the Exclusion Items tab.

    4. Add the following exclusions:

    Exclude Path

    Mapping Type

    %CSIDL_WINDOWS%\Assembly\NativeImages_v4.0.30319_32

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v4.0.30319_64

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v2.0.50727_32

    VFS

    %CSIDL_WINDOWS%\Assembly\NativeImages_v2.0.50727_64

    VFS

    \Registry\Machine\SOFTWARE\Microsoft\.NETFramework\v2.0.50727\NGENService\Roots

    VRG

    \Registry\Machine\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v2.0.50727\NGENService\Roots

    VRG

    \REGISTRY\MACHINE\Software\Microsoft\Fusion

    VRG

    For Windows XP and Windows Server 2003, also add the following exclusions:

    Exclude Path

    Mapping Type

    %CSIDL_WINDOWS%\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices

    VFS

    %CSIDL_WINDOWS%\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices

    VFS

    5. On the File menu, click Save As Template… to save these exclusions as a project template.

    6. On the File menu, click New from Template… to start sequencing using the newly created template.

    7. Complete the initial pages of the New Package Wizard.

    8. Start monitoring the installation.

    9. Install SQL Server 2012:

    a. Be sure to specify the install location as Q:\SQL2012.

    b. Install SQL Server 2012 (Select Client components) Only.

    On the App-V Client

    Be sure to complete the following steps on all App-V Clients to which the sequencing will be deployed.

    1. Install Microsoft .NET Framework 4 Full Profile. Using Microsoft Update, install all updates for Windows and .NET Framework.

    2. Make sure that the following update was installed by Microsoft Update. If not, install it manually. 2468871 Update for the .NET Framework 4

    3. Run services.msc and disable the Windows Presentation Foundation Font Cache service.

    Note: I have launched the Sql Server 2012 (Client components)

    Sequenced package in on WIN7 ENT System Without any Errors.


    N R Raju

    Tuesday, January 8, 2013 11:20 AM
  • MS SQL Server application is not a good candidate for sequencing.
    • Proposed as answer by Sh1va Monday, February 11, 2013 9:39 PM
    Tuesday, January 8, 2013 1:43 PM
  • Hi,

     Have you sequenced SQL Server 2008 R2 on Appv 5.0?

    Sh1va.

    Monday, February 11, 2013 9:40 PM