Upgrading app-v 4.5 sp1 to sp2

[fulminemizzega]

Hi all,
I'm trying to install app-v 4.5 on windows server 2008 r2, but when I try to install the sp2 update, it fails installing because of a 25109 error. I installed app-v 4.5 sp1 from mdop 2010, and it worked fine with the default application on a client. When I try to install the sp2, there's something that goes wrong with the SQL server, which is on the same machine. I've found in the installer log that the installer tries to logon to the SQL server with the NETWORK SERVICE account, and it fails. The SQL server is configured to use Windows authentication, but the administrator is the Administrator account in my domain, not NETWORK SERVICE. NETWORK SERVICE is the user who runs the Application Virtualization Management Server service. Is there anyway to tell the MSI to use another user and password to access the database? I'm using SQL 2008 R2 Express.
That is a part of the SoftGrid-server-setup.txt that I think is important:

Code: Select all

[2010-08-01 00:23:04] (3844:5588) SQL state: ``42000'', Native: 15401, Text: ``[Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'NT AUTHORITY\NETWORK SERVICE' not found. Check the name again.''.
[2010-08-01 00:23:04] (3844:5588) ::SQLExecute error 0xffffffff.
[2010-08-01 00:23:04] (3844:5588) Failed to execute SQL ``exec sp_grantlogin ?''.
[2010-08-01 00:23:04] (3844:5588) Failed to create login ``NT AUTHORITY\NETWORK SERVICE''.]

Anyone has an idea? I've been searching a lot for this error during the upgrade, but I found nothing... maybe I didn't make a good research.

Thanks in advance for the help and sorry for my bad english.

[aaronparker]

Ensure the computer account has been given dbo (or at least dbread and dbwrite) access to the database. Add the account in the form of DOMAIN\COMPUTERNAME$ if it does not already exist.

[fulminemizzega]

Which account needs access to the database? The <domain>\Administrator (user that is trying to install the sp2) or the <domain>\Network Service?
It seems like the installer is using the Network Service to access the SQL server... the domain Administrator should already have full permissions on the db, I already used it for app-v 4.5 sp1 installation.

[aaronparker]

During installation the account performing the install must have SQL sysadmin. If SQL Server is on the same server as the App-V Management Server, then NT AUTHORITY\NETWORK SERVICE requires the SFTUser and SFTEveryone roles in the database, otherwise grant DOMAIN\COMPUTERNAME$ instead.

The best source of this information is this white paper: http://download.microsoft.com/download/ ... pting.docx

[fulminemizzega]

Thanks aaronparker, I successfully installed the service pack 2. There was some mess because of the mui I was using on the server... It translated the name of NETWORK SERVICE user, this caused the error 25109.
But now there is another error: no published application launch. The DefaultApp is not loading, even if with app-v 4.5 sp1 it worked; I also tried to import a sequenced app but not even it launched. On the client I've installed app-v client 4.6 for Desktop, not RDS (Terminal Services).
When I try to launch the default app, it returns this error:

Code: Select all

The Application Virtualization Client could not launch DefaultApp MFC Application 1.0.0.1.

The Application Virtualization Server has returned an Internal System error. Report the following error code to your System Administrator.

Error code: 4605F3-1690140A-200001F4

In the Server log there are some of this entries:

Code: Select all

[2010-08-08 20:52:53.743] SRV2K8R2 4804 4168 SW_VersionedPackage::ValidateSFTFile - "Default Provider" Administrator DefaultApp.sft 3 42004 "The package GUID in the datastore (4f361562-d469-41d8-b6ef-d50538fdb202) is different from the package GUID in the package file in the content directory (4b7d9aa0-c7b2-4ea2-8d30-570b52e30f25).

I also tried to import a sequenced app (Word Viewer 2007), but it doesn't launch; in the server there are no log entries about it, in the client log there is this:

Code: Select all

The Application Virtualization Client could not launch Microsoft Office Word Viewer 2007.

The specified Application Virtualization Server could not be accessed. Try again in a few minutes. If the problem persists, report the following error code to your System Administrator.

Error code: 4605F3-19D02E0A-10000002

What's wrong now? I don't know where I may have made a mistake, I just installed an update (that should simply work...)
Also I removed the server part, switched the system language to english, and reinstalled everything, with the same results...

Still, thanks for your help.

[aaronparker]

Is the location of the content share in the servers' registry correct? - check HKLM\Software\Microsoft\SoftGrid\4.5\Server or HKLM\SoftwareWow6432Node\Microsoft\SoftGrid\4.5\Server.

Also check that the computer account for the server has access to the content share location.

[fulminemizzega]

In HKLM\SoftwareWow6432Node\Microsoft\SoftGrid\4.5\Server there's this reg_sz: SOFTGRID_CONTENT_DIR = C:\Program Files (x86)\Microsoft System Center App Virt Management Server\App Virt Management Server\content\
In the log of the defaultapp it seems that the client reaches the content directory... anyway, the user on the server and on the client is Administrator, the content share is setted that everyone can read it, and Domain Admins can also modify it.

[fulminemizzega]

Anyone has an idea?

[fulminemizzega]

I finally had one!
I've tried really useless to fix my problem after the update... It was everything in the log, and I continued to do the same thing... I tried to modify the default app's guid in the sql database, but I couldn't modify all the values. So, I modified the guid in the OSD file, but I got another error on the client (like the application didn't exist). Tonight, at the end, I've got that stupid idea... delete the default app, and then re-import it, after modifying the guid in the OSD... Now it works, thanks aaronparker for your help in the installation of the update.
Because of my exagerated happyness, I reinstalled everything: Server OS, virtual machines (but with vmware this time), SQL server, Roles...; but after the SP2 update I've had to re-import the default app... So, now I've a question... Maybe I didn't read some fundamental instructions after installing the SP2? Is it normal that after an update reimporting the default app (and modifying it's OSD) is needed?
Still thanks for your help... It was more than a week that I could not launch the default app...
PS: I think that I didn't sequence well the Word Reader... so, it is not a problem now, I'll try better next time

[fulminemizzega]

Solved also the problem with the sequenced app... everything working right now (I think), but no one knows some thing about this?

So, now I've a question... Maybe I didn't read some fundamental instructions after installing the SP2? Is it normal that after an update reimporting the default app (and modifying it's OSD) is needed?

[jur]

It is not only the reference to the server you needed to change? It defaults to the hostname where you perform the server installation. I didn't check if SP2 comes with a new Default App.

[fulminemizzega]

When I installed app-v, I changed the reference to my server (I'm not using certificates, so I also needed to change the port to 554).
When I installed the SP2, I needed to change the GUID in the OSD of the default app. Since the guid is different, I think that the SP2 may come with a new Default App... but the version is the same...