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’