Sethu's blog

January 6, 2012

SQL Server 2012 Express LocalDB

Filed under: LocalDB,SQL Server — sethusrinivasan @ 2:41 pm
Tags:

 

Highlights:

- Small download footprint

- Very quick installation

- Simple Installer – No installer options – (Just Accept EULA)

 

About LocalDB: http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx

 

Download LocalDB

1) Goto : http://www.microsoft.com/sqlserver/en/us/editions/express.aspx , click on “Download 2012 RC0 EXPRESS”

 

image

 

2) If Windows Live ID sign-on was prompted sign in using your live id
 
3) Select Language and platform, Select “LocalDB”

http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx

image

 

4) Wait till download manager completes downloading SqlLocalDB.MSI

image
 

 

Installation:

Launch Installer SqlLocalDB.MSI

image

 

image

 

image

 

image

Unattended Installation:

   1: msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES

Management tools:

You can install SQL Management Studio Express from

http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx

image

 

Connecting to LocalDB

- Launch Management studio

- In Connection dialog, connect to (localdb)\v11.0

image

 

-

image

References:

http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx

http://blogs.msdn.com/b/sqlexpress/archive/2011/10/27/net-framework-4-now-supports-localdb.aspx

Theme: Rubric. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.