Wayne Barron
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
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
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.
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.
ASKER
I just found this.
Install SQL Server on Server Core
It states:
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.
Install SQL Server on Server Core
It states:
Data Quality Services | NO |
I am going to finish reading through the article and see if it will give me any more insight into how to install.
ASKER
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 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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 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.
ASKER
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
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
ASKER
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.
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.
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....)