News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) MR 2012 Error Running ...

Microsoft Dynamics SL (Archived)

MR 2012 Error Running Reports - Migration to new server

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

We are migrating our SL 2011 install to a new SQL server as well as MR 2012. SL works fine. However, MR 2012 gets an error on reports:

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'AcctActive'.

Invalid column name 'SubActive'.

Invalid column name 'AcctSubActive'.

The process has gone something like this:

Install SQL

Backup and Restore Company, App, and MR databases

Adjust SQL security accordingly

Install Dynamics SL 2011

Install MR 2012 RU5 (database upgraded in the process)

We have also tried variations of this process. The latest was to update SL2011 to SP1. Still no change.

Any help, or direction would be much appreciated.

Regards.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: MR 2012 Error Running Reports - Migration to new server

We figured it out. For anyone that may have the same issue. Here are two things that we ran into.

1. The company name in the original MR 2.0 didn't match in the SL database. Fixed that before we migrated.

2. Companies needed to be re-imported.

All is well now.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans