Use of SQL express 2005 edition, local... ;-)

After killing the process & reboot to free the log file: DbInstallLog

update.ini
At Line number 0, the following error occurred:
SQL Server does not exist or access denied.
ConnectionOpen (Connect()).

State:08001,Native:17,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
State:01000,Native:10061,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]

At Line number 0, the following error occurred:
SQL Server does not exist or access denied.
ConnectionOpen (Connect()).

State:08001,Native:17,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
State:01000,Native:10061,Origin:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]

If I take a look on the SQL server config, surprise, all the same default 1433 was OK in the axinstall settings SQL screen part, and pass throw without error, I see after 2nd reboot, the Dynamic port was active, and port switch to 1403... OK I try 1 more time after fixing port 1433, delete the "0" of the dynamic ports, as explain in connect...

I try to connect the Express SQL using management tools, and it fails...
So I reinstall... all is OK except during install
(I use the sp3 advanced express + management tools)

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

Service 'CORP-SRV-24\SQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdNa...

Details
ID: 29533
Source: setup.rll

We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

--------------------------------------------------------------------------------

Thank you for searching on this message; your search helps us identify those areas for which we need to provide more information.

Finally, I was coming back my snapshot.
If any body got same similar issue, please notify here.
I will try again after my holiday. ;-)

Hello,

I have seen something similar when I upgraded the service pack in the database. If you notice the screen capture you have for the TCP/IP  change the setting for IP1 from Enabled = no to Enabled = Yes.  Accept changes restart the SQL service and reinstall.

Nelson

Hi there,

Here the installer is also hanging at the 96% mark and from that moment it is impossible to open the database from the altiris server.
If i open the database from any other server with odbc there is no problem at all. My sql instance is running on a separate sql server. 
The most strange thing is when i change the odbc connection on the altiris server to the ip adres of the server that the connection to the database is restored again. It looks like the installer is blocking access to the server on the name you provide in the installer.

So in my case the eXpress odbc connection is to server\sql01 and that is what i give in during the setup of 6.9 sp2. When the setup is at the 96% mark and hangs the setup the odbc connection is also no longer working. But when i then change the odbc connection to the ip adres of the sql server (10.0.0.1\sql01) than the connection works again.

It really looks like the installer somehow blocks access to the sql server.

I`am running Windows 2003 Enterprise SP2 + updates until 31-07-09 without the ie8 update.

Grts, Marco

I'm getting the exact same behavior as Marco. Anyone have any ideas?

Thanks,
Stephen