Group:  Microsoft Outlook ยป microsoft.public.outlook.bcm
Thread: BCM Database on central SQL server?

Geek News

BCM Database on central SQL server?
JurijK 10/13/2008 6:23:00 AM
Hi! Our company runs SBS2003 server, clients have Office 2007 SB, includes
also BCM.
I wanted to have a centralized database on our server as client computers
are either not always on or are not present (notebooks) to share the DB.
Besides, do not want to waste one Office license to run BCM "server" on one
additional station.
I have found the "Business Contact Manager for Outlook 2007 Database Tool"
provided by MS as free download. Promises to create a centralized database on
servers where Outlook/BCM are not installed. I have also installed "SQL 2005
Express SP2" on my SBS2003 and made sure my .NET environment is more recent
then requested by the "Database Tool" installation program. It is 3.5 SP1 now.
After running the "Database Tools" and creating the database I also added
users.
On client computers however attempts to connect to the database remain
unsuccessful. The Wizard claims there was no valid BCM database present on
the selected server.
Have tried to work around by simply detaching the database created on one of
client's PCs and moving it to SBS2003 server and manually attaching it there.
Suddenly the BCM DB Wizard on client computer found it but not even the
creator could manage the database (like change client permission list, like
who can connect and who not). Even if result was not useful, it has proven
the SQL2005Xpress server to be visible and properly configured?
As it appears, the "Business Contact Manager for Outlook 2007 Database Tool"
does not create a database, that would be recognized by my version of BCM as
a valid database.
Is there any workaround? Update? Fix? Pls help!
Re: BCM Database on central SQL server?
"AllenM" <noreply[ at ]NoEmail.com> 10/13/2008 3:38:44 PM
I've just installed BCM on my SBS 2003 server with no Outlook or BCM
installed and it works just fine. I found that if you do not type the exact
correct infromation for the server name it will return that error. When you
finished installing and configuring the BCM DB Tool it should have brought
up an html page with the instructions on how to connect to the server and
database as well as the correct server and database instance name.


"JurijK" <JurijK[ at ]discussions.microsoft.com> wrote in message
news:B9329AC3-4F04-47B8-A73E-4897F94DD84B[ at ]microsoft.com...
[Quoted Text]
> Hi! Our company runs SBS2003 server, clients have Office 2007 SB, includes
> also BCM.
> I wanted to have a centralized database on our server as client computers
> are either not always on or are not present (notebooks) to share the DB.
> Besides, do not want to waste one Office license to run BCM "server" on
> one
> additional station.
> I have found the "Business Contact Manager for Outlook 2007 Database Tool"
> provided by MS as free download. Promises to create a centralized database
> on
> servers where Outlook/BCM are not installed. I have also installed "SQL
> 2005
> Express SP2" on my SBS2003 and made sure my .NET environment is more
> recent
> then requested by the "Database Tool" installation program. It is 3.5 SP1
> now.
> After running the "Database Tools" and creating the database I also added
> users.
> On client computers however attempts to connect to the database remain
> unsuccessful. The Wizard claims there was no valid BCM database present on
> the selected server.
> Have tried to work around by simply detaching the database created on one
> of
> client's PCs and moving it to SBS2003 server and manually attaching it
> there.
> Suddenly the BCM DB Wizard on client computer found it but not even the
> creator could manage the database (like change client permission list,
> like
> who can connect and who not). Even if result was not useful, it has proven
> the SQL2005Xpress server to be visible and properly configured?
> As it appears, the "Business Contact Manager for Outlook 2007 Database
> Tool"
> does not create a database, that would be recognized by my version of BCM
> as
> a valid database.
> Is there any workaround? Update? Fix? Pls help!


Re: BCM Database on central SQL server?
JurijK 10/14/2008 12:50:05 PM
Meanwhile I discovered the reason for my problems: my BCM is not in English!
And the DB tool supports English BCM only.
Another good test that passed OK: English BCM can be installed on
non-English Outlook 2007 and seems to work fine.
But for ease of use for my fellows here in the office, I'd rather see a hint
how to have a centralized SQL BCM DB for non-English users. I can't imagine
this solution would be exclusive to English speaking world!
Unfortunatelly I am not really expert in SQL DB handling. So I'd really need
a step-by-step instruction.
Anybody?

"AllenM" wrote:

[Quoted Text]
> I've just installed BCM on my SBS 2003 server with no Outlook or BCM
> installed and it works just fine. I found that if you do not type the exact
> correct infromation for the server name it will return that error. When you
> finished installing and configuring the BCM DB Tool it should have brought
> up an html page with the instructions on how to connect to the server and
> database as well as the correct server and database instance name.
>
>
> "JurijK" <JurijK[ at ]discussions.microsoft.com> wrote in message
> news:B9329AC3-4F04-47B8-A73E-4897F94DD84B[ at ]microsoft.com...
> > Hi! Our company runs SBS2003 server, clients have Office 2007 SB, includes
> > also BCM.
> > I wanted to have a centralized database on our server as client computers
> > are either not always on or are not present (notebooks) to share the DB.
> > Besides, do not want to waste one Office license to run BCM "server" on
> > one
> > additional station.
> > I have found the "Business Contact Manager for Outlook 2007 Database Tool"
> > provided by MS as free download. Promises to create a centralized database
> > on
> > servers where Outlook/BCM are not installed. I have also installed "SQL
> > 2005
> > Express SP2" on my SBS2003 and made sure my .NET environment is more
> > recent
> > then requested by the "Database Tool" installation program. It is 3.5 SP1
> > now.
> > After running the "Database Tools" and creating the database I also added
> > users.
> > On client computers however attempts to connect to the database remain
> > unsuccessful. The Wizard claims there was no valid BCM database present on
> > the selected server.
> > Have tried to work around by simply detaching the database created on one
> > of
> > client's PCs and moving it to SBS2003 server and manually attaching it
> > there.
> > Suddenly the BCM DB Wizard on client computer found it but not even the
> > creator could manage the database (like change client permission list,
> > like
> > who can connect and who not). Even if result was not useful, it has proven
> > the SQL2005Xpress server to be visible and properly configured?
> > As it appears, the "Business Contact Manager for Outlook 2007 Database
> > Tool"
> > does not create a database, that would be recognized by my version of BCM
> > as
> > a valid database.
> > Is there any workaround? Update? Fix? Pls help!
>
>
>
Re: BCM Database on central SQL server?
"ThePro" <mcthepro[ at ]nospam.hotmail.com> 10/14/2008 2:28:27 PM
Hi,

I too tried to setup a french-speaking BCM on a server and the solution I
found was to install a XP VM with Outlook+BCM on Hyper-V. I guess you could
do the same with Virtual Server.

ThePro

"JurijK" <JurijK[ at ]discussions.microsoft.com> wrote:
[Quoted Text]
> Meanwhile I discovered the reason for my problems: my BCM is not in
> English!
> And the DB tool supports English BCM only.
> Another good test that passed OK: English BCM can be installed on
> non-English Outlook 2007 and seems to work fine.
> But for ease of use for my fellows here in the office, I'd rather see a
> hint
> how to have a centralized SQL BCM DB for non-English users. I can't
> imagine
> this solution would be exclusive to English speaking world!
> Unfortunatelly I am not really expert in SQL DB handling. So I'd really
> need
> a step-by-step instruction.
> Anybody?
>
> "AllenM" wrote:
>
>> I've just installed BCM on my SBS 2003 server with no Outlook or BCM
>> installed and it works just fine. I found that if you do not type the
>> exact
>> correct infromation for the server name it will return that error. When
>> you
>> finished installing and configuring the BCM DB Tool it should have
>> brought
>> up an html page with the instructions on how to connect to the server and
>> database as well as the correct server and database instance name.
>>
>>
>> "JurijK" <JurijK[ at ]discussions.microsoft.com> wrote in message
>> news:B9329AC3-4F04-47B8-A73E-4897F94DD84B[ at ]microsoft.com...
>> > Hi! Our company runs SBS2003 server, clients have Office 2007 SB,
>> > includes
>> > also BCM.
>> > I wanted to have a centralized database on our server as client
>> > computers
>> > are either not always on or are not present (notebooks) to share the
>> > DB.
>> > Besides, do not want to waste one Office license to run BCM "server" on
>> > one
>> > additional station.
>> > I have found the "Business Contact Manager for Outlook 2007 Database
>> > Tool"
>> > provided by MS as free download. Promises to create a centralized
>> > database
>> > on
>> > servers where Outlook/BCM are not installed. I have also installed "SQL
>> > 2005
>> > Express SP2" on my SBS2003 and made sure my .NET environment is more
>> > recent
>> > then requested by the "Database Tool" installation program. It is 3.5
>> > SP1
>> > now.
>> > After running the "Database Tools" and creating the database I also
>> > added
>> > users.
>> > On client computers however attempts to connect to the database remain
>> > unsuccessful. The Wizard claims there was no valid BCM database present
>> > on
>> > the selected server.
>> > Have tried to work around by simply detaching the database created on
>> > one
>> > of
>> > client's PCs and moving it to SBS2003 server and manually attaching it
>> > there.
>> > Suddenly the BCM DB Wizard on client computer found it but not even the
>> > creator could manage the database (like change client permission list,
>> > like
>> > who can connect and who not). Even if result was not useful, it has
>> > proven
>> > the SQL2005Xpress server to be visible and properly configured?
>> > As it appears, the "Business Contact Manager for Outlook 2007 Database
>> > Tool"
>> > does not create a database, that would be recognized by my version of
>> > BCM
>> > as
>> > a valid database.
>> > Is there any workaround? Update? Fix? Pls help!
>>
>>
>>

Re: BCM Database on central SQL server?
Aleksa 10/31/2008 10:41:02 PM
What port is the SQL server running on?
BCM looks for port 5356?

Hope this helps.


"ThePro" wrote:

[Quoted Text]
> Hi,
>
> I too tried to setup a french-speaking BCM on a server and the solution I
> found was to install a XP VM with Outlook+BCM on Hyper-V. I guess you could
> do the same with Virtual Server.
>
> ThePro
>
> "JurijK" <JurijK[ at ]discussions.microsoft.com> wrote:
> > Meanwhile I discovered the reason for my problems: my BCM is not in
> > English!
> > And the DB tool supports English BCM only.
> > Another good test that passed OK: English BCM can be installed on
> > non-English Outlook 2007 and seems to work fine.
> > But for ease of use for my fellows here in the office, I'd rather see a
> > hint
> > how to have a centralized SQL BCM DB for non-English users. I can't
> > imagine
> > this solution would be exclusive to English speaking world!
> > Unfortunatelly I am not really expert in SQL DB handling. So I'd really
> > need
> > a step-by-step instruction.
> > Anybody?
> >
> > "AllenM" wrote:
> >
> >> I've just installed BCM on my SBS 2003 server with no Outlook or BCM
> >> installed and it works just fine. I found that if you do not type the
> >> exact
> >> correct infromation for the server name it will return that error. When
> >> you
> >> finished installing and configuring the BCM DB Tool it should have
> >> brought
> >> up an html page with the instructions on how to connect to the server and
> >> database as well as the correct server and database instance name.
> >>
> >>
> >> "JurijK" <JurijK[ at ]discussions.microsoft.com> wrote in message
> >> news:B9329AC3-4F04-47B8-A73E-4897F94DD84B[ at ]microsoft.com...
> >> > Hi! Our company runs SBS2003 server, clients have Office 2007 SB,
> >> > includes
> >> > also BCM.
> >> > I wanted to have a centralized database on our server as client
> >> > computers
> >> > are either not always on or are not present (notebooks) to share the
> >> > DB.
> >> > Besides, do not want to waste one Office license to run BCM "server" on
> >> > one
> >> > additional station.
> >> > I have found the "Business Contact Manager for Outlook 2007 Database
> >> > Tool"
> >> > provided by MS as free download. Promises to create a centralized
> >> > database
> >> > on
> >> > servers where Outlook/BCM are not installed. I have also installed "SQL
> >> > 2005
> >> > Express SP2" on my SBS2003 and made sure my .NET environment is more
> >> > recent
> >> > then requested by the "Database Tool" installation program. It is 3.5
> >> > SP1
> >> > now.
> >> > After running the "Database Tools" and creating the database I also
> >> > added
> >> > users.
> >> > On client computers however attempts to connect to the database remain
> >> > unsuccessful. The Wizard claims there was no valid BCM database present
> >> > on
> >> > the selected server.
> >> > Have tried to work around by simply detaching the database created on
> >> > one
> >> > of
> >> > client's PCs and moving it to SBS2003 server and manually attaching it
> >> > there.
> >> > Suddenly the BCM DB Wizard on client computer found it but not even the
> >> > creator could manage the database (like change client permission list,
> >> > like
> >> > who can connect and who not). Even if result was not useful, it has
> >> > proven
> >> > the SQL2005Xpress server to be visible and properly configured?
> >> > As it appears, the "Business Contact Manager for Outlook 2007 Database
> >> > Tool"
> >> > does not create a database, that would be recognized by my version of
> >> > BCM
> >> > as
> >> > a valid database.
> >> > Is there any workaround? Update? Fix? Pls help!
> >>
> >>
> >>
>

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net