Frequently Asked Questions for Database

Artikel
05/19/2008

I have Business Contact Manager 2007 Integrated with MOA in a sharing scenario on Small business server with SQL 2005. One of the shared user changed windows password and now cannot access the database.

SQL Database should be set to log on as local system account

In a shared scenario, files that are linked or files part of an email are not being stored in the database?

Email and attachments cannot be currently stored in the BCM db to avoid consuming all the database space.

SQL Express using lot of memory on my system

Install free download “SQL Server Management Studio Express” for setting Max
Memory
Info on why this is helpful:
https://www.microsoft.com/technet/prodtechnol/sql/2005/mgsqlexpwssmse....

Download Source: “Managing SQL Server Express”
(SQLServer2005_SSMSEE.msi)
https://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD...

Installs to Program Files/Microsoft SQL Server 2005

User Instructions:
Open SQL Server Management Studio Express
Connect to SQL database
At Object Explorer, right click on Server Name to provide Properties Dialog
box
Select Memory
Enter desired Maximum Server Memory (Recommended not less than 100MB)

Where my database is physically located?

Databases are physically created at

C:\Documents and Settings\{username}\Local Settings\Application
Data\Microsoft\Business Contact Manager

I recently upgraded my machine from XP to vista with office 2007. How do I get my old BCM on office 2007 using my backup files?

You need to back up BCM database on XP and restore it after upgrade to VISTA. If the user accounts are different after upgrade, you need to run Outlook as “Run as Administrator”.

Can I use BCM 2003 to connect to a shared database created by BCM 2007 ?

All the BCM clients needs to be of same version

What is SQL server instance Name for BCM 2007?

It’s MSSMLBIZ

What is the difference between “.sbb” and “.msbcm” back up files and SQL “.bak” files?

“ .sbb” or “ .msbcm” files are the compressed version of “ .bak” file. “ .sbb” file also contains an xml file to keep some generic database information such as language and the version of the database.

Comments

Anonymous
June 12, 2008
Outlook , by design stays in the background to quickly reopen the program. The problem is if my system receives an update and reboots, crashes, or i close it, outlook is closed as if I use the task manager. When doing that it corrupts the sql database for bcm and the .pst file.When I exit Outlook I want it to close. When the system closes processes (as in after an unattended update) I want it to close outlook fully.
Anonymous
June 12, 2008
what can I do it my mdf file attached ok but the ldf will not.
Anonymous
June 24, 2008
I have found the problem to be BCM and inheirant to many add-on applications. This is somehting bad as everytime MS does an update or I have to close BCM it corrupts my .pst and or .mdf.ldf and or my sql linkage.THIS IS CRITICAL as I've lost much data and time spending over a year now with this issue, spendin several hundred dollars is MS support who have been able to help me learn how to reinitialize the sql database but never fixed the problem.HELP
Anonymous
June 25, 2008
Hi emilbergerSorry to hear you having problems with your BCM. What exactly is the problem now?ThanksVinit [MSFT]
Anonymous
July 16, 2008
We have deployed BCM on SBS 2003 and have been working well for a while. 5 users.Within the past few days - we are unable to access 'accounts' - we can get business contacts to open but accounts will not. We can get a list of accounts but double-clicking on one of them just does nothing.I have searched the blog for a similar issue or where to post this comment for support but this is as close as I can get.can anyone help?
Anonymous
July 16, 2008
The comment has been removed
Anonymous
July 21, 2008
I have BCM 2007 sitting on SQL Express and have merged Accounting 08 with it.All runs OK, but recently I have found that random Accounts in BCM are disappearing, I have managed to get them back by changing the IsDeletedLocally field for the Account to Flase rather than True. but I can't seem to find the Communication History for the Account, I'm sure it's not deleted, but can you give a clue as to whcih table it's hiding in!!!Thanks
Anonymous
July 21, 2008
Is the database shared out to other users? I dont see a reason why this should happen.Could you check your deleted items folder and see if you can find the history items there?ThanksVinit [MSFT]
Anonymous
August 14, 2008
Quick questions:1) Is there a size limit to the BCM database, whether it is stored locally OR hosted by the DB Admin tool2) How are shared DBs synced? Through email (like ACT?)
Anonymous
August 14, 2008
Hi Johnjm04Yes the size limit i believe is 4GB.can you be more specific about db sync? ThanksVinit[MSFT]
Anonymous
August 14, 2008
Vinit,When you have a shared local database on one user's machine and another user makes updates to that database. How does it send or communicate with the shared database for these updates?John M.
Anonymous
August 14, 2008
Hi JohnBCM takes care of it for you. But keep in mind that the last writer wins.ThanksVinit [MSFT]
Anonymous
August 15, 2008
How does BCM take care it? SQL? Peer to Peer - TCPIP?Is there a way I can contact you directly? email?
Anonymous
August 15, 2008
Hi JohnSo the communication channel is over TCP/IP. we have an administrative utility that does the communication on both the client and server side.please send me your email address if you have anyother questions regarding this.ThanksVinit[MSFT]
Anonymous
August 25, 2008
Hi,I was wondering how you set different permission levels for different users on the shared database. So far I have seen two different levels--administrator and database user. How do you differentiate bewteen permission levels when you add a new user? Can you change permissions for existing users?Thanks.
Anonymous
August 25, 2008
HiBCM is not been designed to have different permission levels for users on the database. If a user has access to the database, he/she can pretty much do anything on the database.ThanksVinit [MSFT]
Anonymous
August 26, 2008
I have exported a BCM database file from one computer and imported it to another computer. The computer I imported it to will serve as my "server" which my team members will access the database. Two questions:a. Is it possible to preserve the "created on" date? All reports I run have the "created on" date as the date in which I imported the database.b. Is it possible for me to access the shared database if I were at my house and not the office...I'm outside of the network. How do I go about accessing the database instead of "working offline"If you could...please email me with a response in addition to posting it here. carl@h2realty.comThank you so much!
Anonymous
October 01, 2008
Hi BCM Team. I have a setup of 6 PC's with Outlook 2003 with BCM. The server is also with BCM 2003. 4 PC's on the site have 2003 and they connect to the server database without any problem. However there are 2 machines with Outlook 2007 which BCM 2007, which connects ok through the command prompt. (osql -E -S SSAPC01microsoftsmlbiz,56183) returns 1>. However BCM 2007 does not connect to the DB. Could you please help ? Many Thanks . Sarathi
Anonymous
October 01, 2008
Hi Sarathi Unfortunately, BCM can only connect to same versions. i.e. 2007 client can connect only to 2007 server. This is by design. Thanks Vinit [MSFT]
Anonymous
October 09, 2008
I have setup my BCM database on my SQL server and have successfully connected myself and one other user to it. I am able to create user defined fields and permanently delete records just fine, but my co-worker is unable to do either. Both our user accounts are set to Database User on the server using the Database Administration Tool. Anyone have any idea why this is happening?
Anonymous
October 09, 2008
The comment has been removed
Anonymous
October 10, 2008
yea but what if i don't want my users to be admins on the server, which i really don't.
Anonymous
October 10, 2008
Hi This is something by desing. Only a DB owner or an Admin on the machine/database can do customization in BCM. Thanks Vinit [MSFT]
Anonymous
October 16, 2008
Right now I have my outlook 2007 with BCM and a local database. I have shared the local DB to another test user on the network. When the other test user makes updates to the BCM DB, how are they transferred to the local database? I think you mentioned TCP/IP before, but what protocol?

John M.

Anonymous
November 05, 2008
How can i write a query or export BCM opportunities, so that i can open in Excel?
Anonymous
November 07, 2008
Our customer has a distributed BCM environment, using Outlook 2007, with a central SQL 2005 server, local users (typically online-mode only) and several remote users that have offline capability. When the remote users return from the field (still remote), they usually sync and bring the performance of the local network to its knees. If BCM is only performing differential updates, why is performance so bad? How can we quantify the amount of necessary updates before a user starts the process?
Anonymous
November 16, 2008
The comment has been removed
Anonymous
November 18, 2008
Hi Peta, I'm really sorry to hear that you having problems with BCM. Can you give us information on Word shutting down on you? Could you give us the bucket number of the crash ( you can find that by going in to event log and check for MS word log under applications)? Do you have all the latest updates for both BCM and MS Word? Thanks Vinit [MSFT]
Anonymous
November 19, 2008
Hi All, I have successfully been using BCM 2007 with a shared DB on Small business server 2003 for over a year now and have 5 people sucessfully syncing offline/online on a routine basis. One of my laptops ran into problems releasying the online sync. So I dropped the remote DB and went to reattach the db (Done this before and usually fixes any funkiness). Long Story short the DB will re-attach but when I go to enable offline sync - it goes through the sync process but then errors out at the very end with "unable to complete you last request" When I look in the logs - looks like it's timming out. Any ideas on how to fix??
Anonymous
November 24, 2008
Hiya We have a bcm server setup in our centeral office which is working well. All the initial first time sync that were done locally at tthe site have completed successfully. I then attemtepted to setup a machine with bcm at a remote site over vpn and unfortuantely this started to do teh sync and then failed during the sync. I encounter this problem for all machines doing the first time sync to bcm from a WAN location. The same machine did a successfull sync when done from the local office and all other syncs for this machine have been compoleting successfully from then on (from any location). so it seems the problem is with doing a first time sync from a WAN location. Anyone have any ideas what the problem could be?
Anonymous
November 24, 2008
Hi Hiya, I have a few questions for you,

How long does it take for the sync to fail?
Did you check event viewer for any logs?
Can you please provide BCM logs after turning on BCM logs? Thanks Vinit [MSFT]

Anonymous
November 24, 2008
Hiya Vinit will get a hold of a remote machine later this afternoon and will send you the requested details asap thanks for the reponse much appreciated
Anonymous
November 27, 2008
The comment has been removed
Anonymous
December 08, 2008
Hi I upgraded Office with BCM from 2003 to 2007 (XP). Not one error shown, but the BCM data was not there, when I started Outlook 2007. I have spend several days trying to fix that. What I am trying now is to reestablish the 2003 environment on an other computer (also XP). After installation and update I restore the .mdf and .ldf file to the .....business contact manager directory and uses the command sp_attach_db to attach the files to the database. First time I do that I get 'transactions rolled back in database...' second time no errorcode - but the database can't be seen from within outlook, when I try to select an existing BCM database to outlook. Any good ideas? /Jens
Anonymous
December 08, 2008
Hi Jens, Sorry to hear you having problems with BCM. So, when you upgrade from BCM 2003 to 2007 we create a backup file in your "My documentsMy Business" folder. You can use that file to restore your data in BCM 2003. I hope this helps Thanks -Vinit [MSFT]
Anonymous
January 07, 2009
Hey all, I am installing BCM 2007 on my laptop and connecting to a BCM DB on a domain server. I use this laptop for development and already have SQL Server 2005 running on it and wanted to have BCM use this existing SQL Server instead of having a separate SQL Server 2005 Express instance running all of the time. I have looked in the configuration for BCM and don't see any place where I can change the server location for backup. Can anyone help with this or point me to information? Thanks! Robin
Anonymous
January 07, 2009
Hi Robin, So BCM creates a MSSMLBIZ SQL server instance for itself. This shouldnt conflict with your previous SQL Server installation.You can uninstall the instance and still connect to your remote database but then you wont be able to create a local offline db. let me know if i you have any other question regarding this. Thanks Vinit [MSFT]
Anonymous
January 07, 2009
I knew that BCM wouldn't conflict with the previous install. I just didn't want to have 2 instances of SQL server running on my laptop. I'm setting up a new laptop and my old laptop had 3 instances of SQL server running. A full version for an app I use, one for Visual Studio and one for BCM. I already skipped the VS2008 SQL server express install and will use the full SQL install from the other app if I need it for development purposes. I also want to make BCM use the existing full install of SQL server for it's offline database if at all possible. That way I would only have to have 1 instance of SQL server running on my laptop. Please feel free to email me at robinh@aurora-ia.com for further info. Thanks for replying so quickly to my original post! :) Robin
Anonymous
January 14, 2009
I have had nothing but problems with MS Pro 2007 since my first install, but the first problem I have to tackle is resuming BCM's function. (I'm running on Vista Home Premium.)Below is a list of the errors I've received: Business Contact manager database cannot be loaded. This action cannot be completed because Business Contact Manager cannot access the database. An error has occurred while establishing a connection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections (provider: TCP Provider, error: 0-No such host is known. Do you want to configure now- Yes Error Cannot find the selected database. Verify that the network and the computer on which the databases are located are availabe and that you have permission to access the database and retry. Recreated a database Error: Microsoft Outlook has stopped working Looking for a solution Outlook is restarting BCM add-on disabled When I click on BCM I get an error: BCM for outlook could not complete your last transaction. Please try again. I can't find where to enable BCM Any suggestions? :( Thanks in advance. Dawn
Anonymous
January 14, 2009
The comment has been removed
Anonymous
January 19, 2009
My database is getting rather large, particularly the communication history. I am unable to find any instructions on how to archive. I assume this is periodically necessary to keep the database from collapsing under its own size. How do I archive so all users will still be able to access old data? Thank you for your help.
Anonymous
January 19, 2009
I am using 2007 BCM and am trying to create opportunity reports. It seems that opportunity notes from the details window are not available in the reporting options. So I want create custom reports using Access through an ODBC connection to the BCM database. Then I decided to include the user defined fields I have created but can not find what table that data in these fields is located. All I can find is the table with the field definitions but not the data fields. Can any one help?
Anonymous
February 09, 2009
Is there any work being done to facilitate BCM synch using RPC over HTTP the same way Outlook does?
Anonymous
February 10, 2009
BCMTEAM; I am having issues with a user synchronizing to a shared BCM database. Synch gets approximately 2/3 through and disconnects. I have checked the logs from BCM and they are posted below. It appears to be the same error every time. We have 3 users and this user is the only one having an issue. He is the only user using a laptop (other desktops are constantly connected to the network). Server is SBS 2003 using SQL Express. This user is the heaviest user of the database and makes changes constantly. [Error]Error in synchronizing. Exception details follow System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.BusinessSolutions.eCRM.DataSync.ChangeListWinsResolver.ResolveActivity(ArrayList entityFieldCollection, Boolean& softDelete, BCMActivity activity, Boolean storeItemSoftDelete) at Microsoft.BusinessSolutions.eCRM.ImportExportDataAccess.NewEntityImport.CreateNewIrisActivity(IrisSubActivityType activitySubType, RecurringDate recurDate, String linkToOutlookItem, ArrayList entityFieldCollection, String parentIdString, String entryIdString, DuplicateInfo dupInfo, Int64 importSinceVersion, Int64 activityChangedVersion, Int64 activityLinkChangedVersion, Boolean softDelete, Boolean honorSoftDelete, Boolean dropStoreDeletedItems, Boolean treatAbsentAttributesAsBlank, Boolean checkDuplicatesByGuidOnly) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.XmlEntityImport.ProcessActivity(XmlNode activity, Int64 importSinceVersion, String parentEntryId, XmlImportOptions xmlImportOptions) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.XmlEntityImport.ProcessEntity(XmlNodeList children, String entityType, ExcludeNodes en, Int64 importSinceVersion, EventsManager eventsMgr, XmlImportOptions xmlImportOptions, String parentEntryId) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.XmlEntityImport.ImportEntity(XmlReader entity, ExcludeNodes en, EventsManager eventsMgr, Int64 importSinceVersion, XmlImportOptions xmlImportOptions) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.XmlManager.ImportFromValidatedXml(XmlTextReader xr, ImportManager impMgr, ExcludeNodes en, XmlImportOptions xmlImportOptions) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.XmlManager.DoIrisXmlImport(ImportManager impMgr, ExcludeNodes en, XmlImportOptions xmlImportOptions) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.ImportManager.DoIrisXmlImport(ExcludeNodes en, XmlImportOptions xmlImportOptions) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.ImportManager.DoImport(ExcludeNodes en, XmlImportOptions xmlImportOptions, List`1 lstUserFieldCollection) at Microsoft.BusinessSolutions.eCRM.ImportExportBase.OutlookChangeListConsumer.Microsoft.BusinessSolutions.eCRM.DataSync.IChangeListConsumer.ApplyChanges(ChangeList changes, EventsManager eventsMgr) at Microsoft.BusinessSolutions.eCRM.DataSync.SyncManager.Synchronize(SyncPoint sp, IContext producerContext, IContext consumerContext, SyncLog syncLog).
Anonymous
February 10, 2009
Hi md-consulting, We are currently looking in to this issue. But for now can you change your offline conflict resolution settings to "Latest Win" and see if this helps? Thanks Vinit [MSFT]
Anonymous
February 11, 2009
Thank you BCM team. I will be going into this location on Friday and will try that then update the site.
Anonymous
February 11, 2009
I want to save the database files and cache files automated. I know that I can check the database name form the Outlook Windows "Business Contact Manager | Database Tools | Manage Database". But how can I get the name of the used database? In windows registry under the tree "..Profiles[Profilname]" I can get the name of the standard database. But if I change the database in BCM2007 no changes will be done in the registry. Is there another solution to get the name of the active database? Thanks for any help.
Anonymous
February 11, 2009
Sorry, please forget my last question. It would be changed in the registry if you change the database. I was searching under a wrong profilename ;-)
Anonymous
February 12, 2009
Need help on a shared BCM 2007 database setup. I have tried numerous versions of SQl (2005 to 2008) on Servers that range from 2003 to 2008. Currently running SQL 2008 on Server 2008 x32. I am able to create and connect to all the databases (I have even tried installing outlook with BCM on one of the servers to create the database). but they all run painfully slow from the client. It can easily take 40 to 60 seconds to open a contact. If I restart the SQL server things run like I would expect for a few minutes before slowing back down. The servers and clients do have Symantec Endpoint Protection on them and it seems to help if I shutdown the scan on the client machine. But it it random. The current client I am playing with is Outlook 2007 on Vista Ultimate. Any help or direction would be apreciated.
Anonymous
February 15, 2009
Hi there - can you help with how to restore an old mdf and ltf file in BCM? I have looked through many forums and tried different things but nothing has worked. Basically I am running XP with SP3. I had a BCM database running fine and had all my contacts etc in there. My OS crashed last week and I had to do a Factory restore. Unfortunatley I didn't have a proper back up done, but I do have copies of the mdf and ltf files. I am trying to get my reinstalled BCM to recognise this old datebase but nothing I do seems to work Can anyone help? Please??? Many thanks Thanks
Anonymous
February 16, 2009
Hi Chammy, So, you can copy your .mdf and .ldf files to C:Documents and Settings"User Name"Application DataMicrosoftBusiness Contact Manager Folder. When you run outlook, BCM First use should recognize your database. Also make sure the credentials are the same on your machine as before. let me know if you have any other issues with this. Thanks

Vinit [MSFT]

Anonymous
February 16, 2009
Hi Vinit Thank you for your response. I tried reinstalling BCM with the files in the correct place. It couldn't see the database when I first ran it but came up with a permissions error. Could that be because the computer name was different when I initially set up the database? Thing is I can't remember what the name was - I just accepted the default that it gave me. How do I change the permissions so I can attach the database? Many thanks
Anonymous
February 17, 2009
Hi Chammy, Try the following 1)Open a command Prompt by running explicitly as administrator 2)Type sqlcmd -s [your machine name]MSSMLBIZ. Hit enter 3)Type use [your bcm database name]. Then type go and hit enter

Type sp_changedbowner '[your machinename][your login name]'. Then type go and hit enter if you dont get any error after step 4 you should be good to go. let me know if this helped. Thanks Vinit [MSFT]

Anonymous
February 17, 2009
Hi Vinit Sorry if I am being stupid here, not sure how to explicitly become an administrator? My user profile states I am also an administrator so I tried going straight to point 2). I entered the command as you state, I was given a blank command screen entitled SQLCMD , the cursor was flashing but I couldn't type anything. Then the screen just vanished. What am I doing wrong? Many thanks for your continual help here
Anonymous
February 17, 2009
Hi Vinit I worked out how to run the command prompt as administrator - when I run your point 1, the message I am getting is: HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2}. Sqlcmd: Erro: Microsft SQL Native Client: An error has occured while establising a connection to the server. When connecting to SQL Server 2005, this failure may be cause by the fact that under the default settings SQL Server does not allow remote connections .. Sqlcmd: Erro: Microsft SQL Natice Vlient : Login timeout expired I checked the settings to make sure that remote connetions ARE allowed. And I checked I was using the right machine name, and it still doesn't work Any ideas? Many thanks
Anonymous
February 18, 2009
Hi Chammy, Please try to use sqlcmd -S .MSSMLBIZ instead and see if it works. Thanks Vinit [MSFT]
Anonymous
February 18, 2009
Hi Vinit Sorry - same result as before :-( any other ideas? Many thanks
Anonymous
February 25, 2009
Are there (rather) strict limits on .pst file sizes that can be used in Outlook with BCM? I am trying to use Outlook 2007 Professional with Business Contact Manager. I have two small .pst files that I use in Outlook. One is 240 MB and the other is 1,400 MB. Before I add a Business Contact Manager database the two .pst files work fine together. And if I remove either of the .pst files and then add an empty BCM database everything seems to work OK. However, if I have both .pst files active and then try to add a new (empty) BCM database, I get the following message when Outlook attempts to start: "Cannot start processing services. There is not enough free memory to run this program. Quit one or more programs and then try again." And there are no programs other than Outlook running. This machine is running XP with SP3 and has 4 GB of Ram which should be waaaaaaay more than enough to handle this load. What is wrong? I am totally stumped at this point and am not sure what to even try next. Operating System is on Raid 0 (2x) WD 75GB raptors Page file is on L: and (hard) set (both min & max) to recommended 4989. c: (NTFS on drive 1) 148.70 GB 121.39 GB free l: (NTFS on drive 4) 500.10 GB 437.98 GB free I have been to MS Update and installed all the patches for everything.
Anonymous
April 09, 2009
Hi Guys, Can a Business Contact Manager Shared database be running off of one server, while the other server is hosting the exchange server? I am getting some Outlook hangups where the window can minimize and maximize, but is frozen. We're running two server 2003 boxes and trying to connect 2 clients now, but eventually 15. I tested on my client workstation as a standalone for over two months with no issue, but as soon as I went to a shared DB, trouble started.
Anonymous
May 04, 2009
Hi, I have been unable to work offline! We're using BCM 2007 on a shared database remotely. I have everything configured properly. There is not much to configure with BCM. If I try to go offline manually it says that it's configuring the offline database. The processes fails at 90% and I get an error message saying that "BCM could not complete the last action or actions, please try again". It stays online at that point. If I sever the connection then it goes offline but the database is empty (BCMoutlook_offline). When I try to reconnect by going online it gives me a message that its unable to reconnect to the database. In addition, when online I occasionally get a Sync Interrupted error. The rest of the office users are fine. I'm on Vista Ultimate. Any help is greatly appreciated! Paul
Anonymous
May 04, 2009
Hi Paul, Is your shared database size really large i.e. a few gbs?.If so add the code below to the beginning of the db_create_script.sql file located in C:Program FilesMicrosoft Small BusinessBusiness Contact Manageren-US to change the growth of the transaction log. DECLARE @CurrentDatabaseName CHAR(200) SET @CurrentDatabaseName = db_name() DECLARE @SQLStatement1 CHAR(2000) DECLARE @SQLStatement2 CHAR(2000) SET @SQLStatement1 = 'ALTER DATABASE ' + rtrim(ltrim(@CurrentDatabaseName)) + ' MODIFY FILE (NAME= ''' + rtrim(ltrim(@CurrentDatabaseName)) + '_dat'', FILEGROWTH=100);' SET @SQLStatement2 = 'ALTER DATABASE ' + rtrim(ltrim(@CurrentDatabaseName)) + ' MODIFY FILE (NAME= ''' + rtrim(ltrim(@CurrentDatabaseName)) + '_log'', FILEGROWTH=100);' EXEC(@SQLStatement1) EXEC(@SQLStatement2) GO See if this works. Thanks -Vinit [MSFT]
Anonymous
May 04, 2009
Vinit, Its not that large yet. Its just my contacts out there. Although no one else is having the offline issue that I'm having, we have held off going live with everyone until my issues are resolved. It was my idea for us to go with BCM so I need to give it a thumbs up. Do you still want me to do it?
Anonymous
May 04, 2009
The comment has been removed
Anonymous
May 04, 2009
Hi Vinit, Just for the heck of it I made the changes to the script like you suggested. This time when I attempted to take it offline, it did not go to the final step of "Finalizing the database configuration". The BCM tool bar just went away. When I went to view BCM contacts it said "store not configured" where the contacts would be. I shut down outlook and restarted and then I got the error message that BCM could not complete the previous action or actions. I'm not sure if you want the whole log, but I pasted below after I restarted outlook. [V] [19:07:07.0508082]Iris.Mapi.MessageStore: IMSCapabilities::GetCapabilities:Enter: 0x03dedf8c [V] [19:07:07.0508082]Iris.Mapi.MessageStore: IMSCapabilities::GetCapabilities:Return: 0x03dedf8c, 0x00000000 [I] [19:07:15.1818082]BusinessLayer: BCP - Error while BCPing (DoCopyTable) a single table...ActivityNotesTable, Error number: -2, Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. [E] [19:07:15.1818082]BCMRes: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. [E] [19:07:15.1828082]BCMRes: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.WriteSni() at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode) at System.Data.SqlClient.TdsParser.WriteByteArray(Byte[] b, Int32 len, Int32 offsetBuffer, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.WriteString(String s, Int32 length, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.WriteBulkCopyValue(Object value, SqlMetaDataPriv metadata, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at Microsoft.BusinessSolutions.eCRM.BusinessLayer.BulkCopy.DoCopyTable(SqlConnection SharedCn, String CommandText, SqlConnection OfflineConnection, SqlTransaction OfflineTran, String TableName) [E] [19:07:15.1828082]BCMRes: Text: [E] [19:07:15.1828082]BCMRes: Message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. [V] [19:07:31.7628082]Iris.Mapi.MessageStore: IMAPITable::Abort:Enter: 0x03e6df88 [V] [19:07:31.7628082]Iris.Mapi.MessageStore: MAPITable::Abort:Return: 0x03e6df88, 0x00000000 [V] [19:07:31.7638082]Iris.Mapi.MessageStore: IMAPITable::Abort:Enter: 0x03e6df88 [V] [19:07:31.7638082]Iris.Mapi.MessageStore: MAPITable::Abort:Return: 0x03e6df88, 0x00000000 [V] [19:07:31.7648082]Iris.Mapi.MessageStore: IMAPITable::Unadvise:Enter: 0x03e6df88 [V] [19:07:31.7648082]Iris.Mapi.MessageStore: MAPITable::Unadvise:Return: 0x03e6df88, 0x00000000 [V] [19:07:31.7678082]Iris.Mapi.MessageStore: IMsgStore::Unadvise:Enter: 0x03dba7a8 [V] [19:07:31.7678082]Iris.Mapi.MessageStore: MsgStore::Unadvise:Return: 0x03dba7a8, 0x00000000 [V] [19:07:31.7688082]Iris.Mapi.MessageStore: IMSLogon::Logoff:Enter: 0x03e0cd80 [V] [19:07:31.7758082]Iris.Mapi.MessageStore: MSLogon::Logoff:Return: 0x03e0cd80, 0x00000000 [V] [19:07:33.8188082]Microsoft.BusinessSolutions.eCRM.OutlookAddIn: ExplorerWrapper:moExplorer_Close: Enter [V] [19:07:33.9068082]Microsoft.BusinessSolutions.eCRM.OutlookAddIn: ExplorerWrapper:moExplorer_Close: Exit [V] [19:07:33.9538082]Iris.Mapi.MessageStore: IMSLogon::Logoff:Enter: 0x03e0cf88 [V] [19:07:33.9748082]Iris.Mapi.MessageStore: MSLogon::Logoff:Return: 0x03e0cf88, 0x00000000 [V] [19:07:33.9808082]Iris.Mapi.MessageStore: IMSProvider::Shutdown:Enter: 0x03dc34b8 [V] [19:07:33.9858082]Iris.Mapi.MessageStore: MSProvider::Shutdown:Return: 0x03dc34b8, 0x00000000 [V] [19:07:33.9978082]Iris.Mapi.MessageStore: IMAPITable::Unadvise:Enter: 0x03d9e5e8 [V] [19:07:33.9978082]Iris.Mapi.MessageStore: MAPITable::Unadvise:Return: 0x03d9e5e8, 0x00000000 [V] [19:07:34.0048082]Iris.Mapi.MessageStore: IMAPITable::Unadvise:Enter: 0x10382bf8 [V] [19:07:34.0048082]Iris.Mapi.MessageStore: MAPITable::Unadvise:Return: 0x10382bf8, 0x00000000 [V] [19:07:34.0258082]Iris.Mapi.MessageStore: IMsgStore::Unadvise:Enter: 0x03dc8f28 [V] [19:07:34.0258082]Iris.Mapi.MessageStore: MsgStore::Unadvise:Return: 0x03dc8f28, 0x00000000 [V] [19:07:34.0258082]Iris.Mapi.MessageStore: IMsgStore::Unadvise:Enter: 0x03dc8f28 [V] [19:07:34.0258082]Iris.Mapi.MessageStore: MsgStore::Unadvise:Return: 0x03dc8f28, 0x00000000 [V] [19:07:34.0268082]Iris.Mapi.MessageStore: IMSLogon::Logoff:Enter: 0x03e0ce98 [V] [19:07:34.0328082]Iris.Mapi.MessageStore: MSLogon::Logoff:Return: 0x03e0ce98, 0x00000000 Please advise as to what I should do. Thanks for your help, Vinit. Paul
Anonymous
May 05, 2009
Hi Vinit, I ran the operation again and pulled this info from the log. It is referenced a lot. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. -and- BCP - Could not BCP (DoBulkCopy) due to loss of connection to shared db. Error Message: This action cannot be completed because Business Contact Manager cannot access the database. I am not on the corporate domain and working from a laptop with a VPN connection. I hope this helps. Thanks! Paul
Anonymous
May 05, 2009
Hi Paul, Are you able to connect to the shared db without any problems? If yes,Are you also able to do all the basic BCM operations when connected to the shared DB? Are you successfully able to create a local database? Thanks -Vinit [MSFT]
Anonymous
May 05, 2009
Hi Vinit, I am able to connect to the shared db without any problems. I can work on the shared db while connected. And I am able to create a local db with no issues. I just can't go "work offline". The configuration process of going offline never completes. The BCM tool bar disappears and contact list is empty and say's the store is not configured. The log says that it times out or can't connect to the db. Yet I'm able to work on it online. Yes, there is a lag but for the most part its only a few second delay. I'm current with updates and SPs. I have uninstalled and reinstalled so many times that I an do it in my sleep. Everything is leaning towards SQL Server but I can't find anything. I'm almost certain that this is a local issue to my laptop. I have come across similar issues on the web but with no resolution for those as well. I was hoping this would be obvious for your team. Paul
Anonymous
July 01, 2009
I checked our ActivityNotesTable. ActivityNotesTable is a large table at 66MB in BCM. The total size is 299MB. We are using SQLEXPRESS 2005. Would using the Standard Version of SQL Server improve the synchronization process? As our database has grown performance for our VPN users and our users in Hungary have gone down. To test we have installed BCM in Hungary and now see the delays & failures they are experiencing here in the US. I also get this error in my log BusinessLayer: BCP - Error while BCPing (DoCopyTable) a single table...ActivityNotesTable, Error number: -2, Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Anonymous
July 09, 2009
Is the whole mail with attachments saved in the BCM database when I link it to a contact? I have read that only 4 kbyte and no attachments are stored in the BCM database? Is that correct?
Anonymous
December 08, 2009
Hi We are currently using BCM 2007 with Exchange 2003 and MS SQL 2005 Express Edition. BCM database is getting close to 4 GB Limit. Questions

Can we move to MS SQL 2008 Standard Edition?
The next release of BCM 2010 what database does it use? Thanks in advance Sanjay

Anonymous
December 10, 2009
The comment has been removed
Anonymous
January 06, 2010
I have BCM 2007 clients on 5 computers (desktop and laptops) with shared database on SQL 2005 express. One of client had a working offline copy of database when it was moved to different location. I am now at other coast office that has VPN connection to main one, the latency is about 150ms. I can from here switch BCM to online mode and use main office database directly (quite slow but works), but when I go back offline synchronization failed (offline database is not updated at all). I also cannot create new offline database. The log show error during copy operation: Error Message: Timeout expired. The timeout period elapsed prior to completion... I turn on logging and find out that synchronization failed in DoBulkCopy operation. This problem looks similar to Paul's post in May. Was he able to solve it? Is it possible to change timeout setting for BCM to SQL server connection? Thank you in advance for your help.
Anonymous
January 07, 2010
The comment has been removed
Anonymous
January 07, 2010
It works now! Here is the order I had to do things in--and I tried many. Keep in mind I am only a single-user of Office Pro 2007--I'm NOT dealing with remote connections:

Install BCM for Outlook 2007, but do NOT run Outlook yet. (I had to uninstall and reinstall because I had.)
Run Windows update and install the latest service packs for SQL Server 2005 and BCM.
Start Outlook and run through the inital BCM dialogs.
Run SQL Server Surface Area Configuration, and add yourself as an Administrator for MSSMLBIZ. Exit this utility. After completing these steps, I was able to restore my backed up BCM database under a clean Win7 installation. Hope this helps someone else!

Anonymous
January 14, 2010
We are running bcm 2010 on a full sql server 2005 (remote). We want to know if we can increase the size of each bcm database greater than 4gb? In addition, do you have a recommendation as to how large they should be (maximum)?
Anonymous
January 14, 2010
We are running bcm 2010 on a full sql server 2005 (remote). We want to know if we can increase the size of each bcm database greater than 4gb? In addition, do you have a recommendation as to how large they should be (maximum)?
Anonymous
May 13, 2010
The comment has been removed
Anonymous
September 19, 2010
"I have Business Contact Manager 2007 Integrated with MOA in a sharing scenario on Small business server with SQL 2005. One of the shared user changed windows password and now cannot access the database. SQL Database should be set to log on as local system account" I am unsure what this refers to? Could you provide more information please?
Anonymous
September 27, 2010
I have scanned several documents into a folder on my desktop which I then linked to BCM in the History section of several Accounts. When I open BCM again to view these files, I double click on the file in the history section and it opens an error message that says "File cannot be found." Any suggestions??
Anonymous
September 28, 2010
Hi, could you help us what can I do if I upgraded from office 2007 to office 2010 (both with BCM) but it cannot find the BCM database that 2007 created (I also downloaded the BCM 2010 Database Tool). Thanks in advance, Daniel
Anonymous
November 20, 2010
Problem is how to Compact Remote SQL 2005 Express Database ? Hi We are running BCM2010 on clients with a shared db on SBS Server 2003 with an instance of 2005 SQL Server Express.. I've downloaded the Server management tools from here www.microsoft.com/.../details.aspx What I have found is that I don't have the SQL Maintainance Wizard Plan options inside this application. This has been prompted by adding a 3 meg compressed file to the DB that increased the size of db by 200+megabytes. I've frequently backed up the DB and backed up files comes now to about 80 megs but when running on the client it looks like its 650 megs in total. I am sure the DB performance can be improve by compacting its size. I am sure I am not the first person to run into this but I can't see any solutions on the net either via Bing or Google!! Your help is much apprecaited. JM nt_mcp(at)hotmail.com
Anonymous
November 20, 2010
Hi Further to my posting above, its has struck me that we have 3/4 issues here. Firstly that the remote shared instance of SQL Express 2005 has a db that is showing 650megs. Then the three client computers are also reflecting this same size db. So will there be a mechanism (yet to be developed) for client workstations that can squeeze down the db that would then get sync'd to the master copy on our server? I hope that the above is making sense, you help is much appreciated, as there are 1000's of hours work gone into these databases people create.. JM nt_mcp (at) hotmail.com
Anonymous
December 07, 2010
The comment has been removed
Anonymous
July 31, 2011
I have a shared BCM database (2007). The manage database options are all greyed out. I am unable to empty the deleted items folder with an error that I do not have access. This appears to be true for everyone. I can backup the database from the server using the database admin tool. But since outlook is not installed on the server, I can get to BCM tools from there. This appears to be a database setup problem. Can someone tell me what to do with security using SQL Server Express on the server to set the security correctly so the database can be maintained?
Anonymous
August 04, 2011
After further study, it appears that the database has reach the 4GB limit. I am unable to perform any compress or cleanup. When try to create a local, offline copy, it fails with a time out error and logs a message about groupfile size limit. Any sugestion as to how to remove the 1408 deleted records in the database so that I can do maintenance on it would be appreciated.
Anonymous
August 04, 2011
The SQL Server Express 2008 web page says that it supports 10GB databases. If I use it to manage a 2007 database, is the 4GB restricted lifted?
Anonymous
August 22, 2011
I use BCM 2007. I use the quick account list daily to make my calls. Each day i have to go into and modify the "list" for just the info i need. it there a way to have this set up so i can just click on the accoutn list and it come up in the format i need? Account name Primary contact Business Phone Modified on Business Fax Email Address that to view is all I need. is thart a way to have the done automatically? thanks!
Anonymous
March 09, 2015
Outlook & BCM 2007 I have multiple users using pop3 accounts and connecting to a shared BCM database. One of the users has an issue with BCM. It installed and loaded with the toolbar and was able to view all information. A couple of days later she tries to open BCM and it errors stating "The set of folders cannot be opened. Store not configured." The database is online and others can connect to it. The issue is local to this computer running windows 7 home premium with Office 2007. Not sure where to go from here. Google provided me with limited information.

Freigeben über

Frequently Asked Questions for Database

Comments

Zusätzliche Ressourcen