BCM 2007 on SQL 2000 server yehia[ at ]iinet.net.au 2/2/2007 4:19:56 AM Hi all, I have been doing a lot of reading on this topic and although some people hinted that this can be done, not one has actually confirmed it nor posted any step by step guide at doing so. I realise that a whitepaper is available for BCM 2007 deployment on sbs 2003 R2 with SQL 2005 workgroup: http://download.microsoft.com/ download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc but is the above applicable to sql 2000 server? I am trying to have the DB in sql 2000 rather then 2005 express in order to bypass the 4 gig limit on the DB size. any help, guidance or advice would be greatly appreciated. Kind Regards,

Re: BCM 2007 on SQL 2000 server "Luther" <enowning[ at ]gmail.com> 2/2/2007 3:23:55 PM On Feb 1, 8:19 pm, y...[ at ]iinet.net.au wrote: [Quoted Text] > Hi all, > > I have been doing a lot of reading on this topic and although some > people hinted that this can be done, not one has actually confirmed it > nor posted any step by step guide at doing so. > > I realise that a whitepaper is available for BCM 2007 deployment on > sbs 2003 R2 with SQL 2005 workgroup:http://download.microsoft.com/ > download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc > > but is the above applicable to sql 2000 server? > > I am trying to have the DB in sql 2000 rather then 2005 express in > order to bypass the 4 gig limit on the DB size. > > any help, guidance or advice would be greatly appreciated. > > Kind Regards, No. sql 2000 is not supported with BCM v3/2007. I've never heard of anyone running into the 4 gig limit though, nor running into MSDE's 2 gig limit with BCM v1 or v2. I would expect Outlook to run too slowly to be useful if it was managing millions of emails and contacts.

Re: BCM 2007 on SQL 2000 server yehia[ at ]iinet.net.au 2/3/2007 1:45:47 AM Thanks for the quick reply luther. I understand it is not supported (by MS) but would you know if it is technically doable? Cheers, On Feb 3, 2:23 am, "Luther" <enown...[ at ]gmail.com> wrote: [Quoted Text] > On Feb 1, 8:19 pm, y...[ at ]iinet.net.au wrote: > > > > > > > Hi all, > > > I have been doing a lot of reading on this topic and although some > > people hinted that this can be done, not one has actually confirmed it > > nor posted any step by step guide at doing so. > > > I realise that a whitepaper is available for BCM 2007 deployment on > > sbs 2003 R2 with SQL 2005 workgroup:http://download.microsoft.com/ > > download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc > > > but is the above applicable to sql 2000 server? > > > I am trying to have the DB in sql 2000 rather then 2005 express in > > order to bypass the 4 gig limit on the DB size. > > > any help, guidance or advice would be greatly appreciated. > > > Kind Regards, > > No. sql 2000 is not supported with BCM v3/2007. > > I've never heard of anyone running into the 4 gig limit though, nor > running into MSDE's 2 gig limit with BCM v1 or v2. > > I would expect Outlook to run too slowly to be useful if it was > managing millions of emails and contacts.- Hide quoted text - > > - Show quoted text -

Re: BCM 2007 on SQL 2000 server "Luther" <enowning[ at ]gmail.com> 2/4/2007 8:47:07 PM On Feb 2, 5:45 pm, y...[ at ]iinet.net.au wrote: [Quoted Text] > Thanks for the quick reply luther. > > I understand it is not supported (by MS) but would you know if it is > technically doable? > > Cheers, > > On Feb 3, 2:23 am, "Luther" <enown...[ at ]gmail.com> wrote: > > > > > On Feb 1, 8:19 pm, y...[ at ]iinet.net.au wrote: > > > > Hi all, > > > > I have been doing a lot of reading on this topic and although some > > > people hinted that this can be done, not one has actually confirmed it > > > nor posted any step by step guide at doing so. > > > > I realise that a whitepaper is available for BCM 2007 deployment on > > > sbs 2003 R2 with SQL 2005 workgroup:http://download.microsoft.com/ > > > download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc > > > > but is the above applicable to sql 2000 server? > > > > I am trying to have the DB in sql 2000 rather then 2005 express in > > > order to bypass the 4 gig limit on the DB size. > > > > any help, guidance or advice would be greatly appreciated. > > > > Kind Regards, > > > No. sql 2000 is not supported with BCM v3/2007. > > > I've never heard of anyone running into the 4 gig limit though, nor > > running into MSDE's 2 gig limit with BCM v1 or v2. > > > I would expect Outlook to run too slowly to be useful if it was > > managing millions of emails and contacts.- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - Potantially doable. I haven't tried it, but in my experience BCM tends to use the database through regular ADO interfaces, and the database itself seems to use familar features--I haven't come across BCM using any Sql 2005 features. However, they won't support you if something doesn't work, and your installation will probably be less secure.

Re: BCM 2007 on SQL 2000 server yehia[ at ]iinet.net.au 2/4/2007 11:30:18 PM Would the following path be advised: 1. install BCM 2007 on a server 2. share the databse 3. If the 4 gig limit on sql 2005 express looks like being reached, upgrade sbs2003 sp1 to R2 or if we are pushing the 4 gig limit we probably should be looking at CRM3 anyway. Does that sound about right? On Feb 5, 7:47 am, "Luther" <enown...[ at ]gmail.com> wrote: [Quoted Text] > On Feb 2, 5:45 pm, y...[ at ]iinet.net.au wrote: > > > > > > > Thanks for the quick reply luther. > > > I understand it is not supported (by MS) but would you know if it is > > technically doable? > > > Cheers, > > > On Feb 3, 2:23 am, "Luther" <enown...[ at ]gmail.com> wrote: > > > > On Feb 1, 8:19 pm, y...[ at ]iinet.net.au wrote: > > > > > Hi all, > > > > > I have been doing a lot of reading on this topic and although some > > > > people hinted that this can be done, not one has actually confirmed it > > > > nor posted any step by step guide at doing so. > > > > > I realise that a whitepaper is available for BCM 2007 deployment on > > > > sbs 2003 R2 with SQL 2005 workgroup:http://download.microsoft.com/ > > > > download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc > > > > > but is the above applicable to sql 2000 server? > > > > > I am trying to have the DB in sql 2000 rather then 2005 express in > > > > order to bypass the 4 gig limit on the DB size. > > > > > any help, guidance or advice would be greatly appreciated. > > > > > Kind Regards, > > > > No. sql 2000 is not supported with BCM v3/2007. > > > > I've never heard of anyone running into the 4 gig limit though, nor > > > running into MSDE's 2 gig limit with BCM v1 or v2. > > > > I would expect Outlook to run too slowly to be useful if it was > > > managing millions of emails and contacts.- Hide quoted text - > > > > - Show quoted text -- Hide quoted text - > > > - Show quoted text - > > Potantially doable. I haven't tried it, but in my experience BCM tends > to use the database through regular ADO interfaces, and the database > itself seems to use familar features--I haven't come across BCM using > any Sql 2005 features. However, they won't support you if something > doesn't work, and your installation will probably be less secure.- Hide quoted text - > > - Show quoted text -

Re: BCM 2007 on SQL 2000 server "Luther" <enowning[ at ]gmail.com> 2/5/2007 1:21:55 PM On Feb 4, 3:30 pm, y...[ at ]iinet.net.au wrote: [Quoted Text] > Would the following path be advised: > > 1. install BCM 2007 on a server > 2. share the databse > 3. If the 4 gig limit on sql 2005 express looks like being reached, > upgrade sbs2003 sp1 to R2 > > or > > if we are pushing the 4 gig limit we probably should be looking at > CRM3 anyway. > > Does that sound about right? > > On Feb 5, 7:47 am, "Luther" <enown...[ at ]gmail.com> wrote: > > > > > On Feb 2, 5:45 pm, y...[ at ]iinet.net.au wrote: > > > > Thanks for the quick reply luther. > > > > I understand it is not supported (by MS) but would you know if it is > > > technically doable? > > > > Cheers, > > > > On Feb 3, 2:23 am, "Luther" <enown...[ at ]gmail.com> wrote: > > > > > On Feb 1, 8:19 pm, y...[ at ]iinet.net.au wrote: > > > > > > Hi all, > > > > > > I have been doing a lot of reading on this topic and although some > > > > > people hinted that this can be done, not one has actually confirmed it > > > > > nor posted any step by step guide at doing so. > > > > > > I realise that a whitepaper is available for BCM 2007 deployment on > > > > > sbs 2003 R2 with SQL 2005 workgroup:http://download.microsoft.com/ > > > > > download/e/a/9/ea922f63-dff5-45db-9c83-d0267daf805d/bcm_sql.doc > > > > > > but is the above applicable to sql 2000 server? > > > > > > I am trying to have the DB in sql 2000 rather then 2005 express in > > > > > order to bypass the 4 gig limit on the DB size. > > > > > > any help, guidance or advice would be greatly appreciated. > > > > > > Kind Regards, > > > > > No. sql 2000 is not supported with BCM v3/2007. > > > > > I've never heard of anyone running into the 4 gig limit though, nor > > > > running into MSDE's 2 gig limit with BCM v1 or v2. > > > > > I would expect Outlook to run too slowly to be useful if it was > > > > managing millions of emails and contacts.- Hide quoted text - > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text - > > > Potantially doable. I haven't tried it, but in my experience BCM tends > > to use the database through regular ADO interfaces, and the database > > itself seems to use familar features--I haven't come across BCM using > > any Sql 2005 features. However, they won't support you if something > > doesn't work, and your installation will probably be less secure.- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - I definately favor installing BCM, and letting it setup up Sql and create the database over the alternative of doing the same manually. BCM configures a bunch of Sql related settings (instance name, tcp port) and if you replicate that process manually, and miss one setting, finding it can take to many hours of frustrating work. And once you have the database running on Express, upgrading it to a more powerful version of Sql can be fairly straightforward. I also concur that if you anticipate more than 4 gig of data, BCM is probably not the right option for you. To manage that much data you probably need features that BCM doesn't provide in areas like user management. I think that your users' requirements (features, etc.) are what will ultimately drive the choice of what software is best for your installation, rather than the quantity of raw data--4 gigs is A LOT of contacts and associated data.