Visual Studio 2010 or VS 2008 SP1
Step 1: Double-click the installer. It will take some time to know. After that, the window will open as follows.
Step 2: From clicking this window in the installation menu (see left) now there will appear some options under the installation from right, click on the new option of SQL Server, standalone installation or add features. In the existing installation
Note:: After clicking on the window it may appear as a cry Just click on the Run button at the program.
Step 3: Now the installer will take a few moments to complete some operations. To continue, there are no operations that have failed status. If any operation fails then it will not be possible to proceed with the installation. Click OK.
Step 4: This is an express version, so I don't need to enter any product numbers. Just click.ถัด ไป
Step 5: Check to accept the terms and click Next.
Step 6: Now click on the install button. Some installation support files will be installed.
Step 7: Now again, will have to complete some operations. Every operation must be passed or warned or skipped. If any operation fails then it is not possible to continue. Click Next.
Step 8: Now choose the features you want. Here I choose the database application services, Busines Intelligence Development Studio, basic management tools and the SQLl Client SDK connection. Click Next.
Step 9: Here we need a name and such ID. I'm starting to choose a sample but give the name "SQLEXPRESS" in your mind for future use. Click Next.
Step 10: The window will now appear and it will display the necessary and available areas. Click Next.
Step 11: Here choose the account name from the dropdown list for SQL Server database ENGINE-
NT AUTHORITYNETWORK SERVICE and click Next
Step 12: Now choose the mode you want to use. Here I choose mixed mode.
For mixed mode, I have to give a password for the root account (username "sa" default) and adding my current user by which I will also be able to access the database tool without the default administrator account. (Username: sa)
Step 13: Click Next
Step 14: Now, every operation again must be passed or skipped. If there is an operation that has a status that fails to install, then it cannot be done. Click Next.
Step 15: Now, finally will start the installation. Click Install.
Step 16: Now wait until the installation is complete. Installation is complete. Click Next.
Installation complete.Install SQL Server 2008 SP1 If you experience any problems, just let us know. After installation, to see how to connect and perform basic operations by the studio executives see my next post.