SQL Installation and Troubleshooting:
Refer to the below solutions for the errors you may come across during eScan Server installation while installing the SQL component.
For SQL installation error you may refer to the SQL Server Setup Log.
SQL Server 2005 Setup log, is located at %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
If the summary.txt log file shows a component failure, you can investigate the root cause by looking at the component's log, which you'll find in the %Program-Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files directory.
Error:
Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
Unable to install SQL 2005 on Windows 64 Bit OS.
While installing eScan Server, during SQL installation the installation fails and Summary.txt and its corresponding log shows below error :
Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
Solution:
Probable cause of the issue:
This may occur with SQL Server 2005 on 64-bit version of Windows where you need to install ASP.NET as a 32 bit application.
Solution:
Open Command Prompt with "Run As Administrator" and execute the below commands.
Command 1: This script enables installation of ASP.NET (32 Bit) on a 64 Bit OS.
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
Command 2: Browse to the below path and register ASP.NET.
%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\
aspnet_regiis.exe -i
Restart the computer once and then install eScan Server.
**********************************************************************************************************************************************************
Summary.txt shows blank.
Solution:
User may have not logged in with Windows Administrator login.
Login as Administrator and then start the eScan Server installation.
**********************************************************************************************************************************************************
Windows SBS - Preinstalled MS-SQL
In Windows SBS, You will get preinstalled SQL Server Sometime with SA disabled and limited rights when you connect with Windows Authentication. Because of this when we install eScan WMC it was not able to connect to SQL Server.
Enable SA.
To do this, open Registry and browse to below path:
HKLM\Software\Microsoft SQL Server\MSSQL_ServerName\MSSQL Server\LOGINMODE=1
Change this entry to 0, it will enable the MIXED MODE Authentication of SQL Server.
After Changing the Loginmode Plz restart the Service of SQL Server and SQL Browser once.
Then Open Command Prompt. Go to "C:\Program Files\Microsoft SQL Server\”
Run the command:
SQLCMD.EXE -S Server Name -E
Alter login sa ENABLE
GO
Alter login sa with Password='password'
GO
OR
OSQL -S Server Name -E
SP_Password NULL,'New Password','sa'
GO
Plz restart the Service of SQL Server and SQL Browser once.
Again open Registry
HKLM\Software\Microsoft SQL Server\MSSQL_ServerName\MSSQL Server\LOGINMODE=0
Change this entry to 2.
Plz restart the Service of SQL Server and SQL Browser once.
Now open SQL Server Management Studio and Try to login with Sql Server Authentication, username will be sa and the password will be the given password.
**********************************************************************************************************************************************************
Error:
Product : MSXML 6.0 Parser
Product Version :6.10.1129.0
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0009_MIS_MSXML6_1.log
Error Number : 1625
Analysis:
Uninstalling existing "MSXML 6.0 Parser", from Control Panel gives error and cannot uninstall it.
Uninstalled "MSXML 6.0 Parser" using "RevoUninstaller" and all other version of msxml already installed .
Re-installing eScan afresh shows the same problem.
Solution No.1 : By fixing using Microsoft Fix it tool:
First uninstall eScan Server.
Download "Microsoft Fix it 50568" from the below link and install it.
http://support.microsoft.com/kb/968749
Restart the computer and install eScan Server and the installation including SQL will be successful.
Solution No.2 : Manual procedure:
Refer to C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0009_MIS_MSXML6_1.log
Note down the Product GUID/code related to MSXML Parser.
1) Locate the following key in the registry related to MSXML Parser GUID:
HKEY_LOCAL_MACHINE\Software\Classes\Installer\Products\ (where is the 32-character unique GUID).
In this case the Product ID/code was {A43BF6A5-D5F0-4AAA-BF41-65995063EC44}.
Delete that GUID (Note: You need to delete the relevant guidd/code as shown in your SQLSetup0009_MIS_MSXML6_1.log file)
Now, re-install eScan Server and the installation should complete successfully.
Probable cause of the issue:
This issue may arise if the installer based on the presence of this registry key believed that SQL Server 2005 already exists and so it skips installation and other components of SQL.
***********************************************************************************************************************************************************