4. After installation, you don’t need to reconfigure the PATH Environment variable on Windows. You could sqlcmd Utility on command line to interface with MSSQL. You may also want to download Microsoft SQL Server 2008 R2 RTM - Management Studio Express...MS SQL installation on Windows and Dataset import Part I. MS SQL installation on Windows I will show you how to install Microsoft SQL Server 2008 R2 Express 32/64-bit (English) step by step. Microsoft SQL Server 2008 R2 Express SP2 can be downloaded at http://www.microsoft.com/en-us/download/details.aspx?id=30438 1. Download the corresponding edition of MS SQL 2008 R2 Express to your machine. (SQLEXPR_x86_ENU.exe for 32 bit process and SQLEXPR_x64_ENU.exe for 64 bit process). I will use SQLEXPR_x86_ENU.exe for illustration. 2. Go to the download folder and start the installation executable SQLEXPR_x86_ENU.exe. When you see the SQL Server Installation Center Dialog, click the “New installation or add features to existing installation” option. 3. After that, you just need follow the prompted installation instructions. Remember to leave all the features checked. If you have previous edition of SQL Server installed, you could create new instance of MS SQL 2008 R2. But please do remember new instance name you created. And you are recommended to choose “windows authentication mode” for simplification. 4. After installation, you don’t need to reconfigure the PATH Environment variable on Windows. You could sqlcmd Utility on command line to interface with MSSQL. You may also want to download Microsoft SQL Server 2008 R2 RTM - Management Studio Express for MS SQL GUI interface at http://www.microsoft.com/en-us/download/details.aspx?id=22985. Below is the basic usage on command line: sqlcmd -S .\InstanceName -U login_id –P password If neither the -U option nor the -P option is specified, sqlcmd tries to connect by using Microsoft Windows Authentication mode. Authentication is based on the Windows account of the user who is running sqlcmd. Refer to http://technet.microsoft.com/en-us/library/ms165702(v=sql.105).aspx for further information. If you want to create a new login, you could type in CREATE LOGIN User_Name WITH PASSWORD = 'Strong_Password' Please make sure the Instance was set to Windows & SQL Server Authentication mixed mode before you login with newly created user name and password. Part II. Import company data into MS SQL Server Download create-company-data-for-MS-SQL.sql file from eLearning to your computer. 1. Using MS SQL Server Management Studio GUI Start SQL Server Management Studio Connect to your databaseFile > Open > File and select create-company-data-for-MS-SQL.sql Execute ! 2. Using Command Line: sqlcmd -S .\InstanceName -i create-company-data-for-MS-SQL.sql Either of methods will create the company database and populate the database with data. Note: download the file create-company-data-for-MS-SQL.sql not create-company-data.sql. If you follow the instructions above but still can’t figure it out, you could refer to this video at https://www.youtube.com/watch?v=CXJP4D503Tk or stop by my office during my office hours. By the way, you can down load most editions of the MS SQL for free from DreamSpark WebStore: University of Texas at Dallas - Computer Science - DreamSpark Premium at http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=1611d1a5-cd9b-e011-969d-0030487d8897&vsro=8 A user account has been created for each of you at your school's DreamSpark WebStore. If this is the first time to login, you need create a unique password for your
View Full Document