PDA

View Full Version : ISSQLServerInstall failure



jefftanner
06-09-2004, 03:03 PM
I am getting consistently during the installation of my InstallScript MSI an error connecting to a deployed MSDE SQL server, however, I have not problem connecting to the same SQL server using ODBC Data Source admin tool.

Attached is a simple InstallScriptMSI project (within SqlTest.zip) that will:

Install Redistributables MSDE 2000 SP3a as MSSQL$TELESYM_DB_SVC
Install Redistributable MDAC 2.8
SQL Script to create a TABLE within NorthWest database.


This is the install process using SqlTest.ism
[list=1]
Built and Ran SqlTest.ism
SQL Server panel of Install
SQL Server: (local)\TELESYM_DB_SVC,
SQL Authentication,
Login ID: sa,
Password: manager
Got an error 27502, see below "verbose setup log"
Verified that MSSQL$TELESYM_DB_SVC service was started
Verified that an ODBC Data Source could be added (TELESYM_DB_SRC) using Server: (local)\TELESYM_DB_SVC, Connection test was successful.
[/list=1]


From verbose setup log:

Action 11:59:22: ISSQLServerInstall.
MSI (s) (6C:F4): Executing op: CustomActionSchedule(Action=ISSQLServerInstall,ActionType=1025,Source=BinaryData,Target=ISSQLServerInstall,CustomActionData=C:\DOCUME~1\JEFFT~1.COR\LOCALS~1\Temp\~1E6.tmp)
MSI (s) (6C:F4): Creating MSIHANDLE (644) of type 790536 for thread 3828
1: HRESULT=0x80040154: Class not registered

Error 27502.Could not connect to SQL Server (local)\TELESYM_DB_SVC.

The verbose setup log (SetupVerbose.log) for this failed install is within the zip file.

jefftanner
06-09-2004, 03:06 PM
Missing SqlTest.zip

jd6strings
02-09-2005, 06:51 PM
See this MS Article for a know MSDE bug:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306865