TFS2008: Dual Server Deployment Setup Error during installation of TFS


 

i'm testing out tfs2008 on our hyper-v environment

 

i able successful setup single server deployment initial testing. when run through dual server deployment setup simulate our production setup encountered issue on system health check before running tfs sp1 itself.

 

here's current environment:

 

application tier:

-windows 2008 ent x86 hyperv

-iis 7.0

-sharepoint 3.0 sp1

 

database tier

-windows 2008 ent x64 hyperv

-iis 7.0

-sql 2005 ent + sp2 x64 - services installed

 

i did customizations thing reports point our database tier since db services must installed there.

 

when reach installation of tfs, saw error:

 

the system health check has detected problem cause setup fail.

 

description

the sql server analysis services assemblies not installed on application tier.

 

workaround / remedy

the sql server analysis services assemblies not installed on team foundation server applicaiton tier. must install them team foundation server function. can install sql server tools on team foundation server assemblies installed. please install version matches analysis services sql server version, or later.

 

i have check our database tier , sql services running, firewall turn off on both tiers.

 

my question how resolve issue?

 

i saw similar thread here: http://forums.microsoft.com/msdn/showpost.aspx?postid=3799397&siteid=1&pageid=0

but didn't resolve current issue.

 

for feedback

 aaron block - msft wrote:

 

hi cb_jup,

 

it looks user doesn’t have administrative access on machine itself. (from dd_install_vstf_at_90.txt)

 

[09/17/08,02:24:37] tfsui: [9/17/2008 2:24:37] <1864> detection result false

[09/17/08,02:24:37] tfsui: [9/17/2008 2:24:37] <1864> issue current user does not have administrative access server running sql server analysis services is not applicable current machine

 

let me know if helps,

 

--aaron

 

p.s. quick unrelated question planning deploy using hyperv because don’t believe hyperv/sql 2005 combination officially supported, , may cause problems down line.

 

going tfs poc dual-server deployment sql services (reports, db, in data tier)

 

this did not resolve issue - when run using default dual-server installation (the reports in app tier) - lines above shown , default installation works , installed

 

***

 

but able solve issue in weird way.

 

1.) first install, reports on app tier (other prereqs installed)

2.) modify msiproperty.ini point reports on data tier

3.) install tfs sp1 -- installation proceeded

4.) uninstall reports on app tier

5.) tested on client through team explorer reports still working -- check data tier reports configuration tool configured tfs

 

---

 

for feedback

 

--

 

p.s. sql2005 on hyper-v not supported? production use our production sql still physical. tfs on hyper-v supported?

 



Archived Forums T-U  >  Team Foundation Server - Setup



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more