Monday, 14 January 2008

EPM 2003 : Unexpected Server Response - when try to connect to the project server from Project Professional

this is one of the most common error of EPM 2003. there are number of things that need to be checked to get rid of of the error.
  • check whether the project server 2003 database is enlisted to the trusted sites list in the internet explorer. use fully qualified server name rather than just local computer name.
  • see whenther Authentication in security setting is set to , Automatic Logon with Current User Name and Password. if not make it.
  • Check the ActiveX settings for the internet explorer. what i did in my IE is that i put all enabled in any option related with ActiveX. works real good when you are intranet environment.
that's about it for today.............

EPM 2003: Adding Resource to Enterprise Resource Pool Problem - Part 2

well i have resolved the problem. the problem lies with the resource name. here the resource name has to be same as the user account in project server. the default is set to be the windows user account name (the name written specified in Active Directory). when i changed the name according to the project server then the i can easily add the resources to the pool.

Thursday, 10 January 2008

EPM 2003: Adding Resource to Enterprise Resource Pool Problem - Part 1

The Highlighted enterprise resources either have invalid data or there is additional information about that resources displayed bellow. Edit any invalid values highlighted bellow to save and check in resources. when i click on the resource for more information then the following box appears. in the screen when i click windows user account then the following box appears i don't know what is going wrong...... searching for resolution....

Sunday, 6 January 2008

Mircrosoft EPM 2003: the user could not be created...another stupid problem

well today i received a new error while creating a new user in EPM server. the error goes like this.... i some how realized that my project server has lost its connection with the DNS. the computers object in AD does not show the project server computer name...so i added the project server into the domain....and that's it....

Sunday, 30 December 2007

Microsoft EPM 2003: SQL Server service does not start successfully because of a logon failure

Well this is one of the the errors that i faced when i went to my last visited organization to give EPM 2003 consultation. their EPM 2003 installation is very much straight forward. all the server and services are created by the user who has some Admin privileges. by some admin privileges i mean, the admin can do every thing except creating new Active Directory objects (i.e users, computers ..so forth). the symptom of the problem is, some of the time when the EPM server needs to be restarted, the SQL service does not start automatically. when i try to start the service manually then the error mentioned is the topic shows up. there are two links which came handy to me. they are,
  1. Microsoft KB article
  2. Thea Burger's Blog
i specially liked the second link because that contains simple process which is easier to remember. if some one asks me to briefly describe how to resolve the problem then i will simply say, change the SQL server log on to Domain Admin user's account and password.

CRM 3.0 redeployment: setup has detected a version mismatch between specified database and the current product

Problem is solved Microsoft Business Solution Group has done the trick for me. in the post # 11 there is a query to update the buildversion table. i don't know yet why am i updating the buildversion table? nevertheless, my problem has been solved using the query. well the query goes here......
Update BuildVersion set Revision = 9 where BuildNumber = 5300
though the pre CRM setup assessment shows some warnings but the CRM server gets installed without any errors. i am testing the current CRM server now. so far no problem found.

CRM 3.0 redeployment: setup has detected a version mismatch between specified database and the current product

well....its a new day....let's start from the beginning i had a CRM 3.0 installation previously....for some reason, i want to redeploy the CRM 3.0 using the older database.
  1. my Active Directory is new (not back up new...it's just new, new). it has same name and users as in the previous installation.
  2. installed the SQL server and restored the MSCRM and METABASE databases.
  3. i have installed the CRMRedeployment tool and did exactly what is written in the redeployment manual.
  4. when try to install in the diagnostic test the setup gives error under Microsoft SQL server.
    setup has detected a version mismatch between specified database and the current product
i have checked the net for resolution but no good. still i got a number of post in different forums and blogs about the same problem. one of the links is Microsoft community. one guy here says that he did solved the problem but does not say how. he gives hint though that it has something to do with the build version in SQL server. as usual i've got no clue about what he wants to mean? another link is Microsoft Dynamics CRM newsgroup. it has a some sort of resolution. but i cannot say whether it will resolve my problem or not? it is about upgrading from CRM 1.2 to CRM 3.0. let's what happens?