locked
Database connection errors after install RRS feed

  • Question

  • Hi,
     
    I just finished installing our new TFS server, but are having some problems. I have the databases on a seperate SQL instance on another server and TFS, Analysis Services and Reporting Services on the frontend. The TFS installation was done from a media with SP1 slipstreamed.

    After the final reboot, I get the following errors in the system eventlog:

    Event Type: Error
    Event Source: Service Control Manager
    Event Category: None
    Event ID: 7023
    Date:  12/10/2008
    Time:  9:38:18 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    The Visual Studio Team Foundation Server Task Scheduler service terminated with the following error:
    The configuration data for this product is corrupt.  Contact your support personnel.

    The following errors is in the application log:

    Event Type: Error
    Event Source: Windows SharePoint Services 3
    Event Category: Database
    Event ID: 5586
    Date:  12/10/2008
    Time:  9:38:00 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    Unknown SQL Exception -1 occured. Additional error information from SQL Server is included below.

    An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    ----

    Event Type: Error
    Event Source: Report Server Windows Service (MSSQLSERVER)
    Event Category: Management
    Event ID: 107
    Date:  12/10/2008
    Time:  9:38:01 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

    ----

    Event Type: Error
    Event Source: TFS Services
    Event Category: None
    Event ID: 3017
    Date:  12/10/2008
    Time:  9:38:17 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    TF53010: The following error has occurred in a Team Foundation component or extension:
    Date (UTC): 12/10/2008 8:38:17 AM
    Machine: APPDKBA868
    Application Domain: /LM/W3SVC/663434920/Root/Services-1-128733718785156250
    Assembly: Microsoft.TeamFoundation.Server, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
    Process Details:
      Process Name: w3wp
      Process Id: 5456
      Thread Id: 5548
      Account name: ****\tfsservice

    Detailed Message: TF53013: A crash report is being prepared for Microsoft. The following information is included in that report:
    Request Details
    Url=http://appdkba868:8080/Services/v1.0/ServerStatus.asmx [method = POST]
    User Agent=Team Foundation (TFSServerScheduler.exe, 9.0.30729.1)
    Headers=Content-Length=354&Content-Type=text%2fxml%3b+charset%3dutf-8&Accept-Encoding=gzip%2cgzip%2cgzip&Accept-Language=en-US&Authorization=NTLM+TlRMTVNTUAADAAAAAAAAAEgAAAAAAAAASAAAAAAAAABIAAAAAAAAAEgAAAAAAAAASAAAAAAAAABIAAAANcKI4gUCzg4AAAAP&Expect=100-continue&Host=appdkba868%3a8080&User-Agent=Team+Foundation+(TFSServerScheduler.exe%2c+9.0.30729.1)&X-TFS-Version=1.0.0.0&X-TFS-Session=7ec3f39e-ab8a-4351-922a-d54721c8f53c&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2005%2f06%2fServices%2fServerStatus%2f03%2fCheckAuthentication%22
    Path=/Services/v1.0/ServerStatus.asmx
    Local Request=True
    User Host Address=10.1.46.26
    User=****\tfsservice [auth = NTLM]

    Application Provided Information
    Team Foundation Application Information
    Event Log Source = TFS Services
    Configured Team Foundation Server = http://appdkba868:8080/
    License Type = EnterpriseLicense
    Server Culture = en-US
    Activity Logging Name = Integration
    Component Name = CS
    Initialized = No
    Requests Processed = 0


    Exception: SqlException
    Message: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    ...
    ----

    Event Type: Error
    Event Source: TFS Scheduler
    Event Category: None
    Event ID: 3059
    Date:  12/10/2008
    Time:  9:38:17 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    TF53010: The following error has occurred in a Team Foundation component or extension:
    Date (UTC): 12/10/2008 8:38:17 AM
    Machine: APPDKBA868
    Application Domain: TFSServerScheduler.exe
    Assembly: Microsoft.TeamFoundation.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
    Process Details:
      Process Name: TFSServerScheduler
      Process Id: 3004
      Thread Id: 3420
      Account name: ****\tfsservice

    Detailed Message: Team Foundation services are not available from the server.
    Technical information (for administrator):
      TF30059: Fatal error while initializing web service

    ----

    Event Type: Error
    Event Source: Team Foundation Error Reporting
    Event Category: None
    Event ID: 5000
    Date:  12/10/2008
    Time:  9:38:17 AM
    User:  N/A
    Computer: APPDKBA868
    Description:
    EventType teamfoundationue, P1 1.0.0.0, P2 tfs, P3 9.0.30729.1, P4 9.0.0.0, P5 general, P6 sqlexception.20.-1, P7 b5e76fb8738b1975, P8 97690b88, P9 NIL, P10 NIL.

    ---

    I can manually start the TFS Scheduler service. When I open the Report Server Configuration, all points have green checkmarks. The SharePoint site responds as expected, and I can connect to the TFS server without problems.

    I found a reference to a similar problem here: http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/7533a310-0470-44ba-8fe4-ad18179cd7fc/ but it refers to a single server installation where the SQL server must be started before all other services. Since my SQL server is on another server, I don't think this is the exact problem, but something similar.

    Any ideas are welcome!

    Thanks,

    Rasmus


    Wednesday, December 10, 2008 8:59 AM

Answers

  • In a dual-server setup your data-tier should have Analys Services + Database and the application-tier should have Reporting Services, verify that your setup is correct and that the components were installed on the correct servers.

    Per
    • Proposed as answer by Per Bjurström Monday, December 15, 2008 1:45 PM
    • Marked as answer by Hua Chen Tuesday, December 16, 2008 10:33 AM
    Wednesday, December 10, 2008 2:33 PM
  • Hello Rasmus,

      In addition to Per,

     From the error message:

        When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

      Could you please check the following setting?

        How to: Enable the TCP/IP Protocol for a Database Instance

      Thanks.

    Please mark the replies as answers if they help and unmark them if they provide no help
    • Proposed as answer by Per Bjurström Monday, December 15, 2008 1:45 PM
    • Marked as answer by Hua Chen Tuesday, December 16, 2008 10:33 AM
    Thursday, December 11, 2008 3:15 AM

All replies

  • In a dual-server setup your data-tier should have Analys Services + Database and the application-tier should have Reporting Services, verify that your setup is correct and that the components were installed on the correct servers.

    Per
    • Proposed as answer by Per Bjurström Monday, December 15, 2008 1:45 PM
    • Marked as answer by Hua Chen Tuesday, December 16, 2008 10:33 AM
    Wednesday, December 10, 2008 2:33 PM
  • Hello Rasmus,

      In addition to Per,

     From the error message:

        When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

      Could you please check the following setting?

        How to: Enable the TCP/IP Protocol for a Database Instance

      Thanks.

    Please mark the replies as answers if they help and unmark them if they provide no help
    • Proposed as answer by Per Bjurström Monday, December 15, 2008 1:45 PM
    • Marked as answer by Hua Chen Tuesday, December 16, 2008 10:33 AM
    Thursday, December 11, 2008 3:15 AM