I think it uses DMO to monitor and manage the SQL components.

There was some form of ODBC logon failure referencing the Cluster Service ID.

KlK, MCSE

Solved it, somehow my account was locked out. Interestingly I could logon on to my machine, (probably cached account) and VPN in. But could not see any LAN...

I'm suddenly getting the cannot generate SSPI context. This is from an XP workstation, with SQL2K Dev, SP2+MS02-061. Connecting to any external server 2k or 7.

MSKB references a NTLM...

Thanks, but I really did it to myself. What bugs the H outa me is we are a big DB2/UDB shop. And we have just made a couple...

Well I have an SP I am running on most servers, then replicate the results back.

Not quite ready for prime time though, and thanks to the WORM I'm kind...

Well I'll take the lazy hit, but we really have just begun installing SQL2k.

I had verified that 1434 was blocked, but we think that it back doored through...

Look for MS02-061 there is an updated version that is a rollup of all prior and is in installer format so it's easy to fix.

Supposedly McAfee has a way to...

I usually script the SPs, then use Query analyzer to apply them to the new server. You also may need to export or apply the grants.

KlK, MCSE

Event Viewer will show the last reboot.

You can also use Uptime in the resource kit.

SQL Logs will tell you when SQL Server was last started, as opposed to the server.

KlK,...

Andy I did find the switch, seems to be working now.

Thanks

KlK, MCSE

Thanks Andy, but where is this switch I poked around and couldn't find it.

For this app it probably would be a major issue.

This is for a DB history tool I...

Try granting the userid in question Read on Master (it might need msdb as well).

I have found Query Analyzer will not work unless they can read master.

KlK, MCSE

I have many published dbs running Simple recovery and I haven't noticed any problems.

KlK, MCSE

I do something similiar in reverse using transaction replication an find it fairly straight forward. I have about 15 servers replicating data to a central site.

I use...

Well I have been developing something more on a historical information store.

I have several SPs that run at each server collecting, DBInfo - size, inuse ..., TBInfo number of rows...