web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Can not Import organiz...
Microsoft Dynamics CRM (Archived)

Can not Import organization

(0) ShareShare
ReportReport
Posted on by ben.tong 165

Hi

i have client using crm 2011, when i import organization will show error messages, " Import organisation wizard cannot connect to the SQL Server or cannot find an organisation database on SQl_server."

How to fix it..Thank You.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ben.Tong,

    Can you please confirm if you have successfully restored the organization database into your SQL server?

    You would also see these errors when there are connectivity issues with the SQL server. Do you have any issue accessing CRM?

    If so, it would be good idea to check if the port 1433 is not blocked on the SQL server machine and also the CRM server.

    If you are still facing the issue, please add the DMSnapIn logs so, that I can look into the stack traces.

    Regards,

    Vivek

  • ben.tong Profile Picture
    ben.tong 165 on at

    Hi Vivek,

    thank you of you reply.

    I am not sure restored successfully but i in sql management studio can see crm.

    How can i find the DM Snap In log?

    Thank You

  • Community Member Profile Picture
    Community Member on at

    Hi Ben.Tong,

    The DMsnapin logs case generally be found at  "C:\Users\Administrator\AppData\Roaming\Microsoft\MSCRM\Logs".

    Regards,

    Vivek

  • ben.tong Profile Picture
    ben.tong 165 on at

    Hi Vivek,

    17:01:32|   Info| Check ReportingUrlValidator: Success
    17:01:32|Warning| <html>
    <head>
    <title>
    SQL Server Reporting Services
    </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 10.50.4000.0" />
    <meta name="HTTP Status" content="500" />
    <meta name="ProductLocaleID" content="127" />
    <meta name="CountryLocaleID" content="1033" />
    <style>
    BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
    H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
    LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
    .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
    A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
    A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
    A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
    A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
    </style>
    </head><body bgcolor="white">
    <h1>
    Reporting Services Error<hr width="100%" size="1" color="silver" />
    </h1><ul>
    <li>The report server installation is not initialized. (rsReportServerNotActivated) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsReportServerNotActivated&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.4000.0" target="_blank">Get Online Help</a></li>
    </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
    </body>
    </html>
    17:01:32|  Error| Check ExistingRSValidator : Failure: Setup failed to validate specified Reporting Services Report Server http://VMSQL/ReportServer. Error: Error occurred while finding an item on the report server.
    The report server installation is not initialized. ---> Microsoft.ReportingServices.Library.ReportServerNotActivatedException: The report server installation is not initialized.
    17:01:32|Verbose| Validation ran.
    17:01:32|Verbose| Validation completed.
    17:01:32|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    17:01:32|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    17:01:32|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    17:01:32|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    17:02:38|   Info| Are you sure you want to cancel this operation?, Question, YesNo, Option2
    17:02:39|   Info| InputResult: Yes
    17:02:45|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 3731.
    Best Regards,
    Ben
  • Suggested answer
    Surmeet Singh Profile Picture
    Surmeet Singh 3,075 on at

    Hi, The logs are clearly showing that Reporting Services are stopped and CRM cannot connect to it. When creating default Organization reporting services are not mandatory but when creating a new organization Reporting services are mandatory.

  • AFTAB HUSSAIN Profile Picture
    AFTAB HUSSAIN on at

    Hello Ben,

    Just try reinstalling SSRS and see if the issue fixes.

    Also you can refer : support.microsoft.com/.../2011889

    Thank you !

  • ben.tong Profile Picture
    ben.tong 165 on at

    Hi  AFTAB HUSSAIN,

    I tried it before , its work, anyway thank for you help.

    Regards,

    Ben

  • Rabi Profile Picture
    Rabi 75 on at

    Got the same problem and restarted reporting service  and worked for me.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans