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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Troubles with SQL Manager

Author  Topic 

cerbere38
Starting Member

2 Posts

Posted - 2006-03-08 : 10:12:07
I have a problem with SQL MAnager,
My C# application runs on MSDE without problem; access to the Database running without any problem.
It is a Deployed application...

BUT !

the SQL Manager lists still remain empty.
No Server, and no services ???

1 - In the process list I have :
sqlservr.exe, / Processor 1,
sqlservr.exe / Processor 0,
sqlmangr.exe,
monappli.exe,
services.exe,
sqlagent.exe.

2 - On the running Services :

2 times MSSQL$MyInstance State=running Type=automatic
MSSQLADHelper State=stopped Type=Manual


3 - In the registry :
in HKLM\SYSTEM\Current Control Set\Services\SQL Agent$myInstance, I have:
DependOnGroup = empty
DependOnService = MSSQL$MyInstance
DisplayName = SQLAgent$MyInstance
ErrorControl=1
ObjectName = localSystem
Start = 2
Type=10


I don't understand why SQL manager is empty ?
It doesn't reflect the state of SQL Server which is running ? Why ?

I Wrote MyPC\MyInstance by hand on the list of the SQL Manager. It works !
But when stopping the PC and Restarting it, the SQL Manager doesn't care ! the lists are empty again.

My Question is :
How could I be sure that the SQL manager reflect the Server and Instances running whith my application, after having deploy it ?

Thanks for Help !

activecrypt
Posting Yak Master

165 Posts

Posted - 2006-03-08 : 22:04:11
Hi,
is this a system with Windows XP and MSDE ?!
have you try installing lattest Service Pack for SQL Server?

Regards



Andy Davis
Sql Shield Team
--------------------------------------------
SQL Server Encryption Software
http://www.sql-shield.com
Go to Top of Page

cerbere38
Starting Member

2 Posts

Posted - 2006-03-09 : 04:19:23
Yep the system is running under Windows XP and uses MSDE , with the lattest service packs
Go to Top of Page
   

- Advertisement -