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?