Archive for the ‘MS Business Contact Manager’ Category

Deploying Microsoft Office Outlook 2007 with Business Contact Manager in a Remote Database Configuration

September 1, 2011

Deploying Microsoft Office Outlook 2007 with Business Contact Manager in a Remote Database Configuration

Deploying Outlook 2007 with Business Contact Manager in a Remote Database Configuration

Set Up a New Database on a Remote Server

To create a new Business Contact Manager database on a remote server, do the following:

1.       Create an empty SQL database on the server.

2.       Run a set of SQL scripts on the empty database to add appropriate tables, stored procedures, and other data into the database.

By default, the set of SQL scripts is installed as part of installing Business Contact Manager for Outlook on a client computer. You can copy this script file from the client computer to the server computer, and then run it by using SQL commands.

Step 1. Create a New Database

To create a new Business Contact Manager database, run the following command.

sqlcmd –S .\%INSTANCENAME% –E –Q

“CREATE DATABASE [%DBNAME%] ON (NAME = N’%DBNAME%_dat’, FILENAME = N’%PATH%\%DBNAME%.mdf’, SIZE = 25, FILEGROWTH = 50%) LOG ON (NAME = N’%DBNAME%_log’, FILENAME = N’%PATH%\%DBNAME%.ldf’, SIZE = 10,FILEGROWTH = 50%) Collate %COLLATION%

exec sp_dboption N’%DBNAME%’, N’autoclose’, N’false’

exec sp_dboption N’%DBNAME%’, N’bulkcopy’, N’true’

exec sp_dboption N’%DBNAME%’, N’trunc. log’, N’true’

exec sp_dboption N’%DBNAME%’, N’torn page detection’, N’true’

exec sp_dboption N’%DBNAME%’, N’read only’, N’false’

exec sp_dboption N’%DBNAME%’, N’dbo use’, N’false’

exec sp_dboption N’%DBNAME%’, N’single’, N’false’

exec sp_dboption N’%DBNAME%’, N’autoshrink’, N’false’

exec sp_dboption N’%DBNAME%’, N’ANSI null default’, N’false’

exec sp_dboption N’%DBNAME%’, N’recursive triggers’, N’false’

exec sp_dboption N’%DBNAME%’, N’ANSI nulls’, N’false’

exec sp_dboption N’%DBNAME%’, N’concat null yields null’, N’false’

exec sp_dboption N’%DBNAME%’, N’cursor close on commit’, N’false’

exec sp_dboption N’%DBNAME%’, N’default to local cursor’, N’false’

exec sp_dboption N’%DBNAME%’, N’quoted identifier’, N’false’

exec sp_dboption N’%DBNAME%’, N’ANSI warnings’, N’false’

exec sp_dboption N’%DBNAME%’, N’auto create statistics’, N’true’

exec sp_dboption N’%DBNAME%’, N’auto update statistics’, N’true’ “

Where:

  • %INSTANCENAME% is the name of the instance of SQL Server.
  • %DBNAME% is the name of the Business Contact Manager database.
  • %PATH% is the path where the database files should be created.
  • %COLLATION% is the SQL Collation to be used. In the US-English version of Business Contact Manager for Outlook, this value should be SQL_Latin1_General_CP1_CI_AS. Appendix B lists the value of %COLLATION% to use for other languages.

Step 2. Obtain the SQL Script to Configure a New Database

As noted earlier, the SQL script to configure a new Business Contact Manager database is installed as part of installing Business Contact Manager for Outlook. If Business Contact Manager for Outlook is installed on a client computer, you can obtain this file—named db_create_script.sql—from the installation folder. Assuming Business Contact Manager for Outlook was installed in the default folder, this file location is: %ProgramFiles%\Microsoft Small Business\Business Contact Manager\%LOCALEID% where %LOCALEID% is the language of Business Contact Manager for Outlook being used. For US-English versions, this value is en-US. For other languages, this value should be the ID that corresponds to the language. Appendix A includes a list of these IDs.

Copy this file to the server where you want to configure the new database.

Step 3. Configure a New Database

To configure the newly created empty database on the server, first populate the database by using the SQL script obtained in the previous section. To populate the database, run the following commands.

sqlcmd –S .\%INSTANCENAME% –E –d %DBNAME% –i “%PATH%\db_create_script.sql” -b

Then, run the following three commands.

sqlcmd –S .\%INSTANCENAME% -d %DBNAME% –E –Q “Update OrgTable Set SharedServer = N’%MACHINENAME%’”

sqlcmd –S .\%INSTANCENAME% -d %DBNAME% –E –Q “Update OrgTable Set OrgName=N’%DBNAME%’”

sqlcmd –S .\%INSTANCENAME% -d %DBNAME% –E –Q “Update OrgTable Set LocaleID=N’%LOCALEID%’”

Where:

  • %INSTANCENAME% is the name of the instance of SQL Server.
  • %DBNAME% is the name of the Business Contact Manager database.
  • %PATH% is the path where the script file named db_create_script.sql to configure a Business Contact Manager database is available.
  • %COMPUTERNAME% is the network identification name of the server where the Business Contact Manager database is created.
  • %LOCALEID% is the language version of Business Contact Manager for Outlook which will be used to connect to the database. For US-English versions, this value is en-US. For other languages, this value should be the ID that corresponds to the language. Appendix A includes a list of these IDs.

Step 4. Share a New Database

When you create a new Business Contact Manager database, by default the database owner is the user who was logged on to Windows while creating the database. This user has permissions to access the database. When the user connects to the database from a different computer, the same user account is used to log on to Windows on the client computer.

If a domain user account is used to log on to the server while creating the database, the same domain user account should be used to log on to the client computer when you are using Business Contact Manager for Outlook and connecting to the Business Contact Manager database on the server. Similarly, in a workgroup scenario, if a local computer user account is used to log on to the server and create the database, a local computer user account with the same user name and password should be created on the client computer. This logon should be used to log on to the client computer when you are using Business Contact Manager for Outlook to connect to the Business Contact Manager database created on the server.

Sometimes, it is not possible to use the same Windows user account on the server when creating the database, and on the client when connecting to the database. For example, the user on the client computer who needs to connect to the Business Contact Manager database may not have permissions to log on the server.

In those cases, the Business Contact Manager database must be shared with the users who log on to the client computer to connect to the shared database. To do this, first configure the Business Contact Manager database as shared, and then grant permissions to users who need to connect to this database.

To configure the database as shared on the server where the database is created, run the following command.

sqlcmd –S .\%INSTANCENAME% -d %DBNAME% –E –Q “exec PublicTurnOnSharing 1”

Where:

  • %INSTANCENAME% is the name of the instance of SQL Server.
  • %DBNAME% is the name of the Business Contact Manager database.

To grant permissions to a domain user to log on to the SQL Server, run the following command.

sqlcmd –S .\%INSTANCENAME% –E –Q “exec sp_grantlogin [%DOMAIN%\%USER%]”

Where:

  • %INSTANCENAME% is the name of the instance of SQL Server.
  • %DOMAIN% is the domain name for the user.
  • %USER% is the user name of the user on the domain who needs to be granted permissions to access a database.

To grant permissions to a domain user who can log on to the SQL Server to access the Business Contact Manager database, run the following command.

sqlcmd –S .\%INSTANCENAME% -d %DBNAME% –E –Q “exec ir_AddSharedUser ‘%DOMAIN%\%USER%”

Where:

  • %INSTANCENAME% is the name of the instance of SQL Server.
  • %DBNAME% is the name of the Business Contact Manager database.
  • %DOMAIN% is the domain name for the user.
  • %USER% is the user name of the user who needs to be granted permissions to access the database.

Connect to the Remote Database

If you have already created a Business Contact Manager database on a remote server, you can choose to use that database from the client computer that has Business Contact Manager for Outlook installed.

Follow these steps:

1.       Install Business Contact Manager for Outlook.

2.       Start Microsoft Office Outlook 2007.

3.       In the Startup wizard, select Manual Startup to configure Business Contact Manager for Outlook.

4.       On the Create or Select your database page, select Existing Database.

5.       Type the computer name where your SQL Server is installed.

If, when you install SQL Server, the instance name was not MSSMLBIZ, include the instance name with the computer name in the format of %COMPUTERNAME%\%INSTANCENAME%, where %COMPUTERNAME% is the name of the computer where SQL Server is installed and %INSTANCENAME% is the name of the instance of SQL Server.

6.       Click Connect to connect to the remote computer.

Select the appropriate Business Contact Manager database, and then click Next to continue.

Advertisements

Troubleshoot installing Business Contact Manager for Outlook 2007 – Outlook – Microsoft Office Online

August 11, 2011

http://office.microsoft.com/en-us/outlook/HP011128601033.aspx

“Business Contact Manager for Outlook 2003 is installed on your computer. It is not compatible with Outlook 2007. You must install Business Contact Manager for Outlook 2007 to access your Business Contact Manager database. The Business Contact Manager for Outlook 2007 Setup wizard removes Business Contact Manager for Outlook 2003 for you. 

The information in your Business Contact Manager database is intact. The next time you start Outlook after installing Business Contact Manager for Outlook 2007, the Startup Wizard will move or migrate the older database to the new database.”

Risoluzione di vari problemi con Business Contact Manager per Outlook 2007

October 2, 2009

Non è possibile rimuovere Business Contact Manager per Outlook 2007 utilizzando la funzionalità di Installazione applicazioni in Windows XP o tramite “programmi funzionalità e” in Windows Vista:
http://support.microsoft.com/kb/958446

Disabilitazione di Business Contact Manager in Outlook con Business Contact Manager:
http://support.microsoft.com/kb/903094

Remove Business Contact Manager for Outlook 2007 – Help and How-to – Microsoft Office Online:
http://office.microsoft.com/en-us/help/HA102435301033.aspx

Rimuovere Business Contact Manager per Outlook 2007 – Outlook – Microsoft Office Online:
http://office.microsoft.com/it-it/outlook/HA102435301040.aspx

How to troubleshoot Business Contact Manager Setup issues:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;901163

La sua problematica specifica sembra però essere risolvibile con la seguente procedura:

Backup and remove:
HKey_Current_User\SOFTWARE\Microsoft\Business Solutions eCRM
 
If that does not help backup and remove:

HKey_Current_User\SOFTWARE\Microsoft\Office

ATTENZIONE
La procedura appena riportata potrebbe compromettere l’installazione di Microsoft Office 2007, pertanto la invito a prendere tutte le precauzioni del caso e ad eseguire il tutto in ambiente di test e non di produzione.

How to enable Logging in BCM

August 3, 2009

There are two ways to enable logging in BCM

User Interface
Registry

User Interface:
To enable logging through the User Interface go to help > About Business contact Manger
Check the box that says Enable logging for Business contact Manager

Registry
Logging through the registry can be enabled by manually adding the following keys prior to starting Outlook
HKEY_CURRENT _USER\Software\Microsoft\Business Solution eCRM
Check for a DWORD VALUE called BCMLogging , If not present you’ll need to create one and provide a value data of 255 (In decimal)
This would ensure that logging has been turned on .
Also when these options are enable , a log file called BCMLog_V3.log is written to:
C:\Documents & Settings\<User name>\Local Settings\Temp (On Windows XP )
C:\Users\ <User Name>\AppData\Local\Temp (On Vista )
You can also access the file by going to Start > RUN > %TEMP%

How to create a “New Business Contact from the Same Company”

August 2, 2009

I have seen a lot of user post this query in the news group ,below is the workaround to create a New Business contact from the same company
Open an Existing Business contact
Click on the Office Button > Select editor option
From the Editor options > select Customize
Select “Command Not in the Ribbon” under Choose command from
Scroll down the list and select “Save and New in Company”
Click on the Add button and add it to the Quick access Toolbar
Once you click on Ok, the option should be available under the quick access tool bar.
Now you should be able to open any Business contact with a company field, use the “Save and New in Company “option in the Quick Access toolbar and auto populate the Company field.

How to check for Errors in a Business Contact Manager database

August 1, 2009

Below are the steps to Check for errors in a BCM data base :
Go to Business contact Manager > Database Tools > Manage database
Under the Backup / Restore tab select the option to check for Errors
Note: This option will be grayed out if the user is connecting to a shared database
Click on the Start button to begin the process

MS Office Outlook 2007 with Business Contact Manager con MS SQL 2008

July 5, 2009

Microsoft SQL Server 2008 attualmente non è compatibile con Microsoft Office Outlook 2007 with Business Contact Manager.
Nel caso di un’installazione su Microsoft Windows Small Business Server 2008 Premium Edition è consigliato appoggiare il database su Microsoft SQL Server 2005 Express Edition 32-bit (non è compatibile la 64-bit).

Usare DB remoti per Microsoft Business Contact Manager 2007

July 4, 2009

In Microsoft Office Outlook 2007 with Business Contact Manager è possibile sfruttare database remoti appoggiati su installazioni di Microsoft SQL Server 2005, il documento Deploying Outlook 2007 with Business Contact Manager in a Remote Database Configuration descrive nel dettaglio tutte le operazioni possibili e le procedure per gestirlo ed elaborarlo.

Microsoft Business Contact Manager 2007 su Pocket PC

March 16, 2009

Per utilizzare anche sui dispositivi palmari come Smartphone e Pocket PC il software Microsoft Business Contact Manager 2007 vi suggerisco di consultare il seguente link:

Take your Business Contacts with you on your smartphone or Pocket PC – Outlook – Microsoft Office Online:
http://office.microsoft.com/en-us/outlook/HP011209791033.aspx?pid=CH101207721033
Synchronize Business Contact information with BlackBerry, Palm, and iPhone devices BlackBerry, Palm, and iPhone devices are not supported by Microsoft.
There are third-party products, such as those by CompanionLink Software, that enable you to synchronize your business data with BlackBerry, Palm, and iPhone devices.

Dettagli download: Outlook 2007 con il componente aggiuntivo Business Contact Manager: Contatti commerciali per Pocket PC:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7bc78c14-7143-41d9-84a9-bd628db7b6a0&displaylang=it

Vi invito a provare la versione trial del prodotto sottostante che dovrebbe risolvere il problema di collegamento anche con i Black Berry, ricordandovi però che tale soluzione non è supportata direttamente da Microsoft.

Synchronize CRM or PIM data with handheld devices — CompanionLink:
http://www.companionlink.com/products/companionlink.html

Supported handhelds
• BlackBerry
• Windows Mobile

Supported PIM and CRM software
• ACT! (more…)
• GoldMine (more…)
• Google
• Lotus Notes
o versions 4.6.7 and higher
o supports ANSI languages only (Japanese, Chinese and Russian not supported)
• Microsoft Outlook
o versions 97 and higher
• Microsoft Outlook 2007 with Business Contact Manager (more…)

Disabilitazione di Business Contact Manager in Outlook con Business Contact Manager

December 25, 2008

In questo articolo viene descritto come disattivare Business Contact Manager in Microsoft Office Outlook 2007 con Business Contact Manager e in Microsoft Office Outlook 2003 con Business Contact Manager.

È possibile utilizzare l’elemento Installazione applicazioni nel Pannello di controllo per rimuovere Business Contact Manager. Tuttavia, se si desidera disattivare Business Contact Manager senza rimuovere Business Contact Manager, eseguire la procedura:

Uscire da Outlook.

Fare clic sul pulsante Start , scegliere Esegui , digitare regedit e quindi fare clic su OK.

Individuare e selezionare la seguente sottochiave del Registro di sistema:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\

Outlook\Addins\Microsoft.BusinessSolutions.eCRM.OutlookAddIn.Connect.1

Fare clic con il pulsante destro del mouse su LoadBehavior e quindi fare clic su Modifica.

Nella casella dati valore digitare 1 e quindi fare clic su OK.

Chiudere l’editor del Registro di sistema.

Avviare Outlook.

Per attivare Business Contact Manager dopo che è stato disabilitato Business Contact Manager, attenersi alla seguente procedura:

Uscire da Outlook.

Fare clic sul pulsante Start , scegliere Esegui , digitare regedit e quindi fare clic su OK.

Individuare e quindi scegliere seguenti sottochiave del Registro di sistema:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\

Outlook\Addins\Microsoft.BusinessSolutions.eCRM.OutlookAddIn.Connect.1

Fare clic con il pulsante destro del mouse su LoadBehavior e quindi fare clic su Modifica.

Nella casella dati valore digitare 3 e quindi fare clic su OK.

Chiudere l’editor del Registro di sistema.

Avviare Outlook.