Sharepoint 2010 split back-to-back woes

Been trying to get a PoC up and running (and completed of course) for a split back-to-back SharePoint 2010 setup with a “web front end” placed in a DMZ without domain trust.

Basically we have a SP 2010 application server/farm sitting internally (together with AD, SQL Server, Reporting Server et al) and want to join a SP 2010 server from within a DMZ.

Been trying to find out how this could be done and everything points to us having to use SQL Authentication when running the psconfig tool on the DMZ box.

It works, connects, authenticates and a ton of queries are of course fired across to the database – seeing authenticated calls in Profiler.

However, when running the following command:

psconfig -cmd configdb -connect -server xxx.xxx.xxx.xx -database "SharePoint_Config" -dbuser someuser -dbpassword somepassword -passphrase somepassphrase

I get the returne error:

PS C:\Windows\system32> psconfig -cmd configdb -connect -server xxx.xxx.xxx.xx -database "SharePoint_Config" -dbuser someuser -dbpassword somepassword -passphrase somepassphrase

SharePoint Products Configuration Wizard version 14.0.4762.1000. Copyright (C) Microsoft Corporation 2010. All rights reserved.

Performing configuration task 1 of 3
Initializing SharePoint Products configuration...

Successfully initialized the SharePoint Products configuration.

Performing configuration task 2 of 3
Connecting to the configuration database...

Failed to connect to the configuration database.

An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.
Parameter name: service

Total number of configuration settings run: 2
Total number of successful configuration settings: 1
Total number of unsuccessful configuration settings: 1
Successfully stopped the configuration of SharePoint Products.
Configuration of SharePoint Products failed. Configuration must be performed before you use SharePoint Products. For further details, see the diagnostic log located at C:\Program Files\Common Files\Microsoft Shared\Web Serve
r Extensions\14\LOGS\PSCDiagnostics_6_4_2010_12_0_24_805_767248449.log and the application event log.

At first we thought it was a firewall issue – but as i said, we’re seeing the sql user connecting and sending across a tone of queries which all work. So, it doesn’t appear to be the configuration database (also checked the database, no login failures et al).

Then we started looking through the log file and see some interesting stuff that i’m not entirely sure is relevant. But first, i should mention that the the Admin content database is called “SharePoint_Admin_Content” and that’s also what’s listen in the “Manage Content Databases” in the internal farm’s Central Administration.

Here’s the drop from the log file: 

06/04/2010 12:00:49 9 INF    Creating connection string for config db SharePoint_Config server xxx.xxx.xxx.xx

06/04/2010 12:00:49 9 INF    Creating connection string for admin content db SharePoint_AdminContent_9ddd2a49-a366-41b2-a70e-47f19b8ce0b8 server xxx.xxx.xxx.xx

06/04/2010 12:00:49 9 INF    Using sql auth for sql connection string

06/04/2010 12:00:49 9 INF    Openning configdb so that I can join it at server xxx.xxx.xxx.xx database SharePoint_Config in farm mode

06/04/2010 12:00:49 1 INF    Now, waiting for the task configdb to quit execution

06/04/2010 12:00:49 9 INF    Now joining to farm at server xxx.xxx.xxx.xx database SharePoint_Config

06/04/2010 12:01:34 9 ERR    Task configdb has failed with an unknown exception 

06/04/2010 12:01:34 9 ERR    Exception: System.ArgumentNullException: Value cannot be null.

Parameter name: service

 at Microsoft.SharePoint.Administration.SPServiceInstance..ctor(String name, SPServer server, SPService service)

 at Microsoft.SharePoint.Administration.SPFarm.Join()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()

 at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

06/04/2010 12:01:34 9 INF    Entering function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF    Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF     Resource id to be retrieved is ExceptionInfo for language English (United States)

06/04/2010 12:01:34 9 INF     Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

06/04/2010 12:01:34 9 INF    Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF    Leaving function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF    Entering function Common.BuildExceptionInformation

06/04/2010 12:01:34 9 INF    Entering function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF     Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF     Resource id to be retrieved is ExceptionInfo for language English (United States)

06/04/2010 12:01:34 9 INF     Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

06/04/2010 12:01:34 9 INF     Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF    Leaving function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF    Leaving function Common.BuildExceptionInformation

06/04/2010 12:01:34 9 ERR    An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.

Parameter name: service

System.ArgumentNullException: Value cannot be null.

Parameter name: service

 at Microsoft.SharePoint.Administration.SPServiceInstance..ctor(String name, SPServer server, SPService service)

 at Microsoft.SharePoint.Administration.SPFarm.Join()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()

 at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

06/04/2010 12:01:34 9 INF    Entering function Common.BuildExceptionInformation

06/04/2010 12:01:34 9 INF    Entering function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF     Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF     Resource id to be retrieved is ExceptionInfo for language English (United States)

06/04/2010 12:01:34 9 INF     Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

06/04/2010 12:01:34 9 INF     Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF    Leaving function Common.BuildExceptionMessage

06/04/2010 12:01:34 9 INF    Leaving function Common.BuildExceptionInformation

06/04/2010 12:01:34 9 INF    Entering function get CommandCollection.this[string key]

06/04/2010 12:01:34 9 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF     Found value in collection for key global

06/04/2010 12:01:34 9 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF    Found command global in collection

06/04/2010 12:01:34 9 INF    Leaving function get CommandCollection.this[string key]

06/04/2010 12:01:34 9 INF    Entering function get CommandCollection.this[string key]

06/04/2010 12:01:34 9 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF     Found value in collection for key initialize

06/04/2010 12:01:34 9 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF    Found command initialize in collection

06/04/2010 12:01:34 9 INF    Leaving function get CommandCollection.this[string key]

06/04/2010 12:01:34 9 INF    Entering function Command.this[string key]

06/04/2010 12:01:34 9 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF     Found value in collection for key SINGLESERVER

06/04/2010 12:01:34 9 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF    Found parameter SINGLESERVER in collection

06/04/2010 12:01:34 9 INF    Leaving function Command.this[string key]

06/04/2010 12:01:34 9 INF    Entering function Command.this[string key]

06/04/2010 12:01:34 9 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF     Found value in collection for key upgradesessionid

06/04/2010 12:01:34 9 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF    Found parameter upgradesessionid in collection

06/04/2010 12:01:34 9 INF    Leaving function Command.this[string key]

06/04/2010 12:01:34 9 INF    Entering function TaskBase.OnTaskStop

06/04/2010 12:01:34 9 INF    Creating the OnTaskStop event for task configdb

06/04/2010 12:01:34 9 ERR    Task configdb has failed

06/04/2010 12:01:34 9 INF    friendlyMessage for task configdb is An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.

Parameter name: service

06/04/2010 12:01:34 9 INF    debugMessage for task configdb is An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.

Parameter name: service

System.ArgumentNullException: Value cannot be null.

Parameter name: service

 at Microsoft.SharePoint.Administration.SPServiceInstance..ctor(String name, SPServer server, SPService service)

 at Microsoft.SharePoint.Administration.SPFarm.Join()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()

 at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

06/04/2010 12:01:34 9 INF    Entering function TaskBase.FireTaskStateChanged

06/04/2010 12:01:34 9 INF     Firing the OnTaskStateChanged event for task configdb

06/04/2010 12:01:34 9 INF     Entering function TaskDriver.TaskStateEventHandler

06/04/2010 12:01:34 9 INF     Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF      Resource id to be retrieved is ConfigurationDatabaseTaskDisplayName for language English (United States)

06/04/2010 12:01:34 9 INF      Resource retrieved id ConfigurationDatabaseTaskDisplayName is configuration database

06/04/2010 12:01:34 9 INF     Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF     Received an TaskStateEventHandler event. task:configdb TaskBase.State:stopped

06/04/2010 12:01:34 9 INF     Entering function TasksQueue.IncrementTaskFailed

06/04/2010 12:01:34 9 INF      Incremented the number of tasks failed to 1

06/04/2010 12:01:34 9 INF     Leaving function TasksQueue.IncrementTaskFailed

06/04/2010 12:01:34 9 INF     Task configdb has stopped and failed. Total failed is now 1

06/04/2010 12:01:34 9 INF     Leaving function TaskDriver.TaskStateEventHandler

06/04/2010 12:01:34 9 INF     Entering function CommandLine.TaskStateEventHandler

06/04/2010 12:01:34 9 INF     Received an TaskStateEventHandler event. task:configdb TaskBase.State:stopped

06/04/2010 12:01:34 9 INF     Task configdb has stopped and failed. Total failed is now 1

06/04/2010 12:01:34 9 INF     Entering function Command.this[string key]

06/04/2010 12:01:34 9 INF      Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found value in collection for key disconnect

06/04/2010 12:01:34 9 INF      Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found parameter disconnect in collection

06/04/2010 12:01:34 9 INF     Leaving function Command.this[string key]

06/04/2010 12:01:34 9 INF     Entering function Command.this[string key]

06/04/2010 12:01:34 9 INF      Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found value in collection for key connect

06/04/2010 12:01:34 9 INF      Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found parameter connect in collection

06/04/2010 12:01:34 9 INF     Leaving function Command.this[string key]

06/04/2010 12:01:34 9 INF     Entering function Command.this[string key]

06/04/2010 12:01:34 9 INF      Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found value in collection for key create

06/04/2010 12:01:34 9 INF      Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 9 INF      Found parameter create in collection

06/04/2010 12:01:34 9 INF     Leaving function Command.this[string key]

06/04/2010 12:01:34 9 INF     Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF      Resource id to be retrieved is ConfigurationDatabaseTaskConnectFailConfigDisplayLabel for language English (United States)

06/04/2010 12:01:34 9 INF      Resource retrieved id ConfigurationDatabaseTaskConnectFailConfigDisplayLabel is Failed to connect to the configuration database.

06/04/2010 12:01:34 9 INF     Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 9 INF     Last message from task configdb is An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.

Parameter name: service

06/04/2010 12:01:34 9 INF     Leaving function CommandLine.TaskStateEventHandler

06/04/2010 12:01:34 9 INF    Leaving function TaskBase.FireTaskStateChanged

06/04/2010 12:01:34 9 INF    Leaving function TaskBase.OnTaskStop

06/04/2010 12:01:34 9 INF   Leaving function TaskThread.ExecuteTask

06/04/2010 12:01:34 1 INF   Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 1 INF    Resource id to be retrieved is ConfigurationDatabaseTaskDisplayName for language English (United States)

06/04/2010 12:01:34 1 INF    Resource retrieved id ConfigurationDatabaseTaskDisplayName is configuration database

06/04/2010 12:01:34 1 INF   Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 1 ERR   Task configuration database failed, so stopping execution of the engine

06/04/2010 12:01:34 1 INF   Entering function Command.this[string key]

06/04/2010 12:01:34 1 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found value in collection for key disconnect

06/04/2010 12:01:34 1 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found parameter disconnect in collection

06/04/2010 12:01:34 1 INF   Leaving function Command.this[string key]

06/04/2010 12:01:34 1 INF   Entering function Command.this[string key]

06/04/2010 12:01:34 1 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found value in collection for key connect

06/04/2010 12:01:34 1 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found parameter connect in collection

06/04/2010 12:01:34 1 INF   Leaving function Command.this[string key]

06/04/2010 12:01:34 1 INF   Entering function Command.this[string key]

06/04/2010 12:01:34 1 INF    Entering function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found value in collection for key create

06/04/2010 12:01:34 1 INF    Leaving function CommandCollectionBase.Get

06/04/2010 12:01:34 1 INF    Found parameter create in collection

06/04/2010 12:01:34 1 INF   Leaving function Command.this[string key]

06/04/2010 12:01:34 1 INF   Entering function StringResourceManager.GetResourceString

06/04/2010 12:01:34 1 INF    Resource id to be retrieved is ConfigurationDatabaseTaskConnectFailConfigDisplayLabel for language English (United States)

06/04/2010 12:01:34 1 INF    Resource retrieved id ConfigurationDatabaseTaskConnectFailConfigDisplayLabel is Failed to connect to the configuration database.

06/04/2010 12:01:34 1 INF   Leaving function StringResourceManager.GetResourceString

06/04/2010 12:01:34 1 ERR   Failed to connect to the configuration database.

An exception of type System.ArgumentNullException was thrown. Additional exception information: Value cannot be null.

Parameter name: service

System.ArgumentNullException: Value cannot be null.

Parameter name: service

 at Microsoft.SharePoint.Administration.SPServiceInstance..ctor(String name, SPServer server, SPService service)

 at Microsoft.SharePoint.Administration.SPFarm.Join()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()

 at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()

 at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

Now i’m not sure where it’s getting “SharePoint_AdminContent_9ddd2a49-a366-41b2-a70e-47f19b8ce0b8” from as that database doesn’t exist and has never existed. the SharePoint admin content database is called “SharePoint_AdminContent”.

I’m also seeing the DMZ server show up in “Manage Servers In Farm” with a message saying “Not Configured”.

so what am i missing here…

this is a clean install – i blew away the first SharePoint install after i got the first set of problems.

Environment is:

Windows Server 2008 R2
SharePoint 2010
SQL Server 2008 R2

Ideas?