Unable to Link to SQL Server

Posted By Matthew Shaw 11 days ago

Hi All

I'm trying to install CRM on one server and SQL (2019) exists on another server.

I have downloaded SQL Management Studio to the CRM server, but even doing that when attempting to install CRM, there is no option to link to a SQL Server. I only get 'Azure SQL' or 'SQL Express'

What do I need to do in order for the option for SQL Server to appear?

Parents

0 Sage CRM 11 days ago

To confirm, you are not getting the top option?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Matthew Shaw 11 days ago in reply to Sage CRM

That is correct. I only get the other two.

Sage 200 is also installed on this server and is seeing the SQL server without issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Matthew Shaw 11 days ago in reply to Matthew Shaw

Very Weirdly, I have now uninstalled the SQL Management Studio from the CRM server, and now the option to connect to Microsoft SQL Server is now available.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage CRM 11 days ago in reply to Matthew Shaw
It think I know the criteria.

Sage CRM explicitly requires:

Microsoft OLE DB Driver for SQL Server v18 or later

Installed locally on the Sage CRM application server

This is separate from SSMS.

But if you have this now, all is good.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sage CRM 11 days ago in reply to Matthew Shaw
It think I know the criteria.

Sage CRM explicitly requires:

Microsoft OLE DB Driver for SQL Server v18 or later

Installed locally on the Sage CRM application server

This is separate from SSMS.

But if you have this now, all is good.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage CRM

Unable to Link to SQL Server

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING