SQL Server 2008 installation Issue Resolution GOTO

Some problem solving methods for installing sqlserver2008

1, the installation of SQL Server appears as shown, the solution is: start → run → input "regedit" → find "hkey_local_machine\system\currentcontrolset\control\session Manager "Click the item and delete" PendingFileRenameOperations "to the right.

2, installation fails, uninstall clean SQL Server.

Method: Find Microsoft SQL under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft" to delete the entire file directly.

Locate the Microsoft Sql direct removal under "HKEY_CURRENT_USER\Software\Microsoft".

Locate the path to the installation disk and delete all the files that were installed in SQL.

The service items are also deleted, direct SC delete "ServiceName" can be.

Download MSICUU2 Remove the option for SQL.

Download Msicuu2 's address: Http://files.cnblogs.com/files/Hackerman/msicuu2.rar

3. Tip message: The type initializer for "Microsoft.SqlServer.Management.Dmf.PolicyStore" throws an exception. (MICROSOFT.SQLSERVER.DMF) failed to load file or assembly "Microsoft.SqlServer.Diagnostics.STrace, version=10.0.0.0, Culture=neutral, Publickeytoken=89845dcd8080cc91 "or one of its dependencies. The system cannot find the file specified. (MICROSOFT.SQLSERVER.DMF)

Workaround: Go online to download a Microsoft.SqlServer.Diagnostics.STrace.dll copy to C:\Program Files\Microsoft SQL Server\100\tools\binn\ Vsshell\common7\ide this directory.

Download Microsoft.SqlServer.Diagnostics.STrace.dll's address: http://files.cnblogs.com/files/Hackerman/ Microsoft.SqlServer.Diagnostics.STrace.rar

4, prompt error 5120

This error is because there is no operation permissions, so the additional time error, as long as the file or folder security properties can be set, but pay attention to the database file and log file security properties must be changed, otherwise it will be wrong.

Workaround:

1. Open the directory where the database file resides locate the database file, right-click the Open Properties window, select the Security tab, and select the Edit button.

2. In the select Group or user Name list, select the user you are using, generally choose administrators and Authenticated Users, then select Full Control in the Permissions list, choose the app and OK button to use!

Look at the diagram says:

5. SQL Server 2008 does not allow you to save changes, and your changes require that you remove and recreate the workaround for the following table

WORKAROUND: Start SQL Server Management Studio

The Tools menu----options----Designers (designer)----prevent saving changes that require you to recreate the table uncheck the box.

SQL Server 2008 installation Issue Resolution GOTO