connector doesn't work after successfully install

Jul 24, 2007 at 10:44 PM
Edited Jul 24, 2007 at 10:46 PM
Hi,

I have two-box install as the following:

TFS server: install the application and componet for TFS at port 8080
Project server: install the component for PS.

Both servers are Win2K SP1. Install the connector by using the tfs service account. After successfully install, I just tried to browse the site at TFS IIS manager and it shows the error:This operation could not be successfully performed. Please contact the administrator and refer to HandlingInstanceID: ce6454b6-6e7c-4733-83e9-d8e7b3300c8c . Then at my event log I saw all these error entries:

ASP.NET 2.0 warning:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 7/24/2007 4:35:52 PM
Event time (UTC): 7/24/2007 10:35:52 PM
Event ID: 411570b1674e457884997afd2a926253
Event sequence: 231
Event occurrence: 18
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/3/Root/Connector Web Site-1-128297896097047360
Trust level: Full
Application Virtual Path: /Connector Web Site
Application Path: C:\Program Files\Microsoft Project Server 2007 Connector\Connector Web Site\
Machine name: DENTFS01

Process information:
Process ID: 6064
Process name: w3wp.exe
Account name: domain\tfsservice

Exception information:
Exception type: TargetInvocationException
Exception message: Exception has been thrown by the target of an invocation.

Request information:
Request URL: http://localhost:8080/Connector Web Site/Project_List.aspx
Request path: /Connector Web Site/Project_List.aspx
User host address: 127.0.0.1
User: domain\tfsservice
Is authenticated: True
Authentication Type: NTLM
Thread account name: domain\tfsservice

Thread information:
Thread ID: 15
Thread account name: domain\tfsservice
Is impersonating: False
Stack trace: at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.GridView.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Errors:

Timestamp: 7/24/2007 10:36:23 PM
Message: HandlingInstanceID: d50362da-1655-4010-982a-ef33ce40ed75
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
07/24/2007 16:36:23
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Cannot open database "PS2007ProvidersDb" requested by the login. The login failed.
Login failed for user 'domain\tfsservice'.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 11
LineNumber : 65536
Number : 4060
Procedure :
Server : dentfs01\
State : 1
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(String storedProcedureName, Object[] parameterValues)
at Microsoft.Vsts.Ranger.Connector.PS2007Providers.Data.ProjectAssociationsData.get_ProjectAssociations()
at Microsoft.Vsts.Ranger.Connector.WebServices.PS2007ProviderAdministration.ActiveProjectAssociations()

Additional Info:

MachineName : DENTFS01
TimeStamp : 7/24/2007 10:36:23 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/3/Root/Connector Web Service-2-128297896162054372
ThreadIdentity : domain\tfsservice
WindowsIdentity : domain\tfsservice

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DENTFS01
Application Domain: /LM/W3SVC/3/Root/Connector Web Service-2-128297896162054372
Process Id: 6064
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 1932
Thread Name:
Extended Properties: HelpLink.ProdName - Microsoft SQL Server
HelpLink.EvtSrc - MSSQLServer
HelpLink.EvtID - 4060
HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink
HelpLink.LinkId - 20476

imestamp: 7/24/2007 10:36:23 PM
Message: HandlingInstanceID: ab1cac5a-ba16-4698-a7cb-445acda80b52
An exception of type 'System.Web.HttpUnhandledException' occurred and was caught.
---------------------------------------------------------------------------------
07/24/2007 16:36:23
Type : System.Web.HttpUnhandledException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Exception of type 'System.Web.HttpUnhandledException' was thrown.
Source : System.Web
Help link :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Boolean HandleError(System.Exception)
Stack Trace : at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.projectlistaspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\connector web site\7c9ef732\51720a40\AppWebf1i5oul.2.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Additional Info:

MachineName : DENTFS01
TimeStamp : 7/24/2007 10:36:23 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/3/Root/Connector Web Site-1-128297896097047360
ThreadIdentity : domain\tfsservice
WindowsIdentity :domain\tfsservice
Inner Exception
---------------
Type : System.Reflection.TargetInvocationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Exception has been thrown by the target of an invocation.
Source : mscorlib
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : System.Object _InvokeMethodFast(System.Object, System.Object[], System.SignatureStruct ByRef, System.Reflection.MethodAttributes, System.RuntimeTypeHandle)
Stack Trace : at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback
Jul 24, 2007 at 10:48 PM
And two more errors:

Timestamp: 7/24/2007 10:36:54 PM
Message: HandlingInstanceID: bf8d6c63-e4b1-4c59-b393-e4c179cc1188
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
07/24/2007 16:36:54
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Cannot open domain\tfsservice'.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 11
LineNumber : 65536
Number : 4060
Procedure :
Server : dentfs01\
State : 1
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(String storedProcedureName, Object[] parameterValues)
at Microsoft.Vsts.Ranger.Connector.PS2007Providers.Data.ProjectAssociationsData.get_ProjectAssociations()
at Microsoft.Vsts.Ranger.Connector.WebServices.PS2007ProviderAdministration.ActiveProjectAssociations()

Additional Info:

MachineName : DENTFS01
TimeStamp : 7/24/2007 10:36:54 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/3/Root/Connector Web Service-2-128297896162054372
ThreadIdentity : domain\tfsservice
WindowsIdentity : domain\tfsservice

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DENTFS01
Application Domain: /LM/W3SVC/3/Root/Connector Web Service-2-128297896162054372
Process Id: 6064
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 4920
Thread Name:
Extended Properties: HelpLink.ProdName - Microsoft SQL Server
HelpLink.EvtSrc - MSSQLServer
HelpLink.EvtID - 4060
HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink
HelpLink.LinkId - 20476


Timestamp: 7/24/2007 10:36:54 PM
Message: HandlingInstanceID: 584f700c-fa83-483b-9f79-20ed785effa2
An exception of type 'System.Web.HttpUnhandledException' occurred and was caught.
---------------------------------------------------------------------------------
07/24/2007 16:36:54
Type : System.Web.HttpUnhandledException, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Exception of type 'System.Web.HttpUnhandledException' was thrown.
Source : System.Web
Help link :
ErrorCode : -2147467259
Data : System.Collections.ListDictionaryInternal
TargetSite : Boolean HandleError(System.Exception)
Stack Trace : at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.projectlistaspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\connector web site\7c9ef732\51720a40\AppWebf1i5oul.2.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Additional Info:

MachineName : DENTFS01
TimeStamp : 7/24/2007 10:36:54 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/3/Root/Connector Web Site-1-128297896097047360
ThreadIdentity : domain\tfsservice
WindowsIdentity : domain\tfsservice
Inner Exception
---------------
Type : System.Reflection.TargetInvocationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Exception has been thrown by the target of an invocation.
Source : mscorlib
Help link :
Data : System.Collections.ListDictionaryInternal
TargetSite : System.Object _InvokeMethodFast(System.Object, System.Object[], System.SignatureStruct ByRef, System.Reflection.MethodAttributes, System.RuntimeTypeHandle)
Stack Trace : at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
at System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
at System.Web.UI.WebControls.GridView.DataBind()
at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
at System.Web.UI.Control.EnsureChildControls()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Inner Exception
---------------
Type : System.Web.Services.Protocols.SoapException, System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Message : Microsoft.Vsts.Ranger.Connector.WebServices.ExceptionHandling.ConnectorWebServiceException: This operation could not be successfully performed. Please contact the administrator and refer to HandlingInstanceID: bf8d6c63-e4b1-4c59-b393-e4c179cc1188
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyEntry.IntentionalRethrow(Exception chainException, Exception originalException)
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyEntry.RethrowRecommended(Exception chainException, Exception originalException)
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyEntry.Handle(Exception exceptionToHandle)
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicyImpl.HandleException(Exception exceptionToHandle)
at Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.ExceptionPolicy.HandleException(Exception exceptionToHandle, String policyName)
at Microsoft.Vsts.Ranger.Connector.WebServices.ExceptionHandling.ExceptionHandler.HandleException(Exception exception)
at Microsoft.Vsts.Ranger.Connector.WebServices.PS2007ProviderAdministration.ActiveProjectAssociations()
Source : System.Web.Services
Help link :
Actor :
Code : http://schemas.xmlsoap.org/soap/envelope/:Server
Detail : System.Xml.XmlElement
Lang :
Node :
Role :
SubCode :
Data : System.Collections.ListDictionaryInternal
TargetSite : System.Object[] ReadResponse(System.Web.Services.Protocols.SoapClientMessage, System.Net.WebResponse, System.IO.Stream, Boolean)
Stack Trace : at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at PS2007ProviderAdministration.ActiveProjectAssociations()
at Microsoft.Vsts.Ranger.Connector.WebUI.BLL.ProjectsManager.get_ProjectAssociations()
at Microsoft.Vsts.Ranger.Connector.WebUI.BLL.ProjectsManager.GetDetailedProjectAssociations()


Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DENTFS01
Application Domain: /LM/W3SVC/3/Root/Connector Web Site-1-128297896097047360
Process Id: 6064
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 1932
Thread Name:
Extended Properties:
Jul 24, 2007 at 10:49 PM
Follow the previous two posts: I have make sure the login is correct and tfsservice account has all the right to access both applications. Dont' know where went wrong. Could you please help?

Thanks in advance for your help.

Regards,
Clee
Coordinator
Jul 25, 2007 at 12:04 AM
Hi Clee,
I noticed that the error log states that the TFSService could not login to the databases. Can you please ensure that the TFSService has permission to login to the ConnectorDb and PS2007ProviderDb databases?

Thanks,
Lenny
Jul 25, 2007 at 2:54 PM
Hi Ifenster,

Thanks for your reply. I have checked my SQL 2005 at TFS server yet can't find those two dbs. That's kind of weird. Am I looking at the right place? I remember the setup point to the TFS server and the tfsservice account has the dbcreator right to create these two dbs. The event log shows installation is done successfully. Dont' know why I can't find them. Is it possible that because we ask it to remove the dbs during the previous uninstallation and it will not create it again? If that's the case, should I just create them before install the connector and use the existing db instance?

Thanks again for your help.

Regards,
CLee
Coordinator
Jul 26, 2007 at 2:03 AM
CLee,
That certainly is strange. Can you check out the connection strings that are contained within the web.config file for the Connector Web Service and see if shows what server its looking for the databases on?

Thanks,
Lenny
Jul 26, 2007 at 2:23 PM
Hi Lenny,

I checked the web.config file and it has these entries:

<connectionStrings>
<add name="ConnectorDb" connectionString="server=servername
\;database=ConnectorDb;Integrated Security=true;" providerName="System.Data.SqlClient"/>
<add name="PS2007 Provider Db" connectionString="server=servername
\;database=PS2007ProvidersDb;Integrated Security=true;" providerName="System.Data.SqlClient"/>
</connectionStrings>

Where can I check the installation log? I only see the event log showing it was installed successfully yet can't find any dbs in my SQL or anywhere. I have verified the right server to check too. Should I uninstall again and create the databases (ConnectorDb and PS2007ProvidersDb) first?

Thanks.

Regards,
CLee
Jul 26, 2007 at 3:22 PM
Hi Lenny,

Since it's not working so I did some tests: uninstall/reinstall all of three components and leave the default of everything except port 8080. Verified the permission for tfsservice account has sufficient rights at both boxes. Finally I can see the connector home page now. Thanks a lot for helping this troubleshooting process.

Regards,
CLee