As a part time IT manager, I have been searching for better solutions to the company. There is this problem, it was not solved until today.
I installed Business Contact Manager 2007 for Outlook 2007, a local SQL instance was created as well during installation. Now every time I started the Outlook, the netservice process sqlserver.exe used a lot of memory and kept increasing. It is horrible, it slowed down my computer badly. But I had no choice but bore it.
I never thought I could solve it without extra work, today with the thought of easy sharing and easy management, I installed SQL server 2005 Enterprise Edition to our Windows Server 2003 R2 and with the help of BCM 2007 Database Admin Took, I easily created a database and shared it with my domain account. Back to my computer, export the local database records, then just selected the remote database, imported the previous records to the remote database, now everything seemed exactly the same. Check out Task manager, sqlserver.exe took up only about 25MB and did not increase at all even when I was operating BCM, like adding records, reporting, analyzing, etct. It seemed very strange, but I still have no idea of how it worked.
Now I am going to implement it to other computers. It felts so good to finally solve a problem like this.
The following is how I did it:
Step 1: Install SQL Server 2005 to the server;
Step 2: Install BCM 2007 Database Admin Tool to the server, click here to download;
Step 3: Run Database Admin Tool, select “Create a database”, click Next, select the instance name, here it should be mssqlserver, click Next, type the database name you want, here I type James as the database name, then click Finish. It returns to the first page after the task finishes. Because the database is created by the SQL Server Administrator Account, the client workstation cannot access the database as they are not the owner, so in Database Admin Tool, select “Share a database”, click Next, select instance name from dropdown list, then click Next, select database name from the drop down list, next click Add User if your domain account does not show on the list, otherwise tick the checkbox on left of the account on the list, click finish, that’s it for this step.
Step 4: In your client computer where Outlook 2007 with BCM 2007 is installed, go to menu Business Contact Manage/Database/Select or Create Database, in “Select a database”, type “server\mssqlserver,1433“, click Connect, select a database from the drop down list below, click Next, it pops up and asks for Offline setting, I prefer disable it since it is a desktop having constant connection to the server, click Finish.
Note: here server is the name of your dedicated SQL Server name, mssqlserver is the instance name, 1433 is TCP/IP port, this can be set in SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, select Protocal for mssqlserver, on the right window, right click TCP/IP, select Property, go to the IP Addresses page, in IPAll section, you will see TCP Dynamic Ports, the number beside it is 1433 which can be changed by click it.
Step 5: In Outlook menu, click Business Contact Manager/Database Tools/Import or Export, select Import a File, click next, select Business Contact Manager data (.bcm) from the list, click Next, then click Browse, locate the exported file, then click Next twice, the importing will be in progress.
That’s it, I finished this on my Mac, so the description might not accurate, but I will try to correct whenever I can.
Next up, I will write my experience about Integration of BCM 2007 and Office Accounting.