SQL Server Management Studio Installation Tutorial

Reprinted from: Liu Shuai's column

http://blog.csdn.net/liushuaikobe/article/details/7348238The following describes the installation tutorials for SQL Server Management Studio after Visual Studio 2010 has been installed (Mac and Linux users, please disregard this article, This article was tested in the Windows7 Ultimate Edition through the recent school learning. NET, to be used with SQL Server. In general, the management database is like MySQL, in the command line that dark window under the command management (but I did not find how to manage SQL Server under the command line), it will show you are very cow B; the other is to install a Visual database management software like SQLYOG, SQL Server Management Studio is such a software. Most of your classmates already have Visual Studio 2010 installed, and after you've installed visual Studio2010 (if you installed all of the components, such as the. NET Framework, and so on) while installing Visual Studio 2010, will automatically install a simplified version of SQL Server 2008, which is not with SQL Server Management Studio and requires you to install it the day after tomorrow.

In addition, I learned from a great God, if you do not install SQL Server Management Studio, in the VS2010 can also be visualized in the operation of SQL Server 2008, the specific needs to be verified, Ann uneasy choice.

During installation, if there are any exceptions that are not mentioned in this article, please follow the program prompts, or search the solution yourself, Google is not a vegetarian, you may encounter any version of the low exception, download the patch pack upgrade yourself.

In the above conditions to install SQL Server Management Studio, there are many ways, the internet is also a different approach, which I think a more reliable way is this article: http://www.cnblogs.com/william-lee/ Archive/2010/10/22/1858227.html. I am my own various Google, after a variety of attempts to install successfully, the following is the concise process of my installation:

First download the SQL Server Management Studio installation package (the following link is the official website link, please feel free to download, 200M or so):

64-bit machine: Sqlmanagementstudio_x64_chs.exe

32-bit machine: Sqlmanagementstudio_x86_chs.exe

After you run the downloaded file, a program compatibility prompt appears:

This official said is normal, directly click to run the program can.

Next there is the possibility of an error like this:

I checked this out, you can close the virus and firewall, and then right-click "Run as Administrator", if it also appears, quit running more than a few times, should pop up the following interface:

Click "Install" on the left side of the screen to select the first "new SQL Server standalone installation or add new features to an existing installation" on the right, and this interface will appear:

Click on the "OK" button and it will appear:

When it is finished, click on the "Install" button and the following will appear:

Note that if there is any problem, click on the blue Word behind, will pop up the error or warning specific information, this is very useful, you can use the information to search the solution, if no problem, click on the "Next" in this interface, will appear:

This interface is important and we can see that only the SQLEngine is installed on our machine and it feels like "adding new features to an existing instance of SQL Server 2008" can be installed successfully, but I chose the "Execute SQL Server 2008 New Installation ", after my pro-test can be installed successfully, so here we select" Perform a new installation of SQL Server 2008 ", and then click Next, will appear:

Then proceed to "next":

Didn't see?, I accept, "next":

Click on the "Select All" button below in this screen to make sure the function is selected and then the next step:

You know, "next":

This can be optional, casual, and then "next":

Then it will be ready to install the work, if there is any "restart problem", then restart the computer, repeat the above steps, and then "next":

The path should not be modified, directly click "Install" can:

Now that it's done, click "Next":

Click "Close".

Then go to start All Programs->microsoft SQL Server 2008 found in SQL Server Management Studio (for example):

Open, there will be an interface for you to authenticate:

Note: The server name must be filled in: "Your computer name \SQLExpress", write What "(local)" or "127.0.0.1" there will be errors, the first "Authentication" select "Windows identity Authentication", then click "Connect", then:

As for the follow-up we write the program even SQL Server can not use Windows authentication, to use SQL Server authentication, you can add a new account, set the password, and then restart the database, so it is all over.

In the subsequent use of the process you may encounter what error 233 Ah, or what error 14XXX Ah, don't be depressed, go to Google yourself.

I think when we encounter problems, we should first think of ourselves to solve the problem, as a contemporary senior intellectuals, we must have their own ability to deal with problems, you can try, do not know the problem must remember to ask Google or degree Niang, believe that you are not the first person to meet this problem, I wish you good luck, please correct me.

SQL Server Management Studio Installation Tutorial