Using different SQL instance for Reporting Services

(0) Share

Report

Posted on by Sindre Wetting

I'm upgradering a CRM 2011 to CRM 2015, and trying to reuse the existing SQL-server (I have an intermediate server for CRM 2013).

Since the reporting service is running under a "NT Authority\Network Service", I'm not able to reuse this - and since it is used by other applications we don't know what will happen if the service account is changed to a domain account. A solution si to install a new instance with SSRS only. Is it possible to have a different instance on the SQL-server with SSRS installed only, and have the SSRS databases on a different instance (where the CRM-DB is)? The Service Account for SSRS can then be configured to be a domain account. Or would this be considered bad practice?

It might be cleaner and easier to have both CRM-db and SSRS-DB on the same instance.

This is SQL 2012 Enteprise.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Sartaj 880 on at

Like (0)

Report
Copy link

Link copied!

Hi Flowjob,

Yes, you can have SQL Serve named instance where you can have SSRS server role which will be used by the new CRM setup.

Let me know if you was asking something else.

Hope this help, thanks.

Sartaj

Was this reply helpful? Yes No
Arpita Saini on at

Like (1)

Report
Copy link

Link copied!

You need to remember few things

1) It is not supported to share same ssrs instance with multiple CRM deployment

2) same ssrs instance will be used by all orgs/tenants in one CRM deployment

3) If you have sql and SSRS already there on a server create another instance of SSRS and SQL on same server and use that for new crm setup

4)doesn't matter you use network service or service account until there is no NLB. If you are using SSRS in NLB for a crm deployment service account is a must to manage

authentication.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

i think that my problem is quite related with this.

We have CRM 2013 installed and used by an instance called IP. Now we are creating a new instance called SIPP using the same CRM 2013 and all DB and server locations.

We are facing a problema that wen using the instance SIPP (new one) and we want to user the Reporting Services for that, it gives an error saying that the userid "xxxx-xxx-xxx-xxx" in the content organizationid "xxxx-xxx-xxx-xx-xxxx" is disabled.

i've checked out that the user that we are using is disabled in the instance IP and it is to be like that. But if we enable the user, the call of reporting services works to correct instance, but if it remains disable it doesn't go to the new instance SIPP.

Best regards,

JC

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

I have the same problem. (dynamics CRM 365 SP2 on premises)

I install one CRM deployment on a SSRS instance.

Now, I want to install another CRM deployment with another SSRS instance on the same server than the first instance.

It seems not working.

Do you have an idea ?

What can I do.

Thanks and regards,

Gwen

Was this reply helpful? Yes No