TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft Dynamics CRM

Notices

Reply
 
Thread Tools Display Modes
Old 28-11-2007, 03:36 PM   #1
MikeyM
Guest
 
Posts: n/a
Moving SBS MS CRM database to a new Server

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.
  Reply With Quote
Old 28-11-2007, 03:36 PM   #2
Damir
Guest
 
Posts: n/a
RE: Moving SBS MS CRM database to a new Server

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.

  Reply With Quote
Old 28-11-2007, 03:36 PM   #3
MikeyM
Guest
 
Posts: n/a
RE: Moving SBS MS CRM database to a new Server

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.

  Reply With Quote
Old 28-11-2007, 03:36 PM   #4
George Doubinski
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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.



  Reply With Quote
Old 28-11-2007, 03:36 PM   #5
Damir
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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.

>
>
>

  Reply With Quote
Old 28-11-2007, 03:36 PM   #6
Matt Parks
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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
news54F7CC3-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.

>
>
>



  Reply With Quote
Old 28-11-2007, 03:36 PM   #7
MikeyM
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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.


"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.

>
>
>

  Reply With Quote
Old 28-11-2007, 03:36 PM   #8
MikeyM
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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.


"Damir" wrote:

> 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.

> >
> >
> >

  Reply With Quote
Old 28-11-2007, 03:36 PM   #9
MikeyM
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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
> news54F7CC3-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.

> >
> >
> >

>
>
>

  Reply With Quote
Old 28-11-2007, 03:36 PM   #10
George Doubinski
Guest
 
Posts: n/a
Re: Moving SBS MS CRM database to a new Server

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
>> news54F7CC3-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.
>> >
>> >
>> >

>>
>>
>>



  Reply With Quote
Reply

Thread Tools
Display Modes


Google
 


All times are GMT +5.5. The time now is 02:21 AM.


vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2008, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional