SQL Server Management Studio cannot install SQL Server 2008 R2 issues

Environment

SQL Server 2008 R2 + Visual Studio + sqlmanagementstudio_x86_chs

Problem description

Programming will inevitably be used in SQL Server or VS2010, although it is now rare to do c/c++/c# development. Previously I installed SQL Server 2008 R2 and Visual Studio 2010 in the order that you install SQL Server 2008 R2 and then install Visual Studio 2010 so that there is no problem. Winter holiday whim, but I was a rebellious psychological very strong person, you told me to do this I do not. So I switched the order of their installation, installed Visual Studio 2010, and then installed SQL Server 2008 R2, which led to the result that VS2010 was installed, but SQL Server was not. You cannot eject the stopped Working dialog box when you are finished running the rule. Find a lot of solutions, there is said to try the SQL Server 2008 development version, tried fruitless, asked a lot of Daniel did not get a good solution.

One day with a Daniel Exchange, C # play very well, windows a lot of things have mastered, the natural use of the database is SQL Server. But he didn't install SQL Server 2008 R2, he was using SQL Server from Visual Studio 2010. I remember that there is no graphical interface, I asked him how to do the graphical operation, he said that the use of SQL Management Studio, the amount, this name and SQL Server 2008 R2 installed a good graphical interface is not the same? Oh. He said it was a graphical tool that was only more than 100 m and could be manipulated like a SQL Server 2008 R2.

Therefore, the installation of VS2010 after the installation of SQL Server can not be a solution. Hey.

Solutions

1. Download the SQL Management Studio at the official website, only 100 m, also is not big, to 4G many SQL Server 2008 R2 is too small. Download the address reference below;

2. Install SQL Management Studio, this is just a tool, so will not install the service. And this tool's start interface, the Operation interface and SQL Server 2008 R2 belt consistent;

3. To use SQL Server to provide the following two ways:

(a) Use VS2010 's own SQL Server, or it will be used;

b If you do not install VS2010 or install VS2010 when the SQL Server component is installed, use SQL Management Studio to connect to someone else's computer remotely, the server name to fill the IP, the computer's database is not cool to operate. Note that other people's computer SQL Server Browser service to open, at the same time need to turn off the firewall;

4. For those friends who are not installed on SQL Server, this article provides a better solution. Oh.