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

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: