Re: sql icon disappear from sys tray and getting SQL-DMO 80040005 erro

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 11/29/04


Date: Mon, 29 Nov 2004 18:24:31 -0000

Sounds like you might need to reregister SQL-DMO. From a command prompt run
the following and see if that helps

regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Charles Lin" <CharlesLin@discussions.microsoft.com> wrote in message 
news:3DADDD95-F2F3-4068-93DC-E82E98505AE2@microsoft.com...
> hi folks,
>
> I have tried to installed Microsoft SQL Server 2000 Desktop Engine SP3a 
> and
> the full SQL server 2000 on a Win 2000 server with the same result.  This 
> is
> the problem I see...
>
> With SQL installed and server rebooted, initially I see the sqlmangr.exe
> icon in the sys tray.  But when I put my icon on it, it disappears. 
> However,
> sqlserver.exe is still running in the Task Manager and also shows as
> "Started" in the Service Control Panel.
>
> I am looking at this Win 2000 server remotely, through either Terminal
> Service or VNC - both method gave the same result above.
>
> I think there is a problem because I have a third party application that
> invokes SQL-DMO to create database.  Let's call the program x.exe for
> simplicity.  When I execuate x.exe, I get a "SQL-DMO code execution 
> error -
> Access Violation" and code 80040005
>
> I think my inability to invoke x.exe is tied to the sql server manager 
> icon
> disappearing from the sys tray.  In other words, there is something wrong
> with the sql server installation, although sql server installation log 
> does
> not seem to indicate any problem.
>
> your help is greatly appreciated.
>
> thank you,
>
> Charles 


Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot setup SQL Mail on SBS 2003
    ... Microsoft CSS Online Newsgroup Support ... Cannot setup SQL Mail on SBS 2003 ... The account you use to start the SQL Server service must be a domain ...
    (microsoft.public.windows.server.sbs)