SQL 2005, non-domain, DBs & SQL monitoring not work
I have 3 SQL 2005 servers (1 in domain, 2 are non-domain). All monitoring works great on the domain member, but for the non-domain servers, only part of the WMI works like CPU, Disk, and Memory; windows service info is also returned. This indicates that the login/security info is working...
However, anything to do with the SQL Server Monitor is non-functioning - no info on the regular counters, no db list is returned.
Note the the non-domain SQL servers have 2 databases that are mirrored, other than that, they are just like the domain SQL Server.
Any ideas on a fix?
However, anything to do with the SQL Server Monitor is non-functioning - no info on the regular counters, no db list is returned.
Note the the non-domain SQL servers have 2 databases that are mirrored, other than that, they are just like the domain SQL Server.
Any ideas on a fix?