locked
Sharepoint 2007 access/permission? RRS feed

  • Question

  • Current Config/setup:

    1 SharePoint server WFE

    1SQL 2000 SVR Back End

     

    This SPP server was an in-place upgrade from MOSS 2003.

     

    1 Shared Service Provider

    2 Web Applications

    About 40 sites

    About 30 MySites

    Even logs on the SharePoint server include:

    Event ID: 1309

    Category: Web Event

    Source: ASP.NET 2.0.50727.0

    Event code: 3005

    Event message: An unhandled exception has occurred.

    Event time: 11/23/2010 7:14:51 AM

    Event time (UTC): 11/23/2010 12:14:51 PM

    Event ID: 34a75efff6e747388e41a45a77626d4c

    Event sequence: 10

    Event occurrence: 1

    Event detail code: 0

     

    Application information:

        Application domain: /LM/W3SVC/1/ROOT-1-129349880797785633

        Trust level: WSS_Minimal

        Application Virtual Path: /

        Application Path: D:\Web Sites\Inetpub\wwwroot\

        Machine name: XXXXXX

     

    Process information:

        Process ID: 3072

        Process name: w3wp.exe

        Account name: domain\user

     

    Exception information:

        Exception type: NullReferenceException

        Exception message: Object reference not set to an instance of an object.

     

    Request information:

        Request URL: http://url/ssp/admin/default.aspx

        Request path: /ssp/admin/default.aspx

        User host address: 000.000.000.000

        User: domain\user

        Is authenticated: True

        Authentication Type: NTLM

        Thread account name: domain\user

     

    Thread information:

        Thread ID: 7

        Thread account name: domain\user

        Is impersonating: False

        Stack trace:    at Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage.RegisterProfileStoreLinksJavascript()

       at Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage.OnLoad(EventArgs e)

       at System.Web.UI.Control.LoadRecursive()

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

     

     

    Event ID: 560

    Category: Object Access

    Source: Security

    Object Open:

                     Object Server:        Security

                     Object Type:           File

                     Object Name:         D:\Web Sites\Inetpub\wwwroot\_app_bin\STSSOAP.DLL

                     Handle ID:               -

                     Operation ID:          {0,1706067084}

                     Process ID:             4276

                     Image File Name:   C:\WINDOWS\system32\inetsrv\w3wp.exe

                     Primary User Name:              user

                     Primary Domain:   domain

                     Primary Logon ID:  (0x0,0x547BC107)

                     Client User Name:  DUCK D

                     Client Domain:        domain

                     Client Logon ID:      (0x0,0x65B07EED)

                     Accesses:               READ_CONTROL

                                                    SYNCHRONIZE

                                                    ReadData (or ListDirectory)

                                                    ReadEA

                                                    ReadAttributes

                                                   

                     Privileges:              -

                     Restricted Sid Count:             0

                     Access Mask:         0x120089

     

     

     

    Problem 1:

    When I attempt to access the Default Web Site settings through Central Admin I receive the error below:

    Server Error in '/' Application.


    Object reference not set to an instance of an object.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

     

    [NullReferenceException: Object reference not set to an instance of an object.]

       Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage.RegisterProfileStoreLinksJavascript() +50

       Microsoft.Office.Server.Internal.UI.SharedServicesAdminDefaultPage.OnLoad(EventArgs e) +34

       System.Web.UI.Control.LoadRecursive() +74

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2604

     


    Version Information:  Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3053

     

     

     

    Problem 2:

     

    When attempting to go to MySites I receive the error below:

    Server Error in '/' Application.


    Value cannot be null.
    Parameter name: serverContext

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.ArgumentNullException: Value cannot be null.
    Parameter name: serverContext

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace:

     

    [ArgumentNullException: Value cannot be null.

    Parameter name: serverContext]

       Microsoft.Office.Server.UserProfiles.UserProfileManager..ctor(ServerContext serverContext, Boolean IgnoreUserPrivacy, Boolean backwardCompatible) +354

       Microsoft.Office.Server.UserProfiles.UserProfileManager..ctor(ServerContext serverContext, Boolean IgnoreUserPrivacy) +62

       Microsoft.Office.Server.UserProfiles.ProfileLoader.EnsureUserProfile() +81

       Microsoft.Office.Server.UserProfiles.ProfileLoader.GetUserProfile() +29

       Microsoft.SharePoint.Portal.WebControls.OWAPartBase.OnInit(EventArgs e) +75

       System.Web.UI.Control.InitRecursive(Control namingContainer) +386

       System.Web.UI.Control.AddedControl(Control control, Int32 index) +203

       System.Web.UI.ControlCollection.Add(Control child) +151

       System.Web.UI.WebControls.WebParts.WebPartManagerControlCollection.AddWebPartHelper(WebPart webPart) +220

       System.Web.UI.WebControls.WebParts.WebPartManagerControlCollection.AddWebPart(WebPart webPart) +109

       System.Web.UI.WebControls.WebParts.WebPartManager.AddWebPart(WebPart webPart) +56

       System.Web.UI.WebControls.WebParts.WebPartManagerInternals.AddWebPart(WebPart webPart) +12

       Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddWebPartWithRetry(WebPart webPart) +186

       Microsoft.SharePoint.WebPartPages.SPWebPartManager.AddDynamicWebPart(WebPart webPart) +85

       Microsoft.SharePoint.WebPartPages.SPWebPartManager.CreateWebPartsFromRowSetData(Boolean onlyInitializeClosedWebParts) +8058

       Microsoft.SharePoint.WebPartPages.SPWebPartManager.LoadWebParts() +63

       Microsoft.SharePoint.WebPartPages.SPWebPartManager.OnPageInitComplete(Object sender, EventArgs e) +410

       System.EventHandler.Invoke(Object sender, EventArgs e) +0

       System.Web.UI.Page.OnInitComplete(EventArgs e) +107

        System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1471

     


    Version Information:  Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3053

     

     

    Problem 3:

    Some users are no longer able to add certain web parts, error received is: “Unable to add selected web part(s).  Content  Editor Web Part: An error has occurred.”

     

     

    All of these issues seemed to have appeared overnight.  I have struggled for the last three weeks to try to resolve it on my own.  I do not have control over any other server on the domain or any portion of any network device.  Sadly, when changes are made on the network/domain, they are not recorded.  I have no way of knowing what was changed.  Nothing was changed on the SharePoint server; I cannot say the same for the SQL server or anything else on the network/domain. 

     

    I will say I am able to bring up all site data in Sharepoint Designer 2007, except the “Default Admin Site” asks for credentials when I try to view the default page in a browser.  This leads me to believe that it’s a permissions error.  Since no one can tell me what has changed on the domain/network, I have NO idea where to start looking for solutions. 

     

    I’m at a total loss.  Any assistance would be greatly appreciated.  I am not a developer, so coding answers will only frustrate me more unless there is NO other way.  It's probably something really simple, but I just can't find it.

     

    Thanks in advance.

    • Edited by D Sherwood Thursday, November 25, 2010 9:37 PM
    Tuesday, November 23, 2010 1:11 PM

All replies

  • I would suggest turning ULS logging up to a more detailed level and then repeating the access attempts to the pages mentioned.  Then check the ULS logs to get more detail on what may be going wrong.  This may be due to security patches being pushed via WSUS etc.  I've seen this kind of thing before where patches suddenly break the server.

    I would also recommend that you redact the above post to remove sensitive information such as the domain name and service account name from the stack traces you posted.  This is information that isn't useful to anyone trying to debug the issue, but it is useful to hackers trying to get an attack vector on military related installations.  I know the networks are secured and exposure is probably minimal, but this is not the kind of information that should be volunteered freely.

     


    I trust that answers your question...

    Thanks
    C

    http://www.cjvandyk.com/blog
    Tuesday, November 23, 2010 1:29 PM
    Answerer
  • Hi Sherwood,

     

    Thank you for share your problem.

     

    For your first and second problems, I think they are associated with Event 1309 and Even 560, could you please check the following Microsoft KB articles and then try to fix them:

    http://support.microsoft.com/kb/941386;

    http://support.microsoft.com/kb/908473.

     

    And the third problem, maybe you can solve it through the method which this thread has mentioned:

    http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/0cc39b3b-f9a1-4b99-bb5e-7e96319924a1/.

     

    Hope this could help you.

     

    Regards.

    Thursday, November 25, 2010 1:55 AM
  • Just fixed my post and can't thank you enough.  In the heat of my frustration I didn't sanitize it.  Thank you.  Thanks for your input, very much.  We are (as I understand) running WSUS on the domain, but I keep being told that nothing has changed that could cause these errors.  The Sharepoint server was re-imaged (re-ghosted) back to a point prior to these issues, but it didn't fix anything.  I will turn up ULS logging and then post those results ASAP.  Thank you again. 
    Thursday, November 25, 2010 9:43 PM
  • Thanks Peng,

    I'm going to post some of the ULS logs here then revisit your recommendations above.

    R,

    Tuesday, November 30, 2010 6:06 PM
  • Error when accessing MySite:

    Looking up context  site http://sppserver.domain.com:17619/personal/d'ann_sherwood/default.aspx in the farm SPS02_Config_db 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Topology                       88gr Monitorable alternateUrl is null 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880l Verbose  ConnectionString: 'Data Source=sqlsvr;Initial Catalog=SPS02_Config_db;Integrated Security=True;Enlist=False;Connect Timeout=15;Application Name="Windows SharePoint Services"'    ConnectionState: Closed ConnectionTimeout: 15 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0                                1624                           8acb Verbose  Reverting to process identity 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0                                1624                           8acc Verbose  Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0                                1624                           8acf Verbose  Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880m Verbose  SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com:17619' 
    11/30/2010 11:07:41.03  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Topology                       88gs Monitorable hostHeaderSiteInfo is null 
    11/30/2010 11:07:41.05  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    General                        6t8d Verbose  Looking up the additional information about the typical site http://sppserver.domain.com:17619/personal/d'ann_sherwood/default.aspx. 
    11/30/2010 11:07:41.05  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    General                        6t8e Verbose  The lookup of site http://sppserver.domain.com:17619/personal/d'ann_sherwood/default.aspx fell back on the http context.  Alternate access mapping will be skipped. 
    11/30/2010 11:07:41.05  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    General                        6t8g Verbose  Looking up typical site http://sppserver.domain.com:17619/personal/d'ann_sherwood/default.aspx in web application SPWebApplication Name=SharePoint_JFSCMySites - 17619 Parent=SPWebService. 
    11/30/2010 11:07:41.06  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880l Verbose  ConnectionString: 'Data Source=sqlsvr;Initial Catalog=SPS02_Config_db;Integrated Security=True;Enlist=False;Connect Timeout=15;Application Name="Windows SharePoint Services"'    ConnectionState: Closed ConnectionTimeout: 15 
    11/30/2010 11:07:41.06  w3wp.exe (0x0158)                        0x05F0                                1624                           8acb Verbose  Reverting to process identity 
    11/30/2010 11:07:41.06  w3wp.exe (0x0158)                        0x05F0                                1624                           8acc Verbose  Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.06  w3wp.exe (0x0158)                        0x05F0                                1624                           8acf Verbose  Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.06  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880m Verbose  SqlCommand: 'dbo.proc_getSiteMap'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@ApplicationId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'ae2841eb-20f9-4411-84a8-b767a4062a6b'     Parameter: '@Path' Type: NVarChar Size: 128 Direction: Input Value: '/personal/d'ann_sherwood' 
    11/30/2010 11:07:41.08  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    General                        6t8h Verbose  Found typical site /personal/d'ann_sherwood (b629b140-3ce9-4932-98c7-c1fc7982e140) in web application SPWebApplication Name=SharePoint_JFSCMySites - 17619 Parent=SPWebService. 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Topology                       88gr Monitorable alternateUrl is null 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880l Verbose  ConnectionString: 'Data Source=sqlsvr;Initial Catalog=SPS02_Config_db;Integrated Security=True;Enlist=False;Connect Timeout=15;Application Name="Windows SharePoint Services"'    ConnectionState: Closed ConnectionTimeout: 15 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0                                1624                           8acb Verbose  Reverting to process identity 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0                                1624                           8acc Verbose  Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0                                1624                           8acf Verbose  Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880m Verbose  SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite'     CommandType: StoredProcedure CommandTimeout: 0     Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: ''     Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com:17619' 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Topology                       88gs Monitorable hostHeaderSiteInfo is null 
    11/30/2010 11:07:41.17  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Topology                       88gv Monitorable hostHeaderSiteInfo is null 
    11/30/2010 11:07:41.20  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880l Verbose  ConnectionString: 'Data Source=sqlsvr;Initial Catalog=WSS_Content_JFSCMySites;Integrated Security=True;Enlist=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15 
    11/30/2010 11:07:41.20  w3wp.exe (0x0158)                        0x05F0                                1624                           8acb Verbose  Reverting to process identity 
    11/30/2010 11:07:41.20  w3wp.exe (0x0158)                        0x05F0                                1624                           8acc Verbose  Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.20  w3wp.exe (0x0158)                        0x05F0                                1624                           8acf Verbose  Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None 
    11/30/2010 11:07:41.20  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880m Verbose  SqlCommand: '              SELECT                   @VersionColumnId=s1.id,                  @TimeStampColumnId=s2.id               FROM                   sysobjects WITH (NOLOCK)               LEFT OUTER JOIN                   syscolumns AS s1 WITH (NOLOCK)              ON                   sysobjects.id = s1.id AND s1.name = 'VersionId'              LEFT OUTER JOIN                   syscolumns AS s2 WITH (NOLOCK)              ON                   sysobjects.id = s2.id AND s2.name = 'TimeStamp'              WHERE                   sysobjects.name='Versions'               COLLATE                   Latin1_General_CI_AS_KS_WS              '     CommandType: Text CommandTimeout: 0     Parameter: '@VersionColumnId' Type: Int Size: 0 Direction: Output Value: ''     Parameter: '@TimeStampColumnI... 
    11/30/2010 11:07:41.20* w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880m Verbose  ...d' Type: Int Size: 0 Direction: Output Value: '' 
    11/30/2010 11:07:41.22  w3wp.exe (0x0158)                        0x05F0 Windows SharePoint Services    Database                       880l Verbose  ConnectionString: 'Data Source=sqlsvr;Initial Catalog=WSS_Content_JFSCMySites;Integrated Security=True;Enlist=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15 
    11/30/2010 11:07:41.22  w3wp.exe (0x0158)                        0x05F0                                1624                           8acb Verbose  Reverting to process identity

    Tuesday, November 30, 2010 7:54 PM
  • Error when accessing "Default Web Site" settings through CA.

     

    Looking up context site http://sppserver.domain.com/ in the farm SPS02_Config_db                                                                                                           
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Topology 88gr Monitorable alternateUrl is null                                                                                                       
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=SPS02_Config_db Integrated Security=True Enlist=False Connect Timeout=15 Application "Name=""Windows" SharePoint "Services""'" ConnectionState: Closed ConnectionTimeout: 15                                                                                        
     w3wp.exe (0x0A38) 0x0DFC 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0DFC 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0DFC 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com'                                                                                
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Topology 88gs Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Topology 88gt Monitorable HttpCotext.Current is null                                                                                                       
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=SPS02_Config_db Integrated Security=True Enlist=False Connect Timeout=15 Application "Name=""Windows" SharePoint "Services""'" ConnectionState: Closed ConnectionTimeout: 15                                                                                        
     w3wp.exe (0x0A38) 0x0DFC 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0DFC 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0DFC 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0DFC Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getObjectsByBaseClass' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@BaseClassId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'daca2a15-b9b5-43da-bea3-6b75fbe3a883' Parameter: '@ParentId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '8bf9f1a9-7013-45c0-8c2c-0fd16c4b9987'                                                                      
     w3wp.exe (0x0A38) 0x0DFC Forms Server Forms Services Runtime 939k Medium IPFS has just come up                                                                                                    
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services General 6t8b Verbose Looking up context site http://sppserver.domain.com:80/default.aspx in the farm SPS02_Config_db                                                                                                 
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gr Monitorable alternateUrl is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=SPS02_Config_db Integrated Security=True Enlist=False Connect Timeout=15 Application "Name=""Windows" SharePoint "Services""'" ConnectionState: Closed ConnectionTimeout: 15                                                                                        
     w3wp.exe (0x0A38) 0x0294 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0294 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com'                                                                                
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gs Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com'                                                                                
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gs Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gv Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gr Monitorable alternateUrl is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=SPS02_Config_db Integrated Security=True Enlist=False Connect Timeout=15 Application "Name=""Windows" SharePoint "Services""'" ConnectionState: Closed ConnectionTimeout: 15                                                                                        
     w3wp.exe (0x0A38) 0x0294 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0294 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com'                                                                                
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gs Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gv Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gr Monitorable alternateUrl is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=SPS02_Config_db Integrated Security=True Enlist=False Connect Timeout=15 Application "Name=""Windows" SharePoint "Services""'" ConnectionState: Closed ConnectionTimeout: 15                                                                                        
     w3wp.exe (0x0A38) 0x0294 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0294 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose SqlCommand: 'dbo.proc_getSiteIdOfHostHeaderSite' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '' Parameter: '@HostHeader' Type: NVarChar Size: 128 Direction: Input Value: 'sppserver.domain.com'                                                                                
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gs Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Topology 88gv Monitorable hostHeaderSiteInfo is null                                                                                                       
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880l Verbose ConnectionString: 'Data Source=sqlsvr Initial Catalog=JointFor1_SITE Integrated Security=True Enlist=False Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15                                                                                            
     w3wp.exe (0x0A38) 0x0294 1624 8acb Verbose Reverting to process identity                                                                                                         
     w3wp.exe (0x0A38) 0x0294 1624 8acc Verbose Current user before SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 1624 8acf Verbose Current user after SqlConnection.Open: Name: DOMAIN\AuthAcct SID: S-1-5-21-1384738610-847602051-1361462980-49875 ImpersonationLevel: None                                                                                                   
     w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose SqlCommand: ' SELECT TOP 4 t1.[Type] AS c0 t1.[ScopeId] AS c2 UserData.[tp_ContentTypeId] UserData.[ntext2] UserData.[tp_UIVersion] UserData.[tp_ID] t1.[TimeCreated] AS c4 UserData.[tp_CopySource] UserData.[tp_Created] CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N'/' + t1.LeafName END AS c1 UserData.[tp_ModerationStatus] UserData.[tp_Level] UserData.[nvarchar1] UserData.[tp_HasCopyDestinations] t1.[LeafName] AS c3 UserData.[nvarchar2] UserData.[tp_HasAttachment] t1.[DirName] AS c5 UserData.[tp_ContentType] FROM UserData INNER MERGE JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1 AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = UserData.tp_DirName AND t1.LeafNa...                   
     * w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose ...me = UserData.tp_LeafName AND t1.Level = UserData.tp_Level AND t1.IsCurrentVersion = 1 AND (1 = 1)) WHERE (UserData.tp_IsCurrent = 1) AND UserData.tp_SiteId=@L2 AND (UserData.tp_DirName=@DN) AND UserData.tp_RowOrdinal=0 AND ((UserData.[datetime1] >= @L3DTP) AND t1.SiteId=@L2 AND (t1.DirName=@DN)) ORDER BY UserData.[tp_Created] Desc UserData.[tp_ID] Asc OPTION (FORCE ORDER) ' CommandType: Text CommandTimeout: 0 Parameter: '@L0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '00000000-0000-0000-0000-000000000000' Parameter: '@L2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '5a828aed-4cf3-498d-8bc6-e17cf83e4d5e' Parameter: '@L3DTP' Type: DateTime Size: 0 Direction: Input Value: ' 5:00:00 AM' Parameter: '@DN' Type: NVarChar Size: 260 Directio...                   
     * w3wp.exe (0x0A38) 0x0294 Windows SharePoint Services Database 880m Verbose ...n: Input Value: 'Lists/Important Messages'                                                                                                    
                                                                                                    

    Tuesday, November 30, 2010 8:03 PM