Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-03 : 07:58:32
|
| charlin writes "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 80040005I 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" |
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-08-01 : 10:47:12
|
| Ive been looking for a solution to this problem for a few days. It seems the question is asked quie often but doesnt seem to be recieving an answer anywhere.Ive used Activeports to check if UDP/ TCP ports 1433 1434 are open and they are.Ive tried using regsvr32 to re-register sqldmo I do not have the opportunity to upgrade the service pack from 3 at this moment in time.Any help would be greatly appreciated. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-08-01 : 11:05:11
|
| Does SQL work when and until the 'x' program is invoked? |
|
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-08-01 : 12:03:19
|
| Yes, SQL is workign and other servers can connect to it (I have the machine running as a secondary log shipping server)I notice that the server cannot retrieve a lost of other servers on the network eg using OSQL /L It appears that any application that tried to retrieve a list of servers terminates too , e.g registering a new server in enterprise manager or when sqlmanger.exe is first displayed. |
|
|
|
mechamonkey
Starting Member
8 Posts |
Posted - 2006-08-04 : 06:38:07
|
| I have solved the error regarding discovery of network servers crashing client applications (http://support.microsoft.com/kb/814064/) by upgrading the MDAC version to 2.8 (http://support.microsoft.com/kb/820761/814064)Following the methods explained at http://support.microsoft.com/kb/301202/ I verified an earlier version was being used.This fix negated the need to upgrade SQL to Service Pack 4 at this time. |
|
|
|
|
|
|
|
|
sql-dmo access violation and sqlmangr icon disappear from sys tray