Duel server install Win 2008 SQL 2008

Question

I’ve been really struggling (for some weeks) to get Team Foundation Server 2008 to install in a dual server environment.
Can anyone offer any general advice on the following setup:

Data Tier Server:
Windows Server 2008 64bit hyper v virtual machine
SQL Server 2008, including reporting services

App Tier
Windows Server 2008 32bit hyper v virtual machine

I have done the following:

App Tier Server:
Web Server(IIS) role added with the needed features
Sharepoint 3 downloaded and installed
SQL 2008 reporting services installed

Both servers:
All ports in install guide opened on both servers.

For reporting services where it doesn’t allow you to use the setup user, I’ve used another domain user who is admin on both machines.

Sharepoint is not on the default 17012 port.

When I try and install it doesn’t find reporting services.

I’ve tried setup with a user that’s a domain admin and administrator on both machines.
I’ve tried using this user to install things under as well during the test.
I’ve tried changing the account everything is running to my “super account”.

Is there actually much advantage of having a 64bit install of SQL Server as the data tier over having it all on 1 virtual machine?

I’ve been searching the internet for into the individual errors, but it’s more a general help I’m looking for here.

Latest error messages:
Microsoft Visual Studio 2008 Team Foundation Server - ENU: [2] ERROR:Error 29110.Team Foundation Report Server Configuration: Team Foundation Server could not connect to the SQL Reporting Services WMI provider.  Verify that SQL Reporting Services is installed and running.

Starting again as a single server install is looking more and more the way to go...

Answer 1

Hi James_UK_DEV,

Thank you for your post.

Some clarification with you:
Did you slipstream TFS2008 and TFS2008 SP1 for the installation?

To install TFS2008 on the server, I would suggest you to integrate the installation of SP1 with Team Foundation Server 2008. Please try the steps mentioned here:
http://blogs.msdn.com/dstfs/archive/2009/03/20/installing-tfs-2008-sp1-prerequisites-caveats-best-practices.aspx
For similar issue, please check:
http://social.msdn.microsoft.com/Forums/en-US/tfssetup/thread/8c1f3896-85d8-47c4-92f2-9970e260a803

Hope this helps. If you have any concern, please feel free to let me know.

Best regards,
Yichun Chen

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Thanks. Running an integrated SP1 install seems to have moved it further along.

I'm now getting error 29106 - Access to the SQL Reporting Services databases could not be granted
It's trying to grant rights to <MYDOMAIN>\TSS002$ where TSS002 is the app tier server.
I'm presuming it's trying to grant rights to the SQLServer on the data tier server to the Network Service account on the app tier server (TSS002).

I don't know why, as I'm running the setup as a domain user and have entered domain users where the setup has asked.

It created new "ReportServer" and "ReportServerTempDB" databases, which I remove each time before re-trying the install.

NB: The reporting services on the data tier could be used for other non-tfs stuff, in theory.
Reporting Services config on the data tier server shows:
Service Account: Network Service
Database: ReportServer3 (i.e. not the database created by the TFS install)
Execution Account: Hasn't been specified.

Reporting Services config on the app tier server shows:
Service Account: Network Service
Database: this isn't set
Execution Account: Hasn't been specified.

I've replaced my domain name with <MYDOMAIN> in the log below from VSMsiLog769.txt:
==========================================================

TFRSConfig - Team Foundation Server Reporting Services Configuration Tool
Copyright (c) Microsoft Corporation.  All rights reserved.

Connecting to SQL Server Reporting Services. Please wait...

Creating application pool UnusedSinceThisIsSql2008WhichDoesNotUseIIS...

Creating virtual directory Reports for Report Manager...

Configuring Report Manager virtual directory Reports to use application pool UnusedSinceThisIsSql2008WhichDoesNotUseIIS...

Creating virtual directory ReportServer for Report Server...

Configuring Report Server virtual directory ReportServer to use application pool UnusedSinceThisIsSql2008WhichDoesNotUseIIS...

Configuring Report Manager...

Generating database script...

Executing database script...

Generating database script granting rights...

Executing database script granting rights...
SQL Error #1
SQL Message: Windows NT user or group '<MYDOMAIN>\TSS002$' not found. Check the name again.
SQL LineNumber: 49
SQL Source: .Net SqlClient Data Provider
SQL Procedure: sp_grantlogin

System.Data.SqlClient.SqlException: Windows NT user or group '<MYDOMAIN>\TSS002$' not found. Check the name again.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.ApplyScript(SqlConnection sqlConnection, String script)
   at Microsoft.TeamFoundation.Admin.ReportingServices.ReportingServicesConfigurator.ConfigureDb()
Exception Data:
Key: HelpLink.ProdName, Value: Microsoft SQL Server
Key: HelpLink.ProdVer, Value: 10.00.2531
Key: HelpLink.EvtSrc, Value: MSSQLServer
Key: HelpLink.EvtID, Value: 15401
Key: HelpLink.BaseHelpUrl, Value: http://go.microsoft.com/fwlink
Key: HelpLink.LinkId, Value: 20476

Error: ErrorGrantingDbRights.

Configuring SQL Server Reporting Services failed.
10/27/09 16:59:21 DDSet_Status: Process returned 2516
10/27/09 16:59:21 DDSet_Status: Found the matching error code  for return value '2516' and it is: '29106'
10/27/09 16:59:21 DDSet_Error:  2516

Answer 3

It's installed! It's now more Dual server than a server duel.

Firstly I think the integrated installation helped. Either it was getting further, or you get more sensible error messages out.

I think I'm going to have to eat a big slice of humbe pie and say the rest was probably my stupid error:
The virtual machine did not get set it's final name until after the first TFS install attempt.
Therefore the data tier sql server had a login for the machine's ID but under the old name.
Once this login was cleared out <MYDOMAIN>\TSS002$ could be correctly installed and it worked!

I also needed to add the full text search feature onto the SQL Server install.

Answer 4

Hi James_UK_DEV,

It's my pleasure.

Thank you for your kindly sharing. Vote as Helpful. :)

And I'm so glad to hear that. Cheer!

Have a great day.

Best regards,
Yichun Chen

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.