Notifications
Clear all
Topic starter
I am working on getting a V19 test server setup as I await the V20 release and as I am going through the directions I am encountering a problem when I attempt to run serversetup.exe for the first time.
The error message is:
--------------------------------------------------------------------------------------------------------------
Microsoft SQL Server Enterprise management tools are required to run Server Setup.
Please install the SQL server utilities on this computer and reboot your machine, or run setup from a different computer.
---------------------------------------------------------------------------------------------------------------
I suppose I could run setup from the SQL server; I admit I have not tried that yet but I usually have the staging directory on the Jboss server. I do recall support telling us to run it from the SQL server but I think they backed off and said it could be on Jboss again.
Anyway I have tried:
-installing for anything with the word "tools" from the SQL Server 2016 install DVD
-Installing SQL Server Management Studio V 18.5, released 6-6-20
-msodbcsql.msi <--it was a perquisite for SQL CMD line tools
-Installing Microsoft SQL Server Data Tools 15.9.5
If you google "SQL tools" you get many hits about 3rd party tools which is definitely not the answer. I can't think of a less generic term and since the error is Athena-specific, searching for the error message does not yield any helpful results.
The documentation for the SQL part of a V19 installation is somewhat lacking but somewhat helpful. It would be sufficient if I had not encountered this problem so I thought I would ask you guys here.
Thanks in advance.
Mike Zavolas
Tallahassee Neurological Clinic
Posted : June 16, 2020 1:28 am
you can try adding the sql server bin directories to the server path environment variable if not present already.
e.g. (yours would say "130" not "120", etc, and all these directories might not be present on just a client install, this is from a server)
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;
C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;
C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;
C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;
Posted : June 16, 2020 4:28 am
Topic starter
I don't have any of those directories. In my original post I mentioned all of the things I had installed but I restored a snapshot because I didn't want a bunch of unused programs and fragments on the server. Do you happen to know which tool(s) I do need to have installed? For now I just installed SSMS version 18 because that is an important tool to have which I do use.
Posted : June 17, 2020 6:53 am
The requested software the serversetup.exe is asking for is SSMS, but it is checking for a previous version. Try using version 17.9.1
Posted : July 1, 2020 3:54 pm
Was having the same issue and uninstalled 18 and installed 17.6 and was able to load the Server Setup. Thank you for the suggestion.
Posted : July 27, 2020 9:03 am
I think I ended up just installing SLQ Server 21014 as it had the tools baked in if I recall.
Posted : March 17, 2021 8:26 am
