Summary of SQL installation issues

Problem

SQL Server not installed

①, username must be administrator.

②, double-click the "Database Installation" can not be installed, you can install the program under the directory select Setupmsde to install or go to the program installation directory to select MSDE, enter and double-click Setup.

③, SQL server7.0 is incompatible with SQL server2000, you must first delete 7.0 before installing 2000.

When uninstalling SQL server7.0 is not properly uninstalled, the registry information for SQL Server is present in the registry, and the Service Manager's startup entry is present in the startup bar of the Start menu, prompting the runtime to not find a file with the suffix named. dll and not start the service manager.

Workaround: Enter "regedit" in the runtime, enter the registry, locate the HKEY_LOCAL_MACHINE registration entry, select Software on the Extended menu, and locate the MSSQLServer item that was selected after Microsoft opened. Click the right button to delete this folder, you can install. When the service Manager is running, when the installation is complete, you cannot find the suffix named. DLL, and then install the MSDE Uninstall reinstall in Control Panel to resolve the problem.

When the user's machine already exists MSDE2000

Solution:

(1) Access to database management, output into the database username and password (username admin, password default is empty), after the confirmation into the Database Maintenance window, select Database recovery, pop-up Database Recovery window (here has been the default of relevant information, such as the need to change can be set up separately), directly determined after.

(2) directly to the database installation, will prompt the database already exists, whether to overwrite, click Yes.

When the user's machine exists MSDE7.0 or the following version

Solution:

1), the MSDE7.0 or the following version of the database backup. (using the program or database itself that invokes the database)

2), uninstall MSDE7.0 or the following version

3), install MSDE2000 database

4), use the call MSDE7.0 or the following version of the program to restore the database just backed up

5), restore the database required by our software.

Uninstall "China Personnel Information Management system" software, install again will have no success

Solution:

①, installation unsuccessful: deleting Mscoree files and microsoft.net files under Windows

②, framework cannot be installed:

Registry cleanup:

Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\. NETFramework file

Deletes the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework setup file.

When you want to reload SQL Server, and the "You have installed an instance on your machine" prompt, you can remove the Program Files\Microsoft SQL Server folder and registry information, and then install.

XXX dynamic Link File not found

When a certain dynamic link file is not found, you can try to locate the file in the SQL Server installation file and copy it to the System and System32 folder (usually when this error message appears, you will be prompted which folders are missing the file).

When the setup configuration server fails, you can try to solve the problem by using a method

This error message can be found in the system directory, for example, if my system is Win2000, the file is in C:\WINNT\sqlstp.log

Failure One:

Being with the service?

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] Sqlallochandle on Sql_h of the ODBC Driver Manager driver

SQL Server configuration?

####################################################################

13:40:06 Process Exit Code: (-1)

13:40:09 Setup failed to configure the server. Refer to the server error log and C:\WINNT\sqlstp.log for more information.

13:40:09 Action Cleanupinstall:

When this error occurs, try reloading the system file

My machine is Win2000, rerun Win2000 installation in DOS, then choose Fix, not new installation

This error message does not occur after you repair the system files and then install SQL Server

Failure two:

Being with the service?

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC Driver Manager] does not find a data source

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC Driver Manager] does not find a data source

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC Driver Manager] does not find a data source

SQL Server configuration?

####################################################################

13:50:07 Process Exit Code: (-1)

13:50:10 Setup failed to configure the server. Refer to the server error log and C:\WINNT\sqlstp.log for more information.

13:50:10 Action Cleanupinstall:

When this error occurs, it is because in the registry you have deleted the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC about SQL sever in the

Failure three:

In with the service?

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Named pipes] connection?

[Microsoft] [ODBC SQL Server Driver] [Named Pipes] Connectionread (ReadFile ()).

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Named pipes] connection?

[Microsoft] [ODBC SQL Server Driver] [Named Pipes] Connectionread (GetOverlappedResult ()).

Driver={sql Server};server=zhl; Uid=sa; pwd=;d Atabase=master

[Microsoft] [ODBC SQL Server Driver] [Named pipes] connection?

[Microsoft] [ODBC SQL Server Driver] [Named Pipes] Connectionread (GetOverlappedResult ()).

SQL Server configuration?

####################################################################

17:17:41 Process Exit Code: (-1)

17:17:45 Setup failed to configure the server. Reference server error Logs and

When this error occurs, you must install the ODBC Repair tool