Having a MOSS Server connected to a farm via a WAN is not a good idea. One of the major points mentioned in optimisation white papers for farm performance optimisation is to have minimal latency between servers. I've seen recommendations for having dual NICs in WFEs so that inbound requests to WFEs use a different NIC and WFE connections to SQL use a second NIC, another is to locate WFEs as close to SQL as possible with minimal latency. SharePoint WFEs are quite chatty to SQL. Has anyone else connected a MOSS Server to a farm through a WAN? Is it even possible? As far as I know the best way to improve performance across WANs is to implement WAN accelerators, or setup discretely separate farms in different locations and live with it. The replication story isn't that good with SharePoint either, no matter what third party replication product you look at.
Sezai. 2009/6/4 Power, Karl <[email protected]> > I thought about that and all the servers (including the one that I’m > trying to join to the farm) are MOSS version 12.0.0.6335. > > > > regards, > > > > KP > ------------------------------ > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Noja, > Fadi > *Sent:* 03 June 2009 23:12 > *To:* [email protected] > *Subject:* RE: Problem Joining Server to Farm [SEC=UNCLASSIFIED] > > > > I had a similar issue that I had to help someone with. It turned out they > didn’t have the right updates installed on all. After installing them on > all, I ran > > > > stsadm -o upgrade -forceupgrade > > > > on all computers. > > > ------------------------------ > > *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Power, > Karl > *Sent:* Thursday, 4 June 2009 7:25 AM > *To:* [email protected] > *Subject:* Problem Joining Server to Farm > > > > Hi folks, > > > > I’m trying join a server to our existing SharePoint farm over a WAN link > and keep getting the error below. Has anyone encountered this before and > found a resolution that wasn’t down to network issues. I’ve made sure that > the surface area config on all SQL servers are correct etc. I suspect that > the issue may be caused be a timeout on PSConfig due to network latency or > something like that. Any information or opinions would be greatly > appreciated. I suspect that we may end up setting up a different farm for > the remote site in question. > > > > Environment: Windows 2K3 SP2 servers > > SQL2005 Standard SP3 > > MOSS 2007 SP1 (with December Cumulative Update > applied) > > > > > > The following is an excerpt from the application log on the server: > > * > ***************************************************************************************************************** > * > > *Event Type: Error* > > *Event Source: SharePoint Products and Technologies Configuration > Wizard* > > *Event Category: None* > > *Event ID: 104* > > *Date: 6/3/2009* > > *Time: 2:57:05 PM* > > *User: N/A* > > *Computer: TFCSPP01* > > *Description:* > > *Failed to connect to the configuration database.* > > *An exception of type System.Data.SqlClient.SqlException was thrown. > Additional exception information: A transport-level error has occurred when > receiving results from the server. (provider: TCP Provider, error: 0 - An > existing connection was forcibly closed by the remote host.)* > > *System.DataSqlClient.SqlException: A transport-level error has occurred > when receiving results from the server. (provider: TCP Provider, error: 0 - > An existing connection was forcibly closed by the remote host.)* > > * at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, > Boolean breakConnection)* > > * at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > exception, Boolean breakConnection)* > > * at > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > stateObj)* > > * at > System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject > stateObj, UInt32 error)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult > asyncResult, TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 > bytesExpected)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()* > > * at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] > buff, Int32 offset, Int32 len)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadString(Int32 length) > * > > * at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, > Byte type, Int32 length, Encoding encoding, Boolean isPlp, > TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, > SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.SqlDataReader.ReadColumnData()* > > * at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean > setTimeout)* > > * at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(SqlDataReader > dr)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache(Int64 > currentVersionOverride, List`1& newObjects, List`1& deletedObjects, Int64& > newestObjectVersion)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache() > * > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject > obj, Boolean storeClassIfNecessary, Boolean ensure)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject > obj, Boolean ensure)* > > * at Microsoft.SharePoint.Administration.SPPersistedObject.Update()* > > * at > Microsoft.SharePoint.Administration.SPWebApplication.ApplyWebConfigModifications() > * > > * at Microsoft.SharePoint.Administration.SPWebApplication.Provision()* > > * at > Microsoft.SharePoint.Administration.SPWebServiceInstance.Provision()* > > * at Microsoft.SharePoint.Administration.SPFarm.Join()* > > * at > Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb() > * > > * at > Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run() > * > > * at > Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()* > > * * > > *For more information, see Help and Support Center at > http://go.microsoft.com/fwlink/events.asp.* > > > ***************************************************************************************************************** > > > > > > The following is an excerpt from the PSConfig Diagnostics log: > > > *************************************************************************************************** > > *An exception of type System.Data.SqlClient.SqlException was thrown. > Additional exception information: A transport-level error has occurred when > receiving results from the server. (provider: TCP Provider, error: 0 - An > existing connection was forcibly closed by the remote host.)* > > *System.DataSqlClient.SqlException: A transport-level error has occurred > when receiving results from the server. (provider: TCP Provider, error: 0 - > An existing connection was forcibly closed by the remote host.)* > > * at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, > Boolean breakConnection)* > > * at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > exception, Boolean breakConnection)* > > * at > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > stateObj)* > > * at > System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject > stateObj, UInt32 error)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult > asyncResult, TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 > bytesExpected)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()* > > * at System.Data.SqlClient.TdsParserStateObject.ReadByteArray(Byte[] > buff, Int32 offset, Int32 len)* > > * at System.Data.SqlClient.TdsParserStateObject.ReadString(Int32 length) > * > > * at System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, > Byte type, Int32 length, Encoding encoding, Boolean isPlp, > TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, > SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj)* > > * at System.Data.SqlClient.SqlDataReader.ReadColumnData()* > > * at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean > setTimeout)* > > * at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.GetObject(SqlDataReader > dr)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache(Int64 > currentVersionOverride, List`1& newObjects, List`1& deletedObjects, Int64& > newestObjectVersion)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.RefreshCache() > * > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.StoreObject(SPPersistedObject > obj, Boolean storeClassIfNecessary, Boolean ensure)* > > * at > Microsoft.SharePoint.Administration.SPConfigurationDatabase.PutObject(SPPersistedObject > obj, Boolean ensure)* > > * at Microsoft.SharePoint.Administration.SPPersistedObject.Update()* > > * at > Microsoft.SharePoint.Administration.SPWebApplication.ApplyWebConfigModifications() > * > > * at Microsoft.SharePoint.Administration.SPWebApplication.Provision()* > > * at > Microsoft.SharePoint.Administration.SPWebServiceInstance.Provision()* > > * at Microsoft.SharePoint.Administration.SPFarm.Join()* > > * at > Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb() > * > > * at > Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run() > * > > * at > Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()* > > > > > > *Karl Power** > Glanbia Business Services > Glanbia Plc > Tel: +353 (0) 56 883 6016 > Email:** **[email protected]* <[email protected]>* > **Click here to join MS Live Meeting > Session*<https://www.livemeeting.com/cc/btconferencing3> > > > > > ______________________________________________________________ > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. > Any views and opinions expressed are those of the individual author/sender > and are not necessarily shared or endorsed by Glanbia plc or any associated > or related company. > This message has been scanned for all known viruses. > If you received this in error, please contact the sender and delete the > material from any computer. > > Glanbia plc is registered in Ireland as a public limited company. > Registered Office: Glanbia House, Kilkenny. > Company Number: 129933 > ============================================================== > > ______________________________________________________________ > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. > Any views and opinions expressed are those of the individual author/sender > and are not necessarily shared or endorsed by Glanbia plc or any associated > or related company. > This message has been scanned for all known viruses. > If you received this in error, please contact the sender and delete the > material from any computer. > > Glanbia plc is registered in Ireland as a public limited company. > Registered Office: Glanbia House, Kilkenny. > Company Number: 129933 > ============================================================== > ------------------------------ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozmoss > Other lists you might want to join: http://www.codify.com/lists > ------------------------------ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozmoss > Other lists you might want to join: http://www.codify.com/lists > ------------------------------ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/ozmoss > Other lists you might want to join: http://www.codify.com/lists > -------------------------------------------------------------------------------- Support procedure: http://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/ozmoss Other lists you might want to join: http://www.codify.com/lists
