Customer experience | Sales, Customer Insights,...

Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

(1) Share

Report

Posted on by Daniel Schneider

172

Hi all,

I try to use one SQL Server with two SQL Instances for our CRM Environments.

Currently:

I installed one SQL Server 2016 Develop with two Instances (DYNSQL80 and DYNSQL90). For each Instance I added one SQL Agent, SQL Database Modul and SQL Fulltext User in the AD.

Parallel I installed one Windows 2016 Server for Dynamics CRM 8.0 and one Server 2016 for Dynamics CRM 8.0.

In the end of the installation for Dynamics CRM 8.0 I get the error:

3323.connection-error.PNG

I chose in the setup for example servername\dynsql80 but I get this error. In SQL Server I saw that i am not able to run the SQL Agent for the first and second Instanz parallel.

I opened on the SQL Server the ports incomming tcp: 1433, 1434, 135, 139, 445, 808, 80 and incomming udp: 1433, 1434, 123, 137, 138, 445, 808, 80

So my question is how can I install two dynamics crm environments with different version in different sql instances on one sql server?

Best regards,

Daniel

All responses (5)

Answers (0)

saurabhtiwarii on at

Like (0)

Report

RE: Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

Hey Daniel,

Since you have now installed a new SQL developer edition on a new VM for this purpose and things still do not work out, I'm curious to know if the SQL server is reachable by it's physical name (The name of the server on which it was installed.) from the CRM server.

Try to ping SQL server name on CRM sever local command prompt window to see if it returns the IP address of our SQL server.

If it does, let's test the connectivity for the SQL port being used.. (PowerShell)

Test-NetConnection -ComputerName 192.168.2.100 -Port 1433 -InformationLevel Detailed

Please check what sort of exception you are served with if you create a blank text file on CRM server and rename it as Test.udl and do the test connection using these options, does it connect successfully with SQL?

Also, please validate if the Developer edition of the SQL installed is compatible with CRM 2016 and CRM version 9, we are planning to install.

For CRM server 2016 ::

https://support.microsoft.com/en-in/help/3124955/compatibility-with-microsoft-dynamics-crm-2016

Dynamics 265 Server (v9) supported SQL editions ::

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/deploy/software-requirements-for-microsoft-dynamics-365-server#sql-server-editions

Thanks,

Saurabh
Daniel Schneider 172 on at

Like (1)

Report

RE: Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

Hello Saurabh, thanks for your answer. I have installed a new SQL Server (OS and SQL Server software). Within the SQL installation I gave the standard instance its own name (DYNSQL90 - for all CRM servers with version 9.0). I have deactivated the firewall on both servers (SQL and CRM) like you and during the CRM installation he cannot find the SQL server, neither if I specify SqlServerName nor if I specify SqlServerName \ DYNSQL90. The instance is configured to allow remote access. I activated TCP / IP in the SQL configuration settings and specified port 1433. Even if I'm not using AD users but local users like you, the problem still occurs. But what I noticed is, if I give the SQL Server as an example: SqlServerName.google.local \ DYNSQL90, then I don't get the error at the end of the CRM installation, but the note that it could not be determined whether the SQL Agent is started. On the 2nd CRM server on which I want to install CRM v8, I cannot access the server again. Neither with the first method nor with the last method. I chose SQL Server 2016 Developer because both CRM versions support this SQL version and I don't want to create multiple SQL Server VMs.

Thanks for your help =)
Suggested answer

saurabhtiwarii on at

Like (0)

Report

RE: Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

Hey Daniel,

I have highlighted my responses for each of your queries ::

1. You installed SQL with default Instance e.q. MSSQLSERVER and after that you installed the second SQL Instance?

Yes, I already had a default MSSQLSERVER instance configured and on top of that a CRM isntalltion (v8.2) existed before I started with this another CRM 2016 installtion.

2. Did you used local User for example (NT SERVICE\SQLAgent$InstanceName) or your created AD User?

Yes, I used local user, Network Service for both " All CRM services" and "new SQL instance installation". Since this is a test deployment created just to test this scenario and has nothing confidential in it, I'm sharing the screenshot of the SQL services details for you ::

CRM services for default SQL instance ::

CRM Services details for the new Named Instance ::

3. Did you created for each SQL Instance different AD User for the service?

As you would see from the above screenshots, I hardly worked with any AD user account for CRM/SQL service which is indeed not a recommended practice.

Is these SQL instances part of a fail-over/availability group configuration? Please also check if the SQL server browser service is running as expected.

What happens if you create a blank text file on CRM server and rename it as Test.udl and do the test connection using these options, does it connect successfully with SQL?

https://docs.microsoft.com/en-us/sql/connect/oledb/help-topics/data-link-pages?view=sql-server-ver15

Thanks,

Saurabh
Daniel Schneider 172 on at

Like (1)

Report

RE: Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

Hi Saurabh,

thank you very much for your answer. But I have few questions about it.

1. You installed SQL with default Instance e.q. MSSQLSERVER and after that you installed the second SQL Instance?

2. Did you used local User for example (NT SERVICE\SQLAgent$InstanceName) or your created AD User?

3. Did you created for each SQL Instance different AD User for the service?

During in my SQL Installation I set an own Name for the first/default SQL Instance and I set in the CRM Installation like this SQLServerName\Instance to the sql selection. In the End of the CRM Installation the network error comes. If I remove the instance name I get the error that SQL Agent cannot get if its run. I turned off the firewall on both server (sql and crm) but the error comes again.

Thanks for your help.
Suggested answer

saurabhtiwarii on at

Like (0)

Report

RE: Use multiple SQL Instances for different Dynamics CRM OnPremise Environment

Hey Daniel,

Thanks for reaching Dynamics community. I tested this with SQL 2014 enterprise where I already had a default instance which had CRM 8.2 DBs and on top of that I installed another new named SQL instance and then installed CRM 2016 (v8).

During the installation of CRM, I just passed the named SQL instance which was installed on the default port as ::

SQLMACHINENAME\SQLInstanceName

I turned off the windows firewall on both CRM & SQL server and the installation just went through as expected.

Please mark my comment as answered if this helps.

Thanks,

Saurabh