As a DBA it is common to perform installation of SQL Server and related components. Most of the times, the SQL Server installation progressed soothly. But sometimes when the SQL Server install fails it may get very difficult to identify the cause and then to find a solution.
One of the strange or weird issue one may face with the SQL Server instance is that when you start the SQL Server installation, you will be prompted to install Setup support file after that the Setup wizard provides further options to choose the instance name, location for data, log file and service accounts, etc. However you may notice that after the installation of setup support files, the setup window just disappears and does not show up again to proceed further with selecting other options.
Generally SQL Server setup logs are created under C:\program files\Microsoft SQL Server\100(different for each SQL version)\Setup Bootstrap\Log\
Click on start->run and type %temp% and press enter (basically, go to the temp folder)
Here, look for SQLSetup.log and SQLSetup_1.log. Open the SQLSetup_1.log file.
Check these logs to see if you can find any specific errors or warnings. If you are unable to understand anything from those log files then you can do a quick search based on the error or warning messages in that log.
Coming back to the original issue of the SQL Server installation window getting disappeared after going through few installation wizard screens, you may try below steps to see if it resolves the issue.
– Open Control Panel – Add or Remove Programs and uninstall SQL Server Setup Support files. There may be multiple setup support files of multiple SQL Server instances, so remove them all.
– Logoff from the server, if possible reboot the server.
– Log back into the server and then start the SQL Server installation and now it should proceed further with the installation and should show the other options.
If above solution did not solve your problem with the SQL Server installation, then you can try the option of slip-streaming the SQL Server installation with latest Service Pack and then attempt the installation.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.