MSDE installation hangs up

Hello,
I am having problems with an installation of MSDE. The computer alraedy has
an instance of MSDE installed with Outlook for the Contact Manager and I
have no problems with that instance. A new application I have installed also
uses an instance of MSDE for a database. During the installation of this
application (Sony Media Manager) the MSDE installation hangs up an dnever
completes. The only way out is to use task manager.
Examining the log file it appears to be sqlredis.exe that is hanging. I have
searched the web and MS knowledge-bases and found nothing that fixes this
problem. We really need this element of the application to work so that we
can efficiently access our media database. Any advice on how to proceed
would be much appreciated.
Sid.
hi Sid,
sidprice@.softtools.com wrote:
> Hello,
> I am having problems with an installation of MSDE. The computer
> alraedy has an instance of MSDE installed with Outlook for the
> Contact Manager and I have no problems with that instance. A new
> application I have installed also uses an instance of MSDE for a
> database. During the installation of this application (Sony Media
> Manager) the MSDE installation hangs up an dnever completes. The only
> way out is to use task manager.
> Examining the log file it appears to be sqlredis.exe that is hanging.
> I have searched the web and MS knowledge-bases and found nothing that
> fixes this problem. We really need this element of the application to
> work so that we can efficiently access our media database. Any advice
> on how to proceed would be much appreciated.
setupre.exe installs/checks MDAC stack on the installed machine...
there's a dirty trick to solve this... when the installation hangs, via Task
Manager kill the setupre.exe process and the setup will proceed and complete
successfully..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you for the suggestion, however, when I try to kill setupre.exe I get
an error the access is denied.
Sid.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:453olnF4aq7jU1@.individual.net...
> hi Sid,
> sidprice@.softtools.com wrote:
> setupre.exe installs/checks MDAC stack on the installed machine...
> there's a dirty trick to solve this... when the installation hangs, via
> Task Manager kill the setupre.exe process and the setup will proceed and
> complete successfully..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Sid,
sidprice@.softtools.com wrote:
> Thank you for the suggestion, however, when I try to kill setupre.exe
> I get an error the access is denied.
unfortunately this is the only dirty (and not supported) workaround I'm
aware of... and usually it succedes..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I tried one more thing, I uninstalled my Norton AV and your trick then
allowed the MSDE to continue. However, the installer reported an "unknown
error" after I killed the exe and the application is still unable to access
the database.
Any other suggestions please?
Sid.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:454008F4qlbrU1@.individual.net...
> hi Sid,
> sidprice@.softtools.com wrote:
> unfortunately this is the only dirty (and not supported) workaround I'm
> aware of... and usually it succedes..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Sid,
sidprice@.softtools.com wrote:
> I tried one more thing, I uninstalled my Norton AV and your trick then
> allowed the MSDE to continue. However, the installer reported an
> "unknown error" after I killed the exe and the application is still
> unable to access the database.
> Any other suggestions please?
> Sid.
actually not
BTW, it 's usually recommended to define exceptions in the the AV programs
for "*.Mdf" , "*.Ndf" and "*.Ldf", but this is another story...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||The dirty trick that Andrea describes is certainly a good workaround.
However, the root cause may be described in Microsoft’s Knowledge Base
article 841061:
http://support.microsoft.com/default...b;en-us;841061
They suggest there that your bootstrap program may be causing the hang by
not responding to a synchronous message broadcast to all top level windows.
If that doesn’t apply, you may be in the situation I’ve just solved, after
several hours’ detective work! :-) I discovered another application on the
machine was causing the hang. In this case, it was “Citi Virtual Account
Numbers” made by Orbiscom, distributed by CitiBank. I’m sure there are other
possible culprits. My guess is that this program is not responding to the
synchronous message broadcast to all top level windows. It has an icon in the
tray at the bottom right.
Perhaps Microsoft could comment on why setupre.exe needs to broadcast
synchronous messages, seeing as it’s the real cause of this hassle.
"sidprice@.softtools.com" wrote:

> Hello,
> I am having problems with an installation of MSDE. The computer alraedy has
> an instance of MSDE installed with Outlook for the Contact Manager and I
> have no problems with that instance. A new application I have installed also
> uses an instance of MSDE for a database. During the installation of this
> application (Sony Media Manager) the MSDE installation hangs up an dnever
> completes. The only way out is to use task manager.
> Examining the log file it appears to be sqlredis.exe that is hanging. I have
> searched the web and MS knowledge-bases and found nothing that fixes this
> problem. We really need this element of the application to work so that we
> can efficiently access our media database. Any advice on how to proceed
> would be much appreciated.
> Sid.
>
>

MSDE Install Hangs for hours

Our application uses MSDE. On one computer running Windows XP. The MSDE
intstall runs for 4+ hours and never completes.
Here are the last few lines of the msde install file- Any ideas on what
might be happening?
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
NoRebootConnectRepl returned: 3010
MSI (s) (44:F4): Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
MSI (s) (44:F4): Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
Are you launching the installation from code / any other mechanism that is
waiting for setup.exe to terminate.
There is some weird issue in the MSDE install package that causes the
sqlredis action to hang if anything is waiting for the parent process to exit.
I haven't seen a good answer on why that happens.
Hope that helps
- Ross
"dramos" wrote:

> Our application uses MSDE. On one computer running Windows XP. The MSDE
> intstall runs for 4+ hours and never completes.
> Here are the last few lines of the msde install file- Any ideas on what
> might be happening?
> Starting custom action NoRebootReplace
> TempFolder Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\
> Source Dir Property is C:\DOCUME~1\chittoor\LOCALS~1\Temp\SqlSetup\Temp
> NoRebootConnectRepl returned: 3010
> MSI (s) (44:F4): Executing op:
> ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
> Action 20:37:22: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
> MSI (s) (44:F4): Executing op:
> CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
> MSI (s) (44:F4): Creating MSIHANDLE (180) of type 790536 for thread 3572
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\chittoor\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
> /q:a"

MSDE Install Hangs During Install

Please help!
The istall hangs at:
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
The work-around code in the MS white papers is not an option,
What is up?
This effects us a great deal as well. I have to say the whole install
scenario for MSDE 2000 has been incredibly frustrating with many issues that
MS could fix, simply KB articled instead.
You can't depend on users not running applications that occasionally stop
pumping their message queue. This just stops the installer dead.
"A Met" wrote:

> Please help!
> The istall hangs at:
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
> /q:a"
> The work-around code in the MS white papers is not an option,
> What is up?
>
|||We are having and the install hang at the exact same point. Previously in
the thread there was a reference to a knowledge base article. If there is a
workaround could you post a link to that article or white paper please.
Also mentioned is the fact that the other applications can stop the intstall
by their affect on the message queue. Would having the user close all other
programs stop the install from failing in this case?
"jwf" wrote:
[vbcol=seagreen]
> This effects us a great deal as well. I have to say the whole install
> scenario for MSDE 2000 has been incredibly frustrating with many issues that
> MS could fix, simply KB articled instead.
> You can't depend on users not running applications that occasionally stop
> pumping their message queue. This just stops the installer dead.
>
> "A Met" wrote:

MSDE install hangs -- any ideas?

I installed MSDE. Then I changed the name of my machine. Then I uninstalled MSDE, so I could create a new, properly-named instance.

Now, when I try to install, the installer gets about 75% of the way through the "gathering information" stage, and hangs, every time. I have to kill it with Task Manager.

Help! What can I do?

Extra info: I thought maybe the problem was related to Norton AV, so I uninstalled that. While that was uninstalling, the installer announced that there was a "suspended" install of MSDE that needed to be cleared. So I said, yes, clear it. How do I find out if there are other suspended installs in progress?

Thanks...Solved it myself: the partial install left a bunch of junk in the registry related to SQL server. I deleted all of them, then reinstalled successfully.

MSDE hangs on Install

First off, let me say it took me nearly all day to get this working. When you download the sql2decksp3.exe you might think it install like any other program. No. This exe simply unpacks the setup files. The actual setup program, setup.exe must be run from a DOS command prompt... so you've got to look up the correct command line parameters in the sp3reademe.htm file. Something like:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

No problem so far, but then when I go to run the setup.exe with the correct parameters the install goes fine until the last 5 seconds. Then hangs. Again and again. The install program keep getting hung up just before the finish. Each time I had to uninstall and reinstall-- 6 times. When if it hangs you've got to break out with the Task Manager, then do an uninstall from the Control Panel... if... an entry there was created. It usually is.

I tried everything I could think of and then did a search here. There were a few messages. The only one who actually got past this problem said he deleted all references for "Microsoft SQL" in the registry. I tried that too. It didn't work for me. That setup hung in the very same place. Then instead of breaking out and starting again, I tried shutting the machine down, while the setup was hung, thinking that maybe after a restart the installation might continue AND and that point the install completed.

Hope these notes help the next person who runs into the same problem. I also tried putting the modem on standby and disabling Norton anti-virus. Alone that did help, but when I tried all this stuff together... finally at 4:34 PM, I was able to establish a connection, from both VB.NET and with a great FREE MS SQL Manager at http://sqlmanager.net/products/mssql/manager/download

Now I can start. For some reason, the way I think... I can't do any coding until the entire database spec is first set up. Then you write all the add, edit, display and sort form, windows. When designing web applications, you design the database first, then each web form preforms some unique operation or reference on the remote database. I think that's the way it works.

Hey! Hope this helps others.

Paul TownsendSometimes verbose logging can help to pinpoint installation problems:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd" /L*v c:\MSDEInstall.log

Terri