Sql-server – SQL Server 2014 Setup Fails with Error 5 – Terminal Services Unsupported

mstscsql server

I am installing SQL Server 2014 on a hosted virtual machine using remote desktop. When I run setup command line options display using .\setup.exe /? , I get the following error:

An error occurred during the SQL Server 2014 Setup operation.
Error result: -2067529723
Result facility code: 1220
Result error code: 5
For more information, review SQL Server 2014 Setup logs in your temp folder.

This error is instantaneous and it does not generate setup logs as stated.

I checked the system requirements for SQL Server 2014, and it state what I believe to be the root cause of the issue:

The installation of SQL Server 2014 fails if you launch the setup
through Terminal Services Client. Launching SQL Server Setup through
Terminal Services Client is not supported.

http://msdn.microsoft.com/en-us/library/ms143506.aspx

I have tried using powershell remoting with a tested core install command line string and it is returning an error indicating that setup is trying to launch a modal dialog:

.\setup /ACTION=INSTALL FEATURES=SQLEngine /INSTANCENAME=MAIN
/SQLSYSADMINACCOUNTS=portland\administrator /QUIETSIMPLE 
/IACCEPTSQLSERVERLICENSETERMS 

Showing a modal dialog box or form when the application is not running in
UserInteractive mode is not a valid operation. 
Specify the ServiceNotification or DefaultDesktopOnly style to display 
a notification from a service application.

What is the recommended approach to installing the product? Assuming I do not have physical console access, is there an MS approach that would not depend on Microsoft Terminal Services?

Best Answer

I would like to know, first of all, the intent of this restriction: are they no longer targeting/supporting this product for non Hyper-V virtualization contexts?

It's been this way for a while, actually. The same restriction exists for SQL Server 2012, and the reason is that installing SQL server over a Terminal Services session causes problems and non-deterministic behavior. (Has nothing to do with not supporting other virtualization platforms, and I have both SQL Server 2012 and 2014 instances stood up in Windows Server OSes on the ESXi hypervisor.)

I would like to know, first of all, the intent of this restriction: are they no longer targeting/supporting this product for non Hyper-V virtualization contexts?

The recommended approach is to install the product from a console connection.

As you say that's not an option, because of your host, I would first try using the command line to install it, following the instructions for installing SQL Server 2014 on Server Core. You should be able to use most of the options for connecting a remote command line in Windows to install SQL server remotely.

Alternately, there are remote GUI options that don't involve Terminal Services. You could install a VNC server on this VM, or use something like Webex/GoToMeeting/Teamviewer/etc. to get a remote GUI to the server without utilizing Terminal Services for the session.

Related Topic