Baylor University



Installing SQL Server 2012 Express Edition with Tools Last updated 3.15.2016If you already have version of SQL Server Express Edition installed that is earlier than 2008 R2 SP2, you need to either:upgrade to at least 2008 R2 SP2 PRIOR to installing SQL Server 2012 Express Edition ( then choose “upgrade from SQL Server 2000, SQL Server 2005, or SQL Server 2008) OR uninstall the older version including the management studio (add/remove programs, all components) then re-boot and install the newer version. Also, if you already have a version of Visual Studio installed that is earlier than 2010 SP1, you need to either:upgrade to at least VS 2010 SP1 PRIOR to installing SQL Server 2012 Express Edition () ORuninstall the older version and upgrade to VS 2012 PRIOR to installing SQL Server 2012 Express EditionTo run SQL Server 2012 R2 Express Edition, ensure your computer meets the following minimum requirements (): Minimum of 512 MB of RAM (1G or more is recommended.) 1.9G of available hard disk space 1GHz processor speed (32-bit); 1.4 GHz processor speed (64-bit) (2.0 GHz or faster recommended)Windows Vista SP2, Windows 7 SP1, Windows Server 2008 R2 SP1, or Server 2012 or 3.5 SP1 An internet connectionTo download the SQL Server 2012 Express Edition software WITH management tools:I suggest you download from the website. If you choose to download from dreamspark proceed with step 2; if you download from proceed with step 3.If downloading from : click on “students”, sign in OR create a new account if you don’t already have one—it’s free, go to software catalog, under “Servers & Applications” choose SQL Server 2012, choose “Express with Tools ??-bit” where ?? is either 32 or 64 bit, then click the green Download button. You may see the screen below. If so, click the orange button in step 1 to run the download manager. If you get the message below, click Run, then click Run again if requested.Follow the instructions in the wizard to install the download manager.Once the previous step is complete, click the orange button in step 3 in the screenshot above to begin downloading sql server. If you get the message below, click Open (and click Yes to Allow the program to make changes to the computer if prompted).Click the green “Start Download” button (took approximately 6 minutes on my computer):Click on the dark green Launch button (took approximately 2 minutes to extract files)If downloading from Download buttonChoose the appropriate SQLEXPRWT_x??_ENU.exe download, where ?? is either 64 or 86, depending on your operating system, then click the Next buttonSave the file on your computerGo to the location where you saved the .exe file and double-click itWhether you downloaded from dreamspark or , select either a new installation or an upgrade as appropriate. ***Note that the remaining screenshots are based on an upgrade installation from SQL Server Express Edition 2008 R2 SP2, but the screens should be similar to a new installation***Wait for setup rules to be checkedAssuming no product updates are needed, click Next.Wait for setup files to be installed (approximately 3 minutes). You may get a message that a restart will be required after installation; if so, click OK. Accept the license terms and click Next.(a) If you are upgrading from an older version of SQL Server Express Edition, you will get screen (a) below. If you have multiple copies of SQL Server installed, choose the instance you want to upgrade. Click Next. - OR -5038725137160(b)00(b)1190625118110(a)00(a)(b) If this is a new installation, you will get screen (b) below. Click the Select All button, then click Next.228600175260003434080825500Wait while installation or upgrade rules are checked. If upgrade errors are found, click Cancel, correct the errors, then restart the installation.If this is a new installation you will see a screen similar to below. Accept the default values and click Next.If this is a new installation, then after confirming you have the necessary disk space, you will be asked if you want to customize the accounts that run SQL Server. Accept the default values and click Next.If this is a new installation, you will get the screen below. Ensure the Server Provisioning tab of the Database Engine Configuration screen appears as below. Provide a strong password for the ‘sa’ account. The password is case-sensitive. I suggest you write down your ‘sa’ account password so that you will not forget it. NOTE: the ‘sa’ ID is a SQL Server logon ID that has all administrative privileges in the database system. Click Next.Click Next on Error Reporting ScreenThe installation (or update if you’re upgrading) should begin. Took approximately 20 minutes.Installation completeIf you downloaded SQL Server from dreamspark, then download and install SQL Server 2012 Service Pack 1 (). Note the SP1 download is a zip file, so needs to be unzipped first. Then run the 64-bit executable file to install the service pack. Take all the defaults. Installation took about 8 minutes.Accessing SQL Server Database from Clients49644304635500In order to be able to access your instance of SQL Server via SQL Server Management Studio, take the following steps which you will perform one time only: Start | All Programs | Microsoft SQL Server 2012 | Configuration Tools | SQL Server Configuration Manager33915359271000Expand the SQL Native Client 11.0 Configuration (32bit) node; Select Client Protocols; ensure the protocols on the right-hand side appear as shown (to change from Disabled to Enabled, right-click the IP protocol and choose Enabled). Repeat this for the SQL Server Network Configuration node’s Protocols for SQLEXPRESS.Also repeat this for the SQL Native Client 10.0 Configuration node’s Client Protocols.Click X to exit the configuration manager.Upon exiting the configuration manager you may get the warning below. Click OK. Then either stop and restart the SQL Server Express Edition service (not recommended), OR simply re-boot your computer (recommended).5209540-2159000Logging in to SQL Server Management StudioStart | All Programs | Microsoft SQL Server 2012 | SQL Server Management StudioTo log in to SQL Server, first make sure Server type is Database Engine. Then follow the remaining steps on this page if you installed SQL Server Express edition on your own computer; otherwise, follow the steps on the next page if you are using SQL Server Express Edition in the lab.If you are on your own computer: Server name should already be filled in with a name resembling YOUR_COMPUTER_NAME\SQLEXPRESS. If this name is not filled in, type it in the Server name field using the format just stated.446278015875000To use Windows Authentications, choose Windows Authentication then click Connect445833511366500To use SQL Server Authentication on your own computer, choose SQL Server Authentication, enter your SQL Server-defined login ID (eg, ‘sa’) and password (password is case-sensitive), then click Connect445452512065000If you are in the lab:Ensure the Server name is HSB-MIS-SQL. Use Windows Authentication then click ConnectCreating a New Database ON YOUR OWN COMPUTERAfter installing SQL Server and SQL Server Management Studio, and after logging in the first time, I suggest you create a separate database to use for class work. Make sure you are logged into either your windows-authenticated ID, OR the ‘sa’ ID you setup during installation, OR some other ID that has been granted CREATE DATABASE access. To create a database, right-click the Databases folder and choose New Database…Give the new database a name at top (eg, MIS4340 or MIS4V98), then click OK--don't click Add 3676650115316000167640049593500017081534766251803402400300-23939500Creating a New Table in SQL Server Express EditionTo create a new table, first choose the Database that you want the table to be contained in, then right-click the Tables folder in that Database and choose New Table…You may get the message below; if so, just click OKEnter your column names, change the default Data Types, lengths, and table Name as appropriate; then click Save.2669540241490500533209574358500207581548450500127698556070500106489521780500 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download