Solved

SQL 2012 - What files to install / Explain Files

Posted on 2014-03-19
2
1,513 Views
Last Modified: 2014-03-20
Question
What are all files for on the install download for  SQL 2012 Express.

Thoughts
I installed the wrong files and had problems.  Thanks to Bill Ross http://www.experts-exchange.com/Database/MS-SQL-Server/SQL_Server_2008/Q_28391734.html
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
       
        SQLEXPRADV_x64_ENU.exe
        SQLEXPRWT_x64_ENU.exe
        SqlLocalDB.MSI

The following video might help
http://www.youtube.com/watch?v=vng0P8Gfx2g

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

Accepted Solution

by:
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

ENU\x64\SQLManagementStudio_x64_ENU.exe
 
http://www.microsoft.com/en-ca/download/details.aspx?id=29062
0
 
LVL 2

Author Closing Comment

by:LJG
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?
        SQLEXPRWT_x64_ENU.exe
        SqlLocalDB.MSI

Thanks again
LJG
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
why can not I insert data into my table ,i don't have any primary key? 5 39
Challenging SQL Update 5 43
SQL BULK INSERT Comma Delimited Issue 8 50
MS SQL Delete Query 9 33
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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