Error 32000 when installing TFS in dual-tier environment

Hi Everyone.
I'm installing TFS Beta 2 in a dual-server environment. We have three clean 2003 Standard servers. One is the active directory controller, one is the TFS app tier, and the third is the TFS sql server 2005 data tier.
The data tier installed successfully. I get the following error on the app tier install at step 4 of 4 after the system rebooted:
Error 32000. The Commandline "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\sdk\bin\bisregedit.exe" "http://app01:8080/scc/public/application/ServiceDefinition.aspx" DATA01 BisDB' returned non-zero value: 1
When I run the command line directly on the app tier from a command window, I get this:
C:\Documents and Settings\tfssetup>"C:\Program Files\Microsoft Visual Studio 200
5 Enterprise Server\BISIISDIR\sdk\bin\bisregedit.exe" "http://app01:8080/scc/pub
lic/application/ServiceDefinition.aspx" DATA01 BisDB
Microsoft.VisualStudio.ELead.Common.Exceptions.ELeadException: Cannot get regist
ered tools for: scc > System.Data.SqlClient.SqlException: Cannot generate SSP
I context.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.SSPIError(String error, String procedure)
at System.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 re
ceivedLength, Byte[] sendBuff, UInt32& sendLength)
at System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec)
at System.Data.SqlClient.SqlInternalConnectionTds.Login(Int64 timerExpire, St
ring newPassword)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword, Bool
ean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString c
onnectionOptions, Object providerInfo, String newPassword, SqlConnection owningO
bject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owning
Object)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection ownin
gObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.VisualStudio.Bis.Tools.BisRegistrationUpdate.GetRegisteredTools(
String toolId, String connectionString)
End of inner exception stack trace
at Microsoft.VisualStudio.Bis.Tools.BisRegistrationUpdate.GetRegisteredTools(
String toolId, String connectionString)
at Microsoft.VisualStudio.Bis.Tools.BisRegistrationUpdate.Main(String[] args)
I get the same error when I hit the URL directly: http://app01:8080/scc/public/application/ServiceDefinition.aspx
I can't find anything in the forums related to TFS SSPI errors. Please help. Thanks.
[3688 byte] By [RobRomito] at [2007-12-16]
# 1

By chance, did you using the same account to install both the AT and DT.

Was the account you specified for TFSService account identical between the AT & DT installations?

This appears to be related to NTLM authenticated access to the databases

MarcKuperstein-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 2
Hi Marc. Thanks for responding.
I don't know a lot about Active Directory, but I'm pretty sure I used the same account. I created SANDBOX\TFSSETUP and SANDBOX\TFSSERVICE on our domain controller. When I installed the TFS software on AT and DT, I logged in with SANDBOX\TFSSETUP. I think this means it's the same account.
Since then, I've downloaded the July CTP which a few posts recommended. I started again from Clean Standard 2003 installs and I'm in the middle of installing the AT right now.
If I run into the same problem, it must be something with the accounts or active directory.
I'm learning as I go :-)
RobRomito at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 3
Hey Rob,

Glad to hear you are continuing your investigation. Definitely let us know if you bump into any issues

MarcKuperstein-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 4
Hi Marc.
I've gone to the single-tier beta 2 install and I was still having problems. I think I'm doing two things wrong:
  1. I'm installing 2003 SP 1 before I setup IIS.
  2. I wasn't installing the Sharepoint critical update kb887981
I'm trying a fresh install again and I'm making sure I peform these two steps. I found these suggestions here:
http://www.oazabir.com/vsts/
My fingers are crossed!
RobRomito at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 5
Ok, I finally got it installed! Single-tier Beta2. Even though I installed 2003 SP 1 after IIS setup and I installed the sharepoint critical update, I still ran into 32000 errors while installing the TFS app portion.
Then I noticed that I hadn't defined a primary nameserver in my IP setup. Our boxes are on a private network without internet access, so I never bothered putting in a name server. As soon as I put in a name server and hit retry, the install finally worked.
When I dug into the details of the 32000 errors, there were a lot of timeouts. So, maybe the install tries to perform some name look ups or references something by name and windows hangs on the name look up?
Not sure if this just coincidence or not. Thoughts?
RobRomito at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 6
Rob,
What do you mean with "defined a primary nameserver in my IP setup"?
Thanks a lot.
Odair.
Odair at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...
# 7
Hi Odair.
Control Panel => Network Connections => Local Area Network => Properties => Internet Protocol (TCP/IP) => Properties => Preferred DNS Sever.
I originally left it blank and ran into problems. When I filled it in with the primary DNS server for the sandbox network we built, the install worked.
Thanks,
Rob
RobRomito at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Setup...

Visual Studio Team System

Site Classified