Error Installing Connector Server (Error 26002)

Jun 12, 2007 at 5:27 PM
While trying to install the Connector Server component (this will be a 3 server configuration), I receive the following error:

Error 26002. Failed to read IIsWebs table.
(-2147024883 )

Below is the contents of the PS2007-TFSConnectorSetup.log file; please note (if it helps), the Project Server site was configured using host headers, if this matters...Otherwise, all prerequisites for the Connect Server Component have been followed as advised.

Logging started at: 06/12/07 13:20:39

< 13:20:39 >Start PS2007-TFS Connector Setup

< 13:20:39 >CheckIfInstallerRunning

< 13:20:39 >CopyFromMsi

< 13:20:50 >EnumerateSites

< 13:20:50 > Enumerating Web Sites Started
< 13:20:50 > ;Default Web Site
< 13:20:50 > Enumerating Web Sites Completed
< 13:21:19 >CheckPSUriIsValid

< 13:21:19 > CheckUrlFormatIsValid Started
< 13:21:19 > CheckUrlFormatIsValid Completed
< 13:21:19 >CheckSSPUriIsValid

< 13:21:19 > CheckUrlFormatIsValid Started
< 13:21:19 > CheckUrlFormatIsValid Completed
< 13:21:19 >CheckTFSUriIsEmpty

< 13:21:19 > CheckUrlFormatIsValid Started
< 13:21:19 > CheckUrlFormatIsValid Completed
< 13:21:20 >GetWebSitePort

< 13:21:20 > Enumerating Web Sites Port Started
< 13:21:20 > Selected website is Default Web Site
< 13:21:20 > Port for selected website : System.Object[]
< 13:21:28 >CheckServiceUserIsEmpty

< 13:21:28 > CheckEmptyString Started
< 13:21:28 > CheckEmptyString Completed
< 13:21:33 >CheckDatabaseServerIsValid

< 13:21:33 > CheckMachineNameIsValid Started
< 13:21:33 > CheckMachineNameIsValid Completed
< 13:21:33 >GetGUIDForPWAWebSite

< 13:21:33 > Getting Project Web Access Site GUID Started
< 13:21:33 > PWA url : http://<projectserverurl>/PWA
UserName : <domain>\tfsservice
< 13:21:34 > GetUserCredentials started
< 13:21:34 > GetUserCredentials Completed
< 13:21:34 > Getting Project Web Access Site GUID Completed
< 13:21:38 >ConnectorDbInstall

< 13:21:39 > InstallConnectorDatabase Started
< 13:21:39 > Remove both the database if already exist Started
< 13:21:39 > ExecuteCommandLine Started
< 13:21:39 > ExecuteCommandLine Compeleted with ExitCode : 1
< 13:21:39 > Removing Connector Database from <sqlservername>\ server
< 13:21:39 > ExecuteCommandLine Started
< 13:21:39 > ExecuteCommandLine Compeleted with ExitCode : 1
< 13:21:39 > Creating Connector Database
< 13:21:39 > ExecuteCommandLine Started
< 13:21:39 > ExecuteCommandLine Compeleted with ExitCode : 1
< 13:21:39 > Creating Ps2007 Provider Database
< 13:21:39 > ExecuteCommandLine Started
< 13:21:39 > ExecuteCommandLine Compeleted with ExitCode : 1
< 13:21:39 > InstallConnectorDatabase Completed

Thanks for your help,

Harris
Coordinator
Jun 12, 2007 at 7:07 PM
May seem like a silly question but is IIS installed on the box you're installing the Connector piece on and do you have admin priviledges when running the Installer?
Jun 12, 2007 at 7:17 PM

lfenster wrote:
May seem like a silly question but is IIS installed on the box you're installing the Connector piece on and do you have admin priviledges when running the Installer?


Yes, running install as <domain>\TFSService which has local Admin rights on the machine. IIS 6.0 is running on the machine, with all ASP.net web service extensions registered/enabled.

Thanks,

Harris
Coordinator
Jun 13, 2007 at 2:56 PM
Thanks Harris. The log actually looks like things worked okay. However, I am guessing that you couldn't get all the way through the installer, right?

Can you please provide some more details. At what point did the installer give you this error? Can you determine if the Connector and PS2007Provider databased were set up correctly? Are the Connector Web Service and web Site missing or did the installer create one or both of these?

Thanks in advance,
Lenny
Jun 14, 2007 at 2:46 PM
Lenny,

Thanks for working with me on this. I still have not been able to set up the Project Server Connector Component. Here is what I have tried:

- rebooting all servers involved; sql, project server, tfs, server to run connector component(s)
- admin privileges to our TFSService domain account on all machines, except sql, running as SQL SYSADMIN not local admin
- TFSService has permissions to log on to any machine (originally, specified to only TFS servers via AD)

Web site(s)/services are not installed; no database are created. The error remains the same and the installation log is no-different after all changes.

Would permitting TFSService to log on as a service have any effect on the installation?

Thanks so much for your help with this product!

Harris
Jun 14, 2007 at 3:09 PM
Edited Jun 14, 2007 at 3:12 PM
Just as a follow-up: the installation UI reports that it created the database, copies files and sets up the web site, and tries to "Commit[ting] IIS Metabase Transaction". This is where the error occurs.

I've also tried changing database servers and that did not work either.

Hope this information is helpful.

Thanks again,

Harris
Jun 14, 2007 at 3:28 PM
Just as a follow-up, again; I ran the installer on another machine and it worked fine. I'm not sure what the issue is/was; however, the connector server is not pointing at our production SQL server so I'm hoping to change that in the near future...

If someone could provide any insight as to why the install would work on one machine and not another, I'd appreciate it.

Thanks,

Harris
Jun 14, 2007 at 4:21 PM
OK, so I went and tried to install the Project Server component and I get the same IIsWebSite error on the Project Server 2007 machine. Here is the installation log:

Logging started at: 06/14/07 12:17:14

< 12:17:14 >Start PS2007-TFS Connector Setup

< 12:17:14 >CheckIfInstallerRunning

< 12:17:15 >CopyFromMsi

< 12:17:31 >CheckConnectorNameIsValid

< 12:17:31 > CheckMachineNameIsValid Started
< 12:17:31 > CheckMachineNameIsValid Completed
< 12:17:41 >CheckServiceUserIsEmpty

< 12:17:41 > CheckEmptyString Started
< 12:17:41 > CheckEmptyString Completed
< 12:17:49 >CheckPSPWAUrlIsValid

< 12:17:49 > CheckUrlFormatIsValid Started
< 12:17:49 > CheckUrlFormatIsValid Completed
< 12:17:56 >PSEventHandlersInstall

< 12:17:56 > InstallPSEventHandlers Started
< 12:17:56 > GetUserCredentials started
< 12:17:57 > GetUserCredentials Completed
< 12:17:57 > Loging to the project server event service : http://<projectservername>/PWA/vtibin/psi/events.asmx
< 12:17:57 > LoginToEventsService Started
< 12:18:00 > LoginToEventsService Completed
< 12:18:08 > Adding event data row.
< 12:18:08 > Creating eventhandler associations.
< 12:18:10 > InstallPSEventHandlers Completed
< 12:18:10 >CreateLookupTablesAndCustomFields

< 12:18:10 > InstallProjectServerFields Started
< 12:18:10 > GetUserCredentials started
< 12:18:10 > GetUserCredentials Completed
< 12:18:10 > Creating lookup tables in project server.
< 12:18:10 > CreateLookupTable Started
< 12:18:11 > GetLookupTableGuid Started
< 12:18:19 > GetLookupTableGuid Started
< 12:18:19 > CreateLookupTable Completed
< 12:18:19 > Creating custom fields in project server.
< 12:18:19 > CreateCustomFields Started
< 12:18:20 > GetCustomFieldGuid Started
< 12:18:21 > GetCustomFieldGuid Started
< 12:18:21 > GetCustomFieldGuid Started
< 12:18:21 > GetLookupTableGuid Started
< 12:18:21 > GetLookupTableGuid Completed
< 12:18:21 > GetCustomFieldGuid Started
< 12:18:21 > GetLookupTableGuid Started
< 12:18:21 > GetLookupTableGuid Completed
< 12:18:21 > CreateEnterpriseCustomFields Started
< 12:18:22 > CreateEnterpriseCustomFields Completed
< 12:18:22 > CreateCustomFields Completed
< 12:18:22 > InstallProjectServerFields Completed
Coordinator
Jun 14, 2007 at 6:42 PM
Harris,
I did a search on this error, and it looks like everytime this comes up, it is because some web sites or web services were removed from IIS on the box. Do you know if this may have occurred on your box?

Also, if you have it working on one machine and just want to point it to another database, you can go into the web.config file for the Connector web service and just change the Connection String for it.

HTH. Please let me know if there is anything else I can do to help?

Thanks,
Lenny
Jun 14, 2007 at 8:45 PM
Lenny,

Thanks again for your assistance. I know (because I did it:-)) that a site was deleted on the machine that I originally installed the Project Server Connector component. However, I cannot say anything with confidence regarding our Project Server 2007 machine because I've had very little involvement with that deployment.

I would also like to add that while the connector component did install successfully on one machine, it does not appear that the database(s) were created. I've consulted our DBA and he confirmed that they are not on either server. The installation log indicates, however, that the databases were created successfully.

Ignoring the "phantom" databases for the moment, is there any resolution regarding the removal of sites in IIS?

Thanks so much for you assistance through all this,

Harris
Coordinator
Jun 15, 2007 at 1:53 PM
Harris,

The most common resolution I see is to configure the IIS Default Web Site with the IP address set to All Unassigned. Is that something you can do? Most of the other resolutions seem very product specific and have details re: modifying the registry specific to that product, so I dont think they would apply here.

Can you make the change mentioned above and see if that helps at all?

Thanks,
Lenny
Jun 15, 2007 at 3:43 PM
Lenny,

I can make this change temporarily to get the application installed provided the settings can be reset as we had them configured.

I'm a little confused: which machine/tier should I set the IP settings for the default web site? On my Project Server, there is no Default Web Site, only the the Project Server created web sites.

I can try this on the Project Server Connector machine; is that what you're referring to?

Thanks so much,

Harris
Coordinator
Jun 16, 2007 at 3:11 PM
I am assuming that you're getting this issue when you're trying to install the Connector part, so I assume that it is on the Connector machine that you'll need to make this change.

I dont see why you couldn't change your settings back when you're done as long as you save all the setting information. However, there is defintely something unique about your current environment, so don't hold me to that.

HTH,
Lenny
Jun 19, 2007 at 1:55 PM
Lenny,

Thanks so much for the help. We're looking to get a new server (VM) set up here in the next day or so which will allow me to ensure that everything is clean and fresh as can be.

I'll report back as to whether or not I had any success on the new machine.

Thanks again,

Harris
Jun 15, 2010 at 4:50 PM
I am also getting this error installing on the TFS server in a 3 server installation. "Failed to read IIsWebs table" I am running on IIS 7 which I suspect is the problem - Is this installer supported on IIS7? -Rob < 03:19:25 >Start PS2007-TFS Connector Setup < 03:19:25 >CheckIfInstallerRunning < 03:19:25 >CopyFromMsi < 03:20:43 >CheckServiceUserIsEmpty < 03:20:43 > CheckEmptyString Started < 03:20:43 > CheckEmptyString Completed < 03:20:50 >TFSComponentInstall < 03:20:50 > InstallTfsComponent Started < 03:20:50 > GetUserCredentials started < 03:20:50 > GetUserCredentials Completed < 03:20:50 > Authenticating with UserName : XXX\tfsservice < 03:20:58 > Subscribing to WorkItemChanged Event Started < 03:20:59 > Global Sync States loaded = <gl:GLOBALLISTS xmlns:gl="http://schemas.microsoft.com/VisualStudio/2005/workitemtracking/globallists"><GLOBALLIST name="Synchronization States"><LISTITEM value="Not Synchronized" /><LISTITEM value="Pending" /><LISTITEM value="Synchronizing" /><LISTITEM value="ApprovedByTPM" /><LISTITEM value="DeniedByTPM" /><LISTITEM value="ApprovedByEPM" /><LISTITEM value="DeniedByEPM" /><LISTITEM value="Synchronized" /></GLOBALLIST></gl:GLOBALLISTS> < 03:21:00 > Uploading process template: C:\Windows\PS2007-TFS Connector\MsfAgile_Connector_new.zip < 03:21:02 > Uploading process template: C:\Windows\PS2007-TFS Connector\MsfFormal_Connector_new.zip < 03:21:11 > InstallTfsComponent Completed