Archive for September, 2013

SSRS 2008 R2 – Unable to Connect to Remote Server Error

September 30, 2013

I had installed SQL Server 2008 R2 on windows 7, but could not able to connect to the report server at http://MyServer:8080/Reports
Try doing the following things Go to Reporting Services Conf. Manager.

1. Change the server account to local account.

2. Remove the SSL if configured.

3. Go to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

4. Change the  SecureConnectionLevel value to 0 in rsreportserver.config

Try refreshing the page, it should work now!

Advertisements

MS Dynamics CRM 2011 : Update ‘Error Notification Preference’ Utility

September 11, 2013

CRM 2011 Update ‘Error Notification Preference’ is a small utility which allows you to quickly update CRM user’s Error Notification Preference based on your needs.
It also provides option to quickly filter users based on User’s status and domain to perform ‘Error Notification’ update.

This Utility uses Connection Controls for Microsoft Dynamics CRM 2011 developed by Tanguy.

Download

MS Office SharePoint 2013 Integration with MS Dynamics CRM 2011

September 10, 2013

Microsoft has released an updated component for SharePoint 2013 that allows you to store documents in SharePoint and relate them to CRM entities.  One of the features of CRM 2011 has been the ability to relate SharePoint document libraries to CRM data, but it was only for SharePoint 2010.  This updated component now officially supports SharePoint 2013.  This article will show you how to install and configure it.

1. Download the SharePoint components

Download the latest components from http://www.microsoft.com/en-ca/download/details.aspx?id=5283.  This includes the solutions for both SharePoint 2010 and SharePoint 2013.  Select the appropriate version (in this case I am assuming you are using SharePoint 2013.  Run the installer to extract the files to your local file system.

This will give you three files: AllowHtcExtn.ps1, crmlistcomponent.wsp, and mscrmsharepointeula.txt.

Also note that the installation instructions are not included in this download – they are on the download page itself.  I recommend that you copy/paste the instructions and place them in the same location you just extracted the download file to.

2. Enable .htc extensions

This component makes use of legacy .htc files that are not supported by default in SharePoint.  To enable the use of .htc extensions in SharePoint, open up a powershell command line and run the AllowHtcExtn.ps1 file you extracted using your sharepoint url as the first parameter.

3. Install the solution to your site collection

Navigate to the site collection that you want to use as a base url for your CRM documents library.  Once you are at the correct site, click on the settings icon in the upper right corner of the site and select Site Settings.  On the site settings page, click the Solutions link under the Web Designer Galleries section.  Click Upload Solution in the ribbon, browse to the crmlistcomponent.wsp file that you extracted earlier and upload it to SharePoint.

4. Activate the solution

After you upload the crmlistcomponent.wsp file, click the Activate button in the ribbon to activate the component.

Once activated you can now configure CRM to use SharePoint 2013 as a document library using the standard instructions that are available for CRM 2011.

Re-Publish CRM Reports in SRS

September 6, 2013

In case of need, there is a useful tool that will allow you to re-publish your CRM reports in the SRS server – handy if you or someone else deletes the folder.

Open a command window and navigate to C:\Program Files\Microsoft Dynamics CRM\Tools\   and run PublishReports.exe

Requires a parameter – being the Organisation Name. E.g. PublishReports.exe “mycompany”

Installing Microsoft Dynamics CRM 2011 with Microsoft SQL Server 2012

September 5, 2013

So with the recently released Microsoft SQL Server 2012, I was pretty keen to get a virtual machine up and running with a working installation of CRM 2011 and SQL Server 2012.

The basic installation is no different to that of SQL Server 2008 RTM/R2 except for the fact that you need the updated CRM Installation files. This took a while to figure out as I had no idea that the installation files were updated in January 2012 already. I was so used to the CRM 4.0 install with Setup Updates that download from the internet.
First and foremost, download the latest CRM 2011 Installation files from Microsoft. These installs include Update Rollup 6 and Update Rollup 6 enables CRM 2011 to work on SQL Server 2012.
By running each of these executables, you will be prompted to specify a folder to extract the installation files to.
I pre-created these folders in a temp directory and canceled the installer once all the files were extracted. Note. The installer does not remove these files from the temp directory when it is canceled.
I located my install folder that I created from the original CRM 2011 DVD  and removed the “old” files from the following folders:
  • \Server\amd64
  •  \BIDSExtensions
  • \EmailRouter\amd64
  •  \EmailRouter\i386
  •  \Client\amd64
  •  \Client\i386
Then I copied the files from my temp folder structure back into the folders above so that I now have a “new” CRM installation DVD v05.00.9690.1992
After installing a fresh copy of Windows Server 2008 R2 with SP1 – x64 – Standard Edition and converting it to a Domain Controller, I installed SQL Server 2012 – x64 – Standard Edition. The basics here apply – Database Server, Full Text Search, Reporting Server, BIDS and Management Studio.
I created all my services accounts:
  • svc.CRMASync
  • svc.CRMSandbox
  • svc.CRMApplication
  • svc.CRMDeployment
  • svc.SSRS (NB! when you install SQL Server, you will need to use this account to start the SSRS Service otherwise the CRM SSRS Data Connector will not install)
I created the Organizational Unit for the CRM Security Groups and all the other bits and bobs required for the install, such as adding the two service accounts (svc.CRMASync & svc.CRMApplication) to the “Performance Log Users” security group etc.
I have been able to successfully install CRM 2011 on SQL Server 2012 in one fowl swoop without any errors or complications. Note. This is just a lab and was created in an “all-in-one” server scenario.
 
Additional Important Notes.
Update Rollup 6 enables CRM 2011 to work on SQL Server 2012 but is not fully supported. http://support.microsoft.com/kb/2686619
Fully supported deployments of CRM 2011 on SQL Server 2012 will be supported in the Q2 2012 release of CRM 2011 due for release around the end of April/May 2012
 
Original Source: immix-blog

SolarWinds free IP Address Tracker

September 4, 2013

Watch how SolarWinds free IP Address Tracker frees you from the evils of spreadsheets, delivering powerful and simple-to-use features that give you a unified view of your IP address space and the tools to manage it.

Download

Re-Open Closed Task, Phone call, email or activities in MS Dynamics CRM 2011

September 2, 2013

Sometimes, there will be a need to re-open an activity which was marked as completed. Though it makes us feel like going to the relevant activity and just re-open (Much similar to re-activating a Quote). But the answer is NO (we cannot do that in the interface). But, CRM provides you an option to do this with the help of  “On-Demand” PROCESSES formerly WORKFLOWS. So, let us consider an example of re-opening an completed TASK, below are the steps,

  • Create an new Workflow on the task entity.
  • Select “On-Demand” under Available to Run.
  • Click Add-Step and select Change Status.
  • Select the entity as Task and set that to open and the below options as desired.
  • Save and “Activate” the workflow.

Done with the workflow! Now, select the desired task from the list of activities and select “Run workflow” – Pick the relevant one and click OK, we are done.