Summary of SQL Server 2008 installation Failures

The first time to install SQL Server2008, encountered a lot of problems, various solutions to use, and finally installed successfully, will now experience one by one summarized as follows:

Background: Microsoft Visual Studio2008 was installed on this computer before you installed SQL Server2008

1,SQL server2008 installation When prompted to restart the computer failed to do

Find the following location in the left-hand directory Bar of the registry: "Hkey_local_machine\system\currentcontrolset\control\

Session Manager "Then select Delete" PendingFileRenameOperations "on the right.

2.SQL Server error "Checking for earlier versions of Microsoft Visual Studio " failed issues

Prompt for earlier versions of Microsoft Visual Studio when installing SQL Server error, 1

Figure 1

Workaround:

Search the internet for a bit, a lot of similar problems, there are two ways to solve:

method One: Modify the Registry folder name

Open the Registry manager (run--regedit)--hkey_local_machine\software\microsoft\devdiv (Figure 2), save the DevDiv export, and then rename DevDiv to DevDiv1 after exporting. Before you install the SQL Server 2008 error "Security Rules" page, click "Rerun", this will become "passed", continue to the next step. If you still fail after "rerun", see method Two.

Figure 2

method Two: Install Visual Studio SP1

Because the Microsoft Visual Studio 2008 initial release (RTM) supports only SQL Server 2005 Express (the default in the VS2008 installation disk is SQL Server 2005 Express), to enable it to support the latest SQL For the express version, you need to install Microsoft Visual Studio SP1 to support it.

To Microsoft's official website http://www.microsoft.com/zh-cn/download/details.aspx?id=13276 download Microsoft Visual Studio Service Pack 1 ISO format file, file size 898MB. After the download is complete, use WinRAR to unpack, run the folder within the SPInstaller.exe to install, although the patch is installed, but the time and the normal installation VS2008 time almost the same.

Reinstall SQL Server 2008 When you are finished installing.

3. How SQL Server2008windows authentication is changed to mixed authentication mode

Installation process all the way to the next point in the past, forget to set up a hybrid authentication mode, want to change the time to search a few Baidu solutions are not, ask colleagues quickly get resolved, now the method steps summarized as follows:

1. Open SQL Server 2008 in the beginning (Figure 3)

Figure 3

2.Click 1, select Authentication as "Windows Authentication" in 2,3 click "Connection", 4.

Figure 4

3.Right-click the properties, pop up the property settings page, and after setting the user name and password, click OK (Figure 5).

Figure 5

4 . Open "Configuration Manager" in SQL Server, restart the two services shown in, complete.

Figure 6

5. Next, you can log in to the database using SQL Server authentication, Figure 7.

Figure 7

Summary of SQL Server 2008 installation Failures