I am Dale Hayter, a Microsoft and VMware certified Technical Consultant.

My blog has been built up over the years from my experience of working on an IT helpdesk and also from being out on-site.

Business Contact Manager, Share Database Error

When trying to add a new user to a Business Contact Manager Database you might receive the following message once you have selected the database.

System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or 
property cannot be called on Null values. at System.Data.SqlClient.SqlBuffer.get_String() at System.Data.SqlClient.SqlDataReader.GetString(Int3 2 i) at Microsoft.BusinessSolutions.eCRM.BusinessLayer.Bcm DataStore.GetDBOUser

To fix it carry out the following :-

– Login to SQL Management Studio
– Run a Query on the Database (Right Click, New Query)
– Type in :-

EXEC sp_changedbowner ‘DOMAIN\Administrator’