Installation error : "...error occurred during the login process..."

Hello,



I have selected SQL Server and Windows Authentication Mode and
the Login properties ->Status section for the new SQL login is set to "Enable".

I work with Windows 2003 Server (without domain), SQL Server 2005

during installation of TFS i get the following error in "msi log file":





=================
Is WSS Installed : True
ConfigDBName : Not Available
ConfigDBServer : Not Available
Virtual Server State: NeedExtend
AdminApPoolName: StsAdminAppPool
VSApPoolName: Not Available
AdminPort: 10885
ContentDBName: Not Available
ContentDBServer: Not Available
============================================================
11.04.2006 23:47:56 DDSetStatus:Doing basic checks
11.04.2006 23:47:56 DDSetStatus:Doing checks for Config DB NOT set
11.04.2006 23:47:56 DDSetStatus:A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)


Thank you

Wojtek



Answer this question

Installation error : "...error occurred during the login process..."

  • JJ Brychell

    Wojtek,

    What is the error you get during the process Is there a pop-up Also, I had a few questions about your setup:

    - Are your AT and DT on different servers, or are you doing a single server install
    - If you are doing a single server install, are your users domain users or local users

    The log information you send us was from the ddsetup log, which is the log for our setup.exe. Could you also send us the part of the MSI log file (VSMSI*.log) where the error occurs

    Thanks,
    Erin


  • ldc555

    Hi Jim,


    I tryed two configuration of SQL Server for remote access:

    1) TCP/IP and named pipes
    2)
    TCP/IP only.


    and I always get the same error.


    Wojtek





  • Joe Courchaine

    Hi,

    thank you for answer,
    I checked it, and my SQL Server 2005 standard edition is set to accept Local and Remote Connections using tcp.


    I work on the dedicated server with remote desktop,

    I reinstalled SQL Server 2005 Standard Edition followed TFS installation guide

    Any idea what I do wrong

    Wojtek



  • NiravNeo



    Hi,

    we still don't have solution for this problem :(


    can anyone help



    Wojtek


  • PaulTheSoftwareDeveloper

    Wojtek,

    I noticed that you said that your SQL Server instance was configured to accept local and remote connections using TCP/IP. The error message logged by MSI, however, refers to the shared memory provider - also referred to as "named pipes." Can you check to see if your SQL Server is configured to accept connections over both TCP/IP and named pipes

    - Jim


  • Leoviveke



    Hi,

    I found a problem.

    I got this error, when I try to install TFS on partition D:\






  • Paul_IRET

    Hi Wojtek

    Did u find any solution for ur issue.

    please let us know,if ur successfull.

    Thanks,

    Ashok



  • keisuke

    Check if SQL Server is configured to accept Local and Remote Connections (using tcp) in Surface Area Configuration Manager.

    Cheers



  • charlv

    Hi,

    during the installation I get typical pop up windows with error setup:

    Microsoft Visual Studio 2005 Team Fundation Server - ENU has encountered a problem during setup. Setup did not complete correctly.

    I'm doing single server installation, and all my users are local users.
    (Setup user - is local administrator, TFS service user - is local user, RS user - is local user)

    this is a part with error in log file dd_vsinstall80.txt:

    [04/07/06,15:12:16] Setup.exe: GetGlobalCustomProperty({FF86EECD-782F-40CF-B5BC-EEFDA15B7EDD})
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Attribute value after replacement: TFSRTM
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Calculating result of Check function
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Calculating result of function LogicalOp
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Calculating result of function sql
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> CSQLFunction starting
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> CSQLFunction connecting to server ...
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Got _com_error executing SQL query, hr=-2147467259 (Unspecified error)
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Result of function sql is 0
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> CLogicalOpFunction::CalculateResult, type=and, result=0
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Result of function LogicalOp is 0
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Result is 0
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Detection result is false
    [04/07/06,15:12:16] VSServerUI: [4/7/2006 15:12:16] <5892> Issue TFS SQL Server databases exist and their schema are the correct version expected by Setup is not applicable for current machine
    [04/07/06,15:12:16] BPrecheck: {EB58D917-E98F-4991-A864-69821AE975A8}, 0x1


    this is a part with error in log file VSMsiLog6669.txt

    18.04.2006 13:34:21 DDSetEntry:Entering ConfigFileToken CustomAction
    18.04.2006 13:34:21 DDSetStatus:TFS service account: XXX\TFS_User
    18.04.2006 13:34:21 DDSetStatus:Database server: XXX
    18.04.2006 13:34:21 DDSetStatus:Virtual server: http://localhost:80
    18.04.2006 13:34:22 DDSetStatus:================= WSS Settings: =================
    Is WSS Installed : True
    ConfigDBName : Not Available
    ConfigDBServer : Not Available
    Virtual Server State: NeedExtend
    AdminApPoolName: StsAdminAppPool
    VSApPoolName: Not Available
    AdminPort: 10885
    ContentDBName: Not Available
    ContentDBServer: Not Available
    ============================================================
    18.04.2006 13:34:22 DDSetStatus:Doing basic checks
    18.04.2006 13:34:22 DDSetStatus:Doing checks for Config DB NOT set
    18.04.2006 13:34:22 DDSetStatus:A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
    18.04.2006 13:34:22 DDSetStatus: 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.ReadByte()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    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.TeamFoundation.Setup.WssConfig.AdoChecks.OpenConnection(String strConnectionString)
    MSI (s) (C0!40) [13:34:22:969]: PROPERTY CHANGE: Adding CallSetConfigDB property. Its value is '1'.
    18.04.2006 13:34:22 DDSetStatus:config db does not exists: 'CallSetConfigDB'
    18.04.2006 13:34:22 DDSetStatus:Doing checks for VS NOT extended
    MSI (s) (C0!40) [13:34:23:048]: PROPERTY CHANGE: Adding ApCreateNew property. Its value is '-apcreatenew'.
    18.04.2006 13:34:23 DDSetStatus:Existing content app pool not found, will create app pool when extending
    18.04.2006 13:34:23 DDSetStatus:Cannot open database "STS_Content_TFS" requested by the login. The login failed.
    Login failed for user 'XXX\yyyyyyyyy'.
    18.04.2006 13:34:23 DDSetStatus: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    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.TeamFoundation.Setup.WssConfig.AdoChecks.OpenConnection(String strConnectionString)
    MSI (s) (C0!40) [13:34:23:063]: PROPERTY CHANGE: Adding CallExtendVS property. Its value is '1'.

    i put xxx  instead of server name and yyyy instead of setup user

    Wojtek







  • veneto

    Hi,

    I correct my previous descirption :

    I work with SQL Server 2005 Enterprise Edition (not Standard edition)


    Wojtek



  • Installation error : "...error occurred during the login process..."