Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple of
problems.

The first is a CRM Server User Input error that states "syntax reeor
converting varchar value false to a columb of data type bit

And the second that the minimum required version is SQL 2005 SP2 (9.00.3042)

We're running SBS 2003.

Thanks

Re: CRM3 to CRM4 upgrade for SBS2003 by Peter

Peter
Mon Apr 21 06:11:47 CDT 2008

SBS2003 - you need SBS2003 R2 for SQL 2005 ( workgroup edition which is
fine )

http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/prodinfo.mspx

As for your other error - not even worth trying to resolve till you have
SQL2005 SP2 installed

Pete

"Pat Horridge" <pat@remove-spam.vet.co.uk> wrote in message
news:fuhl0u$j4j$1$8300dec7@news.demon.co.uk...
> Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple of
> problems.
>
> The first is a CRM Server User Input error that states "syntax reeor
> converting varchar value false to a columb of data type bit
>
> And the second that the minimum required version is SQL 2005 SP2
> (9.00.3042)
>
> We're running SBS 2003.
>
> Thanks
>
>



Re: CRM3 to CRM4 upgrade for SBS2003 by Pat

Pat
Mon Apr 21 08:26:19 CDT 2008

Thanks Peter. Looks liek your right.
Unfortunatley there doesn't seem to be a low cost upgrade route for SBS 2003
to R2.
Best price I've had is over £400
Real blow as having got to grips with CRM 3 I can now see how much beter CRM
4 is for what we need. Just hadn't figured on needing to upgrade the OS as
well. My slip up!

"Peter Hale" <p0911@hotmail.com> wrote in message
news:ufcGAC6oIHA.4292@TK2MSFTNGP04.phx.gbl...
> SBS2003 - you need SBS2003 R2 for SQL 2005 ( workgroup edition which is
> fine )
>
> http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/prodinfo.mspx
>
> As for your other error - not even worth trying to resolve till you have
> SQL2005 SP2 installed
>
> Pete
>
> "Pat Horridge" <pat@remove-spam.vet.co.uk> wrote in message
> news:fuhl0u$j4j$1$8300dec7@news.demon.co.uk...
>> Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple of
>> problems.
>>
>> The first is a CRM Server User Input error that states "syntax reeor
>> converting varchar value false to a columb of data type bit
>>
>> And the second that the minimum required version is SQL 2005 SP2
>> (9.00.3042)
>>
>> We're running SBS 2003.
>>
>> Thanks
>>
>>
>
>



Re: CRM3 to CRM4 upgrade for SBS2003 by Peter

Peter
Mon Apr 21 16:06:29 CDT 2008

It all comes down to cost benefit

"Pat Horridge" <pat@remove-spam.vet.co.uk> wrote in message
news:fui4lr$9nq$1$8300dec7@news.demon.co.uk...
> Thanks Peter. Looks liek your right.
> Unfortunatley there doesn't seem to be a low cost upgrade route for SBS
> 2003 to R2.
> Best price I've had is over £400
> Real blow as having got to grips with CRM 3 I can now see how much beter
> CRM 4 is for what we need. Just hadn't figured on needing to upgrade the
> OS as well. My slip up!
>
> "Peter Hale" <p0911@hotmail.com> wrote in message
> news:ufcGAC6oIHA.4292@TK2MSFTNGP04.phx.gbl...
>> SBS2003 - you need SBS2003 R2 for SQL 2005 ( workgroup edition which is
>> fine )
>>
>> http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/prodinfo.mspx
>>
>> As for your other error - not even worth trying to resolve till you have
>> SQL2005 SP2 installed
>>
>> Pete
>>
>> "Pat Horridge" <pat@remove-spam.vet.co.uk> wrote in message
>> news:fuhl0u$j4j$1$8300dec7@news.demon.co.uk...
>>> Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple
>>> of problems.
>>>
>>> The first is a CRM Server User Input error that states "syntax reeor
>>> converting varchar value false to a columb of data type bit
>>>
>>> And the second that the minimum required version is SQL 2005 SP2
>>> (9.00.3042)
>>>
>>> We're running SBS 2003.
>>>
>>> Thanks
>>>
>>>
>>
>>
>
>



RE: CRM3 to CRM4 upgrade for SBS2003 by Hasan

Hasan
Thu May 08 09:31:06 CDT 2008

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

Download and Try

Hasan

"Pat Horridge" wrote:

> Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple of
> problems.
>
> The first is a CRM Server User Input error that states "syntax reeor
> converting varchar value false to a columb of data type bit
>
> And the second that the minimum required version is SQL 2005 SP2 (9.00.3042)
>
> We're running SBS 2003.
>
> Thanks
>
>
>

Re: CRM3 to CRM4 upgrade for SBS2003 by LeonTribe

LeonTribe
Sat May 10 01:56:34 CDT 2008

On Apr 21, 11:26=A0pm, "Pat Horridge" <p...@remove-spam.vet.co.uk>
wrote:
> Thanks Peter. Looks liek your right.
> Unfortunatley there doesn't seem to be a low cost upgrade route for SBS 20=
03
> to R2.
> Best price I've had is over =A3400
> Real blow as having got to grips with CRM 3 I can now see how much beter C=
RM
> 4 is for what we need. Just hadn't figured on needing to upgrade the OS as=

> well. My slip up!
>
> "Peter Hale" <p0...@hotmail.com> wrote in message
>
> news:ufcGAC6oIHA.4292@TK2MSFTNGP04.phx.gbl...
>
>
>
> > SBS2003 - =A0you need SBS2003 R2 for SQL 2005 ( workgroup edition which =
is
> > fine )
>
> >http://www.microsoft.com/windowsserver2003/sbs/evaluation/faq/prodinf...
>
> > As for your other error - not even worth trying to resolve till you have=

> > SQL2005 SP2 installed
>
> > Pete
>
> > "Pat Horridge" <p...@remove-spam.vet.co.uk> wrote in message
> >news:fuhl0u$j4j$1$8300dec7@news.demon.co.uk...
> >> Just tried running our upgrade from CRM3.0 to CRM4.0 and have a couple =
of
> >> problems.
>
> >> The first is a CRM Server User Input error that states "syntax reeor
> >> converting varchar value false to a columb of data type bit
>
> >> And the second that the minimum required version is SQL 2005 SP2
> >> (9.00.3042)
>
> >> We're running SBS 2003.
>
> >> Thanks- Hide quoted text -
>
> - Show quoted text -

The only part that really needs upgrading is SQL Server. If it helps
the argument to the boss, you'd need SQL 2005 regardless as SQL 2000
is not supported by CRM 4.

Leon Tribe