still the same error about data access

osql -E -D WhatsUp -Q "sp_helpserver" -o C:\servers.txt

 name                                                                         
                                                   
 network_name                  
 status                                                                
                               id  
 collation_name                                                        
                                                          
 connect_timeout query_timeout
 ------------------------------------------------------------------------------
 --------------------------------------------------
 ------------------------------
 -----------------------------------------------------------------------
 ----------------------------- ----
 -----------------------------------------------------------------------
 ---------------------------------------------------------
 --------------- -------------
 NDWHATSUP\WHATSUP                                                            
                                                   
 NDWHATSUP\WHATSUP             
 rpc,rpc out,use remote collation                                      
                               2   
 NULL                                                                  
                                                          
               0             0
 WhatsUp                                                                      
                                                   
 WhatsUp                       
 rpc,rpc out,data access,use remote collation                          
                               1   
 NULL                                                                  
                                                          
               0             0

if i add a new device it ends up NOT being pingable. the default Active Monitor of "ping" is NOT added to the device (probably for the same reason i can not add new active monitors to existing devices)

so now not only can i edit current devices, i've found i can't even add new ones properly if i want to.

please continue helping if you can

for all those involved still with the exact error i had it's not that hard of an overall fix. basically it is a reinstall of sql server 2005 ONLY, i feared having to reinstall wug so i had refused originally in this thread, and thankfully i didnt have to. all my settings and scripts and everything were restorable from teh database as well as what was installed with wug itself.

if anyone is having this problem, i can start by telling you to download:

http://www.microsoft.com/express/sql/download/default.aspx If it prompts you to register, just skip it. You are looking for "SQL Server 2005 Express Edition with Advanced Services SP2 " its 234 MB (on the right hand side)

I'd be glad to help you all out, as im sure ambar would now that he knows the quickest path to the solution as we had

EDIT: make sure you backup your WUG database from within WUG before you uninstall the SQL Server that came with WUG and install the version dowloaded here