SQL 2012 - What files to install / Explain Files

Posted on 2014-03-19
Last Modified: 2014-03-20
What are all files for on the install download for  SQL 2012 Express.

I installed the wrong files and had problems.  Thanks to Bill Ross
I was able to correct the problem.

Files   (* indicated files I installed to have a good installation)
     * SQLEXPR_x64_ENU.exe
     * SQLManagementStudio_x64_ENU.exe

The following video might help

Thanks for the help for me and hopefully others that might get to this point.
Question by:LJG
LVL 39

Accepted Solution

lcohan earned 500 total points
ID: 39939919
"What are all files for on the install download for  SQL 2012 Express."

That depends very much on your needs but if no5t sure what to get just get the one that covers it all:
•Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
•This package contains all the components of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.

and  SSMS - SQL management tools that include the LocalDB.

ENU\x64\SQLEXPRADV_x64_ENU.exe 1.3 GB

and SSMS tools


Author Closing Comment

ID: 39944245
Thanks lcohan for the answer - I should have asked before i went forward.

Just wondered if you know what the following files are for?

Thanks again

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now