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?

CRM 3.0 redeployment part 3

Step 5: Ok now comes the tricky part of the whole redeployment . i am stuck in this place for two days now. after setting the server and database name a window comes for specifying the organizational unit. i have selected the organizational unit correctly. additionally i have stayed with keep existing users. then if i continue the redeployment wizard by clicking next. the wizard migrates the system without any error. Step 6: I am trying to install the CRM server by connecting to the existing database in the server 1.....voila.......there are errors but different ones....... it has some problems with sql server 2005. it says, setup detected a version mismatch between specified database and the current product ($#@$##). i don't understand what on earth it is saying. if click for detail it shows this,

The Version of Your Microsoft CRM Database is Lower Than Expected

Cause

Setup has detected that the version of your current Microsoft CRM 1.2 database does not match the version required.

Solution

To resolve this problem, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS

as i said earlier i don't understand a single thing. i don't know from where CRM 1.2 database comes into play..... let's see if i can find any thing related to this issue on the net.....

CRM 3.0 redeployment part 2

In the redeployment... i have not backed up the AD. rather i created a new AD and created the corresponding users on it. reference figure of the installation can be found in the page 1 of the installation guideline journal. i had 4 users in the previous installation, one user having marketing manager role, two having system administrator role (one is the domain administrator, other is the CRM administrator) and the last one having a custom created role. as in the redeployment documentation i have installed the CRM redeployement wizard in server 2. now let us go through the steps for restoring the server. Step 1: our laptops are not specifically used for CRM purposes, so there is no back up for laptop clients necessary. There is no Great Plains. No WorkFlows. Both .mdf and .ldf files for the databases My_Organization_Name_METABASE My_Organization_Name_MSCRM has been backed up. Step 2: Not necessary Step 3: AD domain controllers SQL server (with 2005 reporting services) Exchange 2003 has been installed..... Step 4: The CRM metabase and the database has been restored. the problem begins when restoring the MSCRM database. it shows a warning message (as shown in the figure). the message says, "one or more full text catalogs are used by this database. do you want to locate the full text database? (click No to skip attaching full text catalogs.)" in this stage i clicked No. and the database got attached with no error message.

CRM 3.0 redeployment part 1

Now i am in my office working on redeployment of the CRM 3.0 server. it has been two days i'm stuck on the same point that i am now. i am following the redeployment guideline described in the redeployment journal of CRM 3.0. at first i found it on a Microsoft site, later i discovered that the same journal is stored in the CRM CD in \RedeploymentTool folder. before i go in deep into the installation procedures. let me give you an idea about the server layer of my organization. Server 1: OS: Windows 2003 Server (SP1) Enterprise Edition Services: 1. DNS 2. Active directory 3. IIS (with ASP. net) 4. NNTP and SMTP services from IIS Installed Servers: 1. Microsoft SQL server 2005 enterprise edition. 2. Microsoft SQL server 2005 reporting services. 3. Microsoft Exchange server 2003. Server 2: OS: Windows 2003 Server (SP1) Enterprise Edition Services: 1. IIS (with ASP .net) Installed Server: 1. Microsoft CRM 3.0 server 2. Microsoft SQL server 2000 Enterprise Edition ** 3. Microsoft EPM server 2003 ** ** these servers will be added later on for EPM 2003 server. OK...got to go....there is a recruitment going in my organization. i happen to be a member in recruitment panel.