Main Menu
Home > Support > FAQs > Answer
During IP-guard setup, I've got the error message (7) that it cannot recognize the SQL installation

Please make sure the required service pack and database settings are installed and configured properly.

  • If the Server is installed on Windows 2000 SP4, please make sure the system is updated with service patch: Win2000-KB891861-v2x86-*.exe
  • If you are using Microsoft Server 2000, please make sure that it is updated with Service Pack 4: SQL2000-KB884525-SP4x86-ENU.exe

From our experiences, the user also failed to configure the following items:

1. The users do not install corresponding correct SQL Service Pack. Ensure that SQL Server 2000 is installed together with SP4, and SQL Server 2005 is installed together with SP1.

2. During installation in Express 2005, we should select default instance MSSQLSERVER NOT SQLEXPRESS instance.
Now should check from the Service: the MSSQLSERVER instance should be running, if not, please re-install again as you selected the instance wrongly during setup.

3. After the server was installed, the users forgot to check and configure the server settings in SQL Server Configuration Management e.g. enable the required protocol Named Pipes AND the log on must be “LocalSystem”.

Most of the users can solve those problems after the above checking.