Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. A Microsoft Dynamics SL System database that has only ever used SQL Authentication will cause ‘dbinfo’ errors during the initial Management Reporter CU10 integration

A Microsoft Dynamics SL System database that has only ever used SQL Authentication will cause ‘dbinfo’ errors during the initial Management Reporter CU10 integration

View products that this article applies to.

Symptoms

Consider the following scenario when you perform the initial integration for Management Reporter CU10:

You have a Microsoft Dynamics SL system database that has only used SQL Authentication.

During your initial integration of Management Reporter CU10, the Ledger to Scenario, Dimension Value, and Account to Account tasks fail with:

Value cannot be null.
Parameter name: dbInfo

↑ Back to the top

Resolution

There are two workarounds to stop receiving these errors:

  • Configure Windows Authentication with Microsoft Dynamics SL one time and then switch back to SQL Authentication.
  • Run the following SQL statement after you change the <system db> and <sql server> names: 



    INSERT INTO Domain 

    ([CurrentPassword] 

    ,[DatabaseName] 

    ,[Description] 

    ,[LocalDB] 

    ,[RecordType] 

    ,[RemoteAccess] 

    ,[ServerName] 

    ,[User1] 

    ,[User2] 

    ,[User3] 

    ,[User4]) 

    VALUES 

    ('' ,'<system db>' ,'Report User Password',0 ,0,0,'<sql server>','','',0,0) 

    GO

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3061492
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 382