|
|
28-11-2007, 03:36 PM
|
#11 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
Hi George!
I tried removing all entries in license table. It did not solve the problem. It still gave me the same error "Setup detected a version mismatch between the specified database and the current product." Somehow, MS CRM thinks the database is in MS CRM version 1.2 instead. Any idea? Anyone has any idea? Please help  -- Mikey M. "George Doubinski" wrote: > Hi Mikey, > > I'd be inclined to backup the databases, delete all entries in license table > and then try the new installation connecting to this database. This approach > seems to work if you want CRM to "forget" the previous licensing keys > altogether. I'm not sure if this is not a more serious issue but it's worth > the shot. > > Hope this helps > -- > George Doubinski > CRM Certified Professional - Developer > > > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... > > Haven't heard from anyone so I thought I would repost my reply here: > > > > "Thank you! The KB helped me went a step futher. I am now getting "Setup > > has > > detected that the version of your current Microsoft CRM 1.2 database does > > not > > match the version required." during the MS CRM installation. We are > > currently > > using MS CRM 3.0 for SBS not 1.2. Please help! " > > > > -- > > Mikey M. > > > > > > "Matt Parks" wrote: > > > >> FYI, redeployment is not needed if you stay within the same domain. > >> Deployment manager can be used to "point" to the resotred DBs on another > >> server or an install on a new server can "use" those existing (ie. > >> restored) > >> DBs. > >> > >> -- > >> > >> Matt Parks > >> MVP - Dynamics CRM > >> > >> > >> "Damir" <Damir@discussions.microsoft.com> wrote in message > >> news  54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...> >> So you have trial license in your existing CRM since you cant use Trial > >> Key > >> Pro I gave to you ? > >> > >> If the KB cant fix it to you, then you open the MSCRM database and find > >> dbo.License under tables, open then table and remove the cdkey from > >> there. > >> > >> "George Doubinski" wrote: > >> > >> > Hi Mikey, > >> > > >> > http://support.microsoft.com/kb/934691 answers your question. > >> > Basically, > >> > you > >> > have to upgrade the license first then redeploy. > >> > > >> > Hope this helps. > >> > > >> > -- > >> > George Doubinski > >> > CRM Certified Professional - Developer > >> > > >> > > >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... > >> > >I did as you suggested. Got an error saying 'You cannot mix Small > >> > >Business > >> > > Edition and Professional Edition license keys in one deployment'. Any > >> > > idea? > >> > > -- > >> > > Mikey M. > >> > > > >> > > > >> > > "Damir" wrote: > >> > > > >> > >> Make backup of databases. > >> > >> Restore databases on SQL2005 > >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear > >> > >> Organization > >> > >> name > >> > >> and GUIDS. > >> > >> > >> > >> Run Microsoft CRM 3.0 installation and click "connect to existing" > >> > >> > >> > >> "MikeyM" wrote: > >> > >> > >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. They > >> > >> > just > >> > >> > bought > >> > >> > a professional license and are trying to install MS CRM on a new > >> > >> > box > >> > >> > (Window > >> > >> > Server 2003) along with databases using SQL 2005. I am searching > >> > >> > for > >> > >> > a > >> > >> > way > >> > >> > moving the database (SQL2000) from SBS to the new Window Server > >> > >> > 2003 > >> > >> > box > >> > >> > using SQL 2005. Any suggestion? > >> > >> > > >> > >> > Thanks  > >> > >> > > >> > >> > -- > >> > >> > Mikey M. > >> > > >> > > >> > > >> > >> > >> > > > |
|
|
28-11-2007, 03:36 PM
|
#12 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
Hi Mikey,
it might be not as bad as it looks. Can you post the content of your BuildVersion table? Cheers -- George Doubinski CRM Certified Professional - Developer "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message news:E7053968-A467-40D2-840D-AD88CA88C4C7@microsoft.com... > Hi George! > > I tried removing all entries in license table. It did not solve the > problem. > It still gave me the same error "Setup detected a version mismatch > between > the specified database and the current product." Somehow, MS CRM thinks > the > database is in MS CRM version 1.2 instead. Any idea? Anyone has any idea? > Please help > > -- > Mikey M. > > > "George Doubinski" wrote: > >> Hi Mikey, >> >> I'd be inclined to backup the databases, delete all entries in license >> table >> and then try the new installation connecting to this database. This >> approach >> seems to work if you want CRM to "forget" the previous licensing keys >> altogether. I'm not sure if this is not a more serious issue but it's >> worth >> the shot. >> >> Hope this helps >> -- >> George Doubinski >> CRM Certified Professional - Developer >> >> >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message >> news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... >> > Haven't heard from anyone so I thought I would repost my reply here: >> > >> > "Thank you! The KB helped me went a step futher. I am now getting >> > "Setup >> > has >> > detected that the version of your current Microsoft CRM 1.2 database >> > does >> > not >> > match the version required." during the MS CRM installation. We are >> > currently >> > using MS CRM 3.0 for SBS not 1.2. Please help! " >> > >> > -- >> > Mikey M. >> > >> > >> > "Matt Parks" wrote: >> > >> >> FYI, redeployment is not needed if you stay within the same domain. >> >> Deployment manager can be used to "point" to the resotred DBs on >> >> another >> >> server or an install on a new server can "use" those existing (ie. >> >> restored) >> >> DBs. >> >> >> >> -- >> >> >> >> Matt Parks >> >> MVP - Dynamics CRM >> >> >> >> >> >> "Damir" <Damir@discussions.microsoft.com> wrote in message >> >> news 54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...>> >> So you have trial license in your existing CRM since you cant use >> >> Trial >> >> Key >> >> Pro I gave to you ? >> >> >> >> If the KB cant fix it to you, then you open the MSCRM database and >> >> find >> >> dbo.License under tables, open then table and remove the cdkey from >> >> there. >> >> >> >> "George Doubinski" wrote: >> >> >> >> > Hi Mikey, >> >> > >> >> > http://support.microsoft.com/kb/934691 answers your question. >> >> > Basically, >> >> > you >> >> > have to upgrade the license first then redeploy. >> >> > >> >> > Hope this helps. >> >> > >> >> > -- >> >> > George Doubinski >> >> > CRM Certified Professional - Developer >> >> > >> >> > >> >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message >> >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... >> >> > >I did as you suggested. Got an error saying 'You cannot mix Small >> >> > >Business >> >> > > Edition and Professional Edition license keys in one deployment'. >> >> > > Any >> >> > > idea? >> >> > > -- >> >> > > Mikey M. >> >> > > >> >> > > >> >> > > "Damir" wrote: >> >> > > >> >> > >> Make backup of databases. >> >> > >> Restore databases on SQL2005 >> >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear >> >> > >> Organization >> >> > >> name >> >> > >> and GUIDS. >> >> > >> >> >> > >> Run Microsoft CRM 3.0 installation and click "connect to >> >> > >> existing" >> >> > >> >> >> > >> "MikeyM" wrote: >> >> > >> >> >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. >> >> > >> > They >> >> > >> > just >> >> > >> > bought >> >> > >> > a professional license and are trying to install MS CRM on a >> >> > >> > new >> >> > >> > box >> >> > >> > (Window >> >> > >> > Server 2003) along with databases using SQL 2005. I am >> >> > >> > searching >> >> > >> > for >> >> > >> > a >> >> > >> > way >> >> > >> > moving the database (SQL2000) from SBS to the new Window Server >> >> > >> > 2003 >> >> > >> > box >> >> > >> > using SQL 2005. Any suggestion? >> >> > >> > >> >> > >> > Thanks >> >> > >> > >> >> > >> > -- >> >> > >> > Mikey M. >> >> > >> >> > >> >> > >> >> >> >> >> >> >> >> >> |
|
|
|
28-11-2007, 03:36 PM
|
#13 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
I took care of it by issueing this statement on MS CRM database "Update
BuildVersion set Revision = 9 where BuildNumber = 5300" Thanks soooo much for all the help. -- Mikey M. "George Doubinski" wrote: > Hi Mikey, > > it might be not as bad as it looks. Can you post the content of your > BuildVersion table? > > Cheers > > -- > George Doubinski > CRM Certified Professional - Developer > > > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > news:E7053968-A467-40D2-840D-AD88CA88C4C7@microsoft.com... > > Hi George! > > > > I tried removing all entries in license table. It did not solve the > > problem. > > It still gave me the same error "Setup detected a version mismatch > > between > > the specified database and the current product." Somehow, MS CRM thinks > > the > > database is in MS CRM version 1.2 instead. Any idea? Anyone has any idea? > > Please help > > > > -- > > Mikey M. > > > > > > "George Doubinski" wrote: > > > >> Hi Mikey, > >> > >> I'd be inclined to backup the databases, delete all entries in license > >> table > >> and then try the new installation connecting to this database. This > >> approach > >> seems to work if you want CRM to "forget" the previous licensing keys > >> altogether. I'm not sure if this is not a more serious issue but it's > >> worth > >> the shot. > >> > >> Hope this helps > >> -- > >> George Doubinski > >> CRM Certified Professional - Developer > >> > >> > >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > >> news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... > >> > Haven't heard from anyone so I thought I would repost my reply here: > >> > > >> > "Thank you! The KB helped me went a step futher. I am now getting > >> > "Setup > >> > has > >> > detected that the version of your current Microsoft CRM 1.2 database > >> > does > >> > not > >> > match the version required." during the MS CRM installation. We are > >> > currently > >> > using MS CRM 3.0 for SBS not 1.2. Please help! " > >> > > >> > -- > >> > Mikey M. > >> > > >> > > >> > "Matt Parks" wrote: > >> > > >> >> FYI, redeployment is not needed if you stay within the same domain. > >> >> Deployment manager can be used to "point" to the resotred DBs on > >> >> another > >> >> server or an install on a new server can "use" those existing (ie. > >> >> restored) > >> >> DBs. > >> >> > >> >> -- > >> >> > >> >> Matt Parks > >> >> MVP - Dynamics CRM > >> >> > >> >> > >> >> "Damir" <Damir@discussions.microsoft.com> wrote in message > >> >> news 54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...> >> >> So you have trial license in your existing CRM since you cant use > >> >> Trial > >> >> Key > >> >> Pro I gave to you ? > >> >> > >> >> If the KB cant fix it to you, then you open the MSCRM database and > >> >> find > >> >> dbo.License under tables, open then table and remove the cdkey from > >> >> there. > >> >> > >> >> "George Doubinski" wrote: > >> >> > >> >> > Hi Mikey, > >> >> > > >> >> > http://support.microsoft.com/kb/934691 answers your question. > >> >> > Basically, > >> >> > you > >> >> > have to upgrade the license first then redeploy. > >> >> > > >> >> > Hope this helps. > >> >> > > >> >> > -- > >> >> > George Doubinski > >> >> > CRM Certified Professional - Developer > >> >> > > >> >> > > >> >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > >> >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... > >> >> > >I did as you suggested. Got an error saying 'You cannot mix Small > >> >> > >Business > >> >> > > Edition and Professional Edition license keys in one deployment'. > >> >> > > Any > >> >> > > idea? > >> >> > > -- > >> >> > > Mikey M. > >> >> > > > >> >> > > > >> >> > > "Damir" wrote: > >> >> > > > >> >> > >> Make backup of databases. > >> >> > >> Restore databases on SQL2005 > >> >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear > >> >> > >> Organization > >> >> > >> name > >> >> > >> and GUIDS. > >> >> > >> > >> >> > >> Run Microsoft CRM 3.0 installation and click "connect to > >> >> > >> existing" > >> >> > >> > >> >> > >> "MikeyM" wrote: > >> >> > >> > >> >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. > >> >> > >> > They > >> >> > >> > just > >> >> > >> > bought > >> >> > >> > a professional license and are trying to install MS CRM on a > >> >> > >> > new > >> >> > >> > box > >> >> > >> > (Window > >> >> > >> > Server 2003) along with databases using SQL 2005. I am > >> >> > >> > searching > >> >> > >> > for > >> >> > >> > a > >> >> > >> > way > >> >> > >> > moving the database (SQL2000) from SBS to the new Window Server > >> >> > >> > 2003 > >> >> > >> > box > >> >> > >> > using SQL 2005. Any suggestion? > >> >> > >> > > >> >> > >> > Thanks > >> >> > >> > > >> >> > >> > -- > >> >> > >> > Mikey M. > >> >> > > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
|
|
28-11-2007, 03:36 PM
|
#14 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
Well, you're one step ahead of me - that was the next step - I just wanted
to make sure first that buildversion was indeed causing the problem. Glad to hear the problem is resolved. Cheers -- George Doubinski CRM Certified Professional - Developer "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message news:3B6BA60C-3F92-46C9-A874-452AE8FE2F0F@microsoft.com... >I took care of it by issueing this statement on MS CRM database "Update > BuildVersion set Revision = 9 where BuildNumber = 5300" > > Thanks soooo much for all the help. > -- > Mikey M. > > > "George Doubinski" wrote: > >> Hi Mikey, >> >> it might be not as bad as it looks. Can you post the content of your >> BuildVersion table? >> >> Cheers >> >> -- >> George Doubinski >> CRM Certified Professional - Developer >> >> >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message >> news:E7053968-A467-40D2-840D-AD88CA88C4C7@microsoft.com... >> > Hi George! >> > >> > I tried removing all entries in license table. It did not solve the >> > problem. >> > It still gave me the same error "Setup detected a version mismatch >> > between >> > the specified database and the current product." Somehow, MS CRM thinks >> > the >> > database is in MS CRM version 1.2 instead. Any idea? Anyone has any >> > idea? >> > Please help >> > >> > -- >> > Mikey M. >> > >> > >> > "George Doubinski" wrote: >> > >> >> Hi Mikey, >> >> >> >> I'd be inclined to backup the databases, delete all entries in license >> >> table >> >> and then try the new installation connecting to this database. This >> >> approach >> >> seems to work if you want CRM to "forget" the previous licensing keys >> >> altogether. I'm not sure if this is not a more serious issue but it's >> >> worth >> >> the shot. >> >> >> >> Hope this helps >> >> -- >> >> George Doubinski >> >> CRM Certified Professional - Developer >> >> >> >> >> >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message >> >> news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... >> >> > Haven't heard from anyone so I thought I would repost my reply here: >> >> > >> >> > "Thank you! The KB helped me went a step futher. I am now getting >> >> > "Setup >> >> > has >> >> > detected that the version of your current Microsoft CRM 1.2 database >> >> > does >> >> > not >> >> > match the version required." during the MS CRM installation. We are >> >> > currently >> >> > using MS CRM 3.0 for SBS not 1.2. Please help! " >> >> > >> >> > -- >> >> > Mikey M. >> >> > >> >> > >> >> > "Matt Parks" wrote: >> >> > >> >> >> FYI, redeployment is not needed if you stay within the same domain. >> >> >> Deployment manager can be used to "point" to the resotred DBs on >> >> >> another >> >> >> server or an install on a new server can "use" those existing (ie. >> >> >> restored) >> >> >> DBs. >> >> >> >> >> >> -- >> >> >> >> >> >> Matt Parks >> >> >> MVP - Dynamics CRM >> >> >> >> >> >> >> >> >> "Damir" <Damir@discussions.microsoft.com> wrote in message >> >> >> news 54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...>> >> >> So you have trial license in your existing CRM since you cant use >> >> >> Trial >> >> >> Key >> >> >> Pro I gave to you ? >> >> >> >> >> >> If the KB cant fix it to you, then you open the MSCRM database and >> >> >> find >> >> >> dbo.License under tables, open then table and remove the cdkey from >> >> >> there. >> >> >> >> >> >> "George Doubinski" wrote: >> >> >> >> >> >> > Hi Mikey, >> >> >> > >> >> >> > http://support.microsoft.com/kb/934691 answers your question. >> >> >> > Basically, >> >> >> > you >> >> >> > have to upgrade the license first then redeploy. >> >> >> > >> >> >> > Hope this helps. >> >> >> > >> >> >> > -- >> >> >> > George Doubinski >> >> >> > CRM Certified Professional - Developer >> >> >> > >> >> >> > >> >> >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message >> >> >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... >> >> >> > >I did as you suggested. Got an error saying 'You cannot mix >> >> >> > >Small >> >> >> > >Business >> >> >> > > Edition and Professional Edition license keys in one >> >> >> > > deployment'. >> >> >> > > Any >> >> >> > > idea? >> >> >> > > -- >> >> >> > > Mikey M. >> >> >> > > >> >> >> > > >> >> >> > > "Damir" wrote: >> >> >> > > >> >> >> > >> Make backup of databases. >> >> >> > >> Restore databases on SQL2005 >> >> >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear >> >> >> > >> Organization >> >> >> > >> name >> >> >> > >> and GUIDS. >> >> >> > >> >> >> >> > >> Run Microsoft CRM 3.0 installation and click "connect to >> >> >> > >> existing" >> >> >> > >> >> >> >> > >> "MikeyM" wrote: >> >> >> > >> >> >> >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. >> >> >> > >> > They >> >> >> > >> > just >> >> >> > >> > bought >> >> >> > >> > a professional license and are trying to install MS CRM on a >> >> >> > >> > new >> >> >> > >> > box >> >> >> > >> > (Window >> >> >> > >> > Server 2003) along with databases using SQL 2005. I am >> >> >> > >> > searching >> >> >> > >> > for >> >> >> > >> > a >> >> >> > >> > way >> >> >> > >> > moving the database (SQL2000) from SBS to the new Window >> >> >> > >> > Server >> >> >> > >> > 2003 >> >> >> > >> > box >> >> >> > >> > using SQL 2005. Any suggestion? >> >> >> > >> > >> >> >> > >> > Thanks >> >> >> > >> > >> >> >> > >> > -- >> >> >> > >> > Mikey M. >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> |
|
|
|
11-01-2008, 12:36 PM
|
#15 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
hi there,
i had the same problem like MikeyM...and solved the problem using the same query. still i don't know what's happening behind the scene. can you plz explain why the buildversion needs to be updated. thanx in advance imran "MikeyM" wrote: > I took care of it by issueing this statement on MS CRM database "Update > BuildVersion set Revision = 9 where BuildNumber = 5300" > > Thanks soooo much for all the help. > -- > Mikey M. > > > "George Doubinski" wrote: > > > Hi Mikey, > > > > it might be not as bad as it looks. Can you post the content of your > > BuildVersion table? > > > > Cheers > > > > -- > > George Doubinski > > CRM Certified Professional - Developer > > > > > > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > news:E7053968-A467-40D2-840D-AD88CA88C4C7@microsoft.com... > > > Hi George! > > > > > > I tried removing all entries in license table. It did not solve the > > > problem. > > > It still gave me the same error "Setup detected a version mismatch > > > between > > > the specified database and the current product." Somehow, MS CRM thinks > > > the > > > database is in MS CRM version 1.2 instead. Any idea? Anyone has any idea? > > > Please help > > > > > > -- > > > Mikey M. > > > > > > > > > "George Doubinski" wrote: > > > > > >> Hi Mikey, > > >> > > >> I'd be inclined to backup the databases, delete all entries in license > > >> table > > >> and then try the new installation connecting to this database. This > > >> approach > > >> seems to work if you want CRM to "forget" the previous licensing keys > > >> altogether. I'm not sure if this is not a more serious issue but it's > > >> worth > > >> the shot. > > >> > > >> Hope this helps > > >> -- > > >> George Doubinski > > >> CRM Certified Professional - Developer > > >> > > >> > > >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > >> news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... > > >> > Haven't heard from anyone so I thought I would repost my reply here: > > >> > > > >> > "Thank you! The KB helped me went a step futher. I am now getting > > >> > "Setup > > >> > has > > >> > detected that the version of your current Microsoft CRM 1.2 database > > >> > does > > >> > not > > >> > match the version required." during the MS CRM installation. We are > > >> > currently > > >> > using MS CRM 3.0 for SBS not 1.2. Please help! " > > >> > > > >> > -- > > >> > Mikey M. > > >> > > > >> > > > >> > "Matt Parks" wrote: > > >> > > > >> >> FYI, redeployment is not needed if you stay within the same domain. > > >> >> Deployment manager can be used to "point" to the resotred DBs on > > >> >> another > > >> >> server or an install on a new server can "use" those existing (ie. > > >> >> restored) > > >> >> DBs. > > >> >> > > >> >> -- > > >> >> > > >> >> Matt Parks > > >> >> MVP - Dynamics CRM > > >> >> > > >> >> > > >> >> "Damir" <Damir@discussions.microsoft.com> wrote in message > > >> >> news 54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...> > >> >> So you have trial license in your existing CRM since you cant use > > >> >> Trial > > >> >> Key > > >> >> Pro I gave to you ? > > >> >> > > >> >> If the KB cant fix it to you, then you open the MSCRM database and > > >> >> find > > >> >> dbo.License under tables, open then table and remove the cdkey from > > >> >> there. > > >> >> > > >> >> "George Doubinski" wrote: > > >> >> > > >> >> > Hi Mikey, > > >> >> > > > >> >> > http://support.microsoft.com/kb/934691 answers your question. > > >> >> > Basically, > > >> >> > you > > >> >> > have to upgrade the license first then redeploy. > > >> >> > > > >> >> > Hope this helps. > > >> >> > > > >> >> > -- > > >> >> > George Doubinski > > >> >> > CRM Certified Professional - Developer > > >> >> > > > >> >> > > > >> >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > >> >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... > > >> >> > >I did as you suggested. Got an error saying 'You cannot mix Small > > >> >> > >Business > > >> >> > > Edition and Professional Edition license keys in one deployment'. > > >> >> > > Any > > >> >> > > idea? > > >> >> > > -- > > >> >> > > Mikey M. > > >> >> > > > > >> >> > > > > >> >> > > "Damir" wrote: > > >> >> > > > > >> >> > >> Make backup of databases. > > >> >> > >> Restore databases on SQL2005 > > >> >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear > > >> >> > >> Organization > > >> >> > >> name > > >> >> > >> and GUIDS. > > >> >> > >> > > >> >> > >> Run Microsoft CRM 3.0 installation and click "connect to > > >> >> > >> existing" > > >> >> > >> > > >> >> > >> "MikeyM" wrote: > > >> >> > >> > > >> >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. > > >> >> > >> > They > > >> >> > >> > just > > >> >> > >> > bought > > >> >> > >> > a professional license and are trying to install MS CRM on a > > >> >> > >> > new > > >> >> > >> > box > > >> >> > >> > (Window > > >> >> > >> > Server 2003) along with databases using SQL 2005. I am > > >> >> > >> > searching > > >> >> > >> > for > > >> >> > >> > a > > >> >> > >> > way > > >> >> > >> > moving the database (SQL2000) from SBS to the new Window Server > > >> >> > >> > 2003 > > >> >> > >> > box > > >> >> > >> > using SQL 2005. Any suggestion? > > >> >> > >> > > > >> >> > >> > Thanks > > >> >> > >> > > > >> >> > >> > -- > > >> >> > >> > Mikey M. > > >> >> > > > >> >> > > > >> >> > > > >> >> > > >> >> > > >> >> > > >> > > >> > > >> > > > > > > |
|
|
|
11-01-2008, 12:36 PM
|
#16 |
|
Guest
Posts: n/a
|
Re: Moving SBS MS CRM database to a new Server
hi there,
i had the same problem like MikeyM...and solved the problem using the same query. still i don't know what's happening behind the scene. can you plz explain why the buildversion needs to be updated. thanx in advance imran "MikeyM" wrote: > I took care of it by issueing this statement on MS CRM database "Update > BuildVersion set Revision = 9 where BuildNumber = 5300" > > Thanks soooo much for all the help. > -- > Mikey M. > > > "George Doubinski" wrote: > > > Hi Mikey, > > > > it might be not as bad as it looks. Can you post the content of your > > BuildVersion table? > > > > Cheers > > > > -- > > George Doubinski > > CRM Certified Professional - Developer > > > > > > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > news:E7053968-A467-40D2-840D-AD88CA88C4C7@microsoft.com... > > > Hi George! > > > > > > I tried removing all entries in license table. It did not solve the > > > problem. > > > It still gave me the same error "Setup detected a version mismatch > > > between > > > the specified database and the current product." Somehow, MS CRM thinks > > > the > > > database is in MS CRM version 1.2 instead. Any idea? Anyone has any idea? > > > Please help > > > > > > -- > > > Mikey M. > > > > > > > > > "George Doubinski" wrote: > > > > > >> Hi Mikey, > > >> > > >> I'd be inclined to backup the databases, delete all entries in license > > >> table > > >> and then try the new installation connecting to this database. This > > >> approach > > >> seems to work if you want CRM to "forget" the previous licensing keys > > >> altogether. I'm not sure if this is not a more serious issue but it's > > >> worth > > >> the shot. > > >> > > >> Hope this helps > > >> -- > > >> George Doubinski > > >> CRM Certified Professional - Developer > > >> > > >> > > >> "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > >> news:6C1C9E58-59E5-4A3B-9C59-AE8A72F3DD2A@microsoft.com... > > >> > Haven't heard from anyone so I thought I would repost my reply here: > > >> > > > >> > "Thank you! The KB helped me went a step futher. I am now getting > > >> > "Setup > > >> > has > > >> > detected that the version of your current Microsoft CRM 1.2 database > > >> > does > > >> > not > > >> > match the version required." during the MS CRM installation. We are > > >> > currently > > >> > using MS CRM 3.0 for SBS not 1.2. Please help! " > > >> > > > >> > -- > > >> > Mikey M. > > >> > > > >> > > > >> > "Matt Parks" wrote: > > >> > > > >> >> FYI, redeployment is not needed if you stay within the same domain. > > >> >> Deployment manager can be used to "point" to the resotred DBs on > > >> >> another > > >> >> server or an install on a new server can "use" those existing (ie. > > >> >> restored) > > >> >> DBs. > > >> >> > > >> >> -- > > >> >> > > >> >> Matt Parks > > >> >> MVP - Dynamics CRM > > >> >> > > >> >> > > >> >> "Damir" <Damir@discussions.microsoft.com> wrote in message > > >> >> news 54F7CC3-F595-4C81-8E68-688CE2BB8730@microsoft.com...> > >> >> So you have trial license in your existing CRM since you cant use > > >> >> Trial > > >> >> Key > > >> >> Pro I gave to you ? > > >> >> > > >> >> If the KB cant fix it to you, then you open the MSCRM database and > > >> >> find > > >> >> dbo.License under tables, open then table and remove the cdkey from > > >> >> there. > > >> >> > > >> >> "George Doubinski" wrote: > > >> >> > > >> >> > Hi Mikey, > > >> >> > > > >> >> > http://support.microsoft.com/kb/934691 answers your question. > > >> >> > Basically, > > >> >> > you > > >> >> > have to upgrade the license first then redeploy. > > >> >> > > > >> >> > Hope this helps. > > >> >> > > > >> >> > -- > > >> >> > George Doubinski > > >> >> > CRM Certified Professional - Developer > > >> >> > > > >> >> > > > >> >> > "MikeyM" <MikeyM@discussions.microsoft.com> wrote in message > > >> >> > news:0A59740E-9C2F-42EC-AFBC-D5FC9FE7940D@microsoft.com... > > >> >> > >I did as you suggested. Got an error saying 'You cannot mix Small > > >> >> > >Business > > >> >> > > Edition and Professional Edition license keys in one deployment'. > > >> >> > > Any > > >> >> > > idea? > > >> >> > > -- > > >> >> > > Mikey M. > > >> >> > > > > >> >> > > > > >> >> > > "Damir" wrote: > > >> >> > > > > >> >> > >> Make backup of databases. > > >> >> > >> Restore databases on SQL2005 > > >> >> > >> Run RedeploymentTool which is on CRM Cd1 which will clear > > >> >> > >> Organization > > >> >> > >> name > > >> >> > >> and GUIDS. > > >> >> > >> > > >> >> > >> Run Microsoft CRM 3.0 installation and click "connect to > > >> >> > >> existing" > > >> >> > >> > > >> >> > >> "MikeyM" wrote: > > >> >> > >> > > >> >> > >> > Our client is currently using SBS MS CRM 3.0 with SQL 2000. > > >> >> > >> > They > > >> >> > >> > just > > >> >> > >> > bought > > >> >> > >> > a professional license and are trying to install MS CRM on a > > >> >> > >> > new > > >> >> > >> > box > > >> >> > >> > (Window > > >> >> > >> > Server 2003) along with databases using SQL 2005. I am > > >> >> > >> > searching > > >> >> > >> > for > > >> >> > >> > a > > >> >> > >> > way > > >> >> > >> > moving the database (SQL2000) from SBS to the new Window Server > > >> >> > >> > 2003 > > >> >> > >> > box > > >> >> > >> > using SQL 2005. Any suggestion? > > >> >> > >> > > > >> >> > >> > Thanks > > >> >> > >> > > > >> >> > >> > -- > > >> >> > >> > Mikey M. > > >> >> > > > >> >> > > > >> >> > > > >> >> > > >> >> > > >> >> > > >> > > >> > > >> > > > > > > |
|
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
