Link to home
Start Free TrialLog in
Avatar of Wayne Barron
Wayne BarronFlag for United States of America

asked on

Install SQL Server 2019 WITHOUT Data Quality Service?

perHello All;

I have just run into a situation where I cannot find any information on it.
Installation of SQL Server 2019 WITHOUT installing Data Quality Services
If I uncheck it, it unchecks EVERYTHING.
So, the question is...
How do you install the SQL Server Database Engine, without installing the Data Quality Services

The reason:
I am installing the "SQL Server Failover Cluster" on the 2016 Desk Experience Server.
After this, I will be installing "Add node to a SQL Server failover cluster" on the 2016 CORE Server.

From my experience, adding the NODE fails every time I have tried to install it on the core.
A person posted but without proof that the Data Quality Services does not run on Server Core.
(This is my thread about the issue)

I am building my SQL Servers Clusters from scratch, and want to get the Core servers running SQL Server database engine.
And whatever I install on the Main SQL Cluster, will filter down into the NODE installations.
So I need to be cautious about what gets installed to make sure everything is going to go smoothly on this build.
These are the typical features that get installed on the NODE's
SQLEngine, SQLEngine\Replication, SQLEngine\FullText, SQLEngine\DQ
So please, if anyone has any information on this TA or the other TA, please let me know.

Thanks.
Wayne
Avatar of Hayes Jupe
Hayes Jupe
Flag of Australia image

I believe its seen as a required component via the GUI installer

While i haven't tried either of these on a cluster (i dont have enough VM capacity to test this sorry) - have you tried generating the install configuration file, exporting it, removing DQS and installing silently passing the customized config file ?

Alternatively - complete the install, then run "dqsinstaller.exe -uninstall" on each node (not ideal i know....)
Avatar of Wayne Barron

ASKER

I tried the "dqsinstaller.exe -uninstall"  before, and though I completed it, it still existed.
I can try to install and then remove it on the desktop server and see if it gets rid of it.
I will try anything at this point.
yep, fair enough - sorry, dont have anything else to offer at this point mate.
I just found this.
Install SQL Server on Server Core
It states: 
Data Quality ServicesNO
So that person was accurate.
I am going to finish reading through the article and see if it will give me any more insight into how to install.
Still not uninstalling.
I give up, this "Data Quality Services" is a joke.
Microsoft does not have enough information on this mess to get it done right.
And Forcing the installation of it, when it is not needed, nor wanted, is just frustrating.
As it sits right now, I cannot install SQL Core.


>> I tried the "dqsinstaller.exe -uninstall"  before, and though I completed it, it still existed.

Running dqsinstaller.exe -uninstall will not completely remove the Data Quality Services from your Server, you would need to do some cleanup manually..
Please find MSDN page to manually cleanup those items.
https://docs.microsoft.com/en-us/sql/sql-server/install/remove-data-quality-server-objects?view=sql-server-ver15
ASKER CERTIFIED SOLUTION
Avatar of Philip Elder
Philip Elder
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I'm thinking that as well, Philip
I think I might simply do a CORE main SQL Cluster install and see what happens.

@Raja
Yea, I had seen that page a few days ago when I started this venture.

OK.
I will post back in a little while.
Going to do a Core SQL Cluster attempt install.

I decided to close this question out and open another one.
Taking the information I had originally posted here and used to help with the new TA.

For anyone who may be interested, here is the link.
Server 2016 CORE - Install SQL Server 2019 - Issues.

Thanks.
Wayne
It's done.
I figured it out and posted my code for others to use.
It is the last Comment from me, as Answer.
Server 2016 CORE - Install SQL Server 2019 - Issues.
Have a good one all.