Activity overview
Latest activity by lehrsj24
Yes the problem still exists. We are on the version 9. We have two domains and the trusted share is in place. But if the SQL monitor server is on DomainA, I cannot add users from DomanB. My workaround was to get user accounts in both domains. / comments
Yes the problem still exists. We are on the version 9. We have two domains and the trusted share is in place. But if the SQL monitor server is on DomainA, I cannot add users from DomanB. My wor...
The only issue is with Windows authentication. I have two domains, let's say A and B. I have a SQLMonitor server on domain A. I have another one on domain B. The service account used for both of these domains is a single service account from domain A. It works fine in both domain A and domain B as this single service account has rights to the SQL servers in domain A and B. It has all the rights it needs to run and gather the data from SQL Monitor. There are no user rights issues for this.
The problem is that if I set up Windows Authentication then in domain A, when setting it up, I specify a windows account that is going to check AD to determine if other windows users have rights when they log in. In domain A the only account it will allow is a windows account from domain A. And in domain B the only windows account it will use is an account from domain B. This too isn't a problem as I can use a different account for each of the servers. The problem is on the SQL Monitor server on Domain A, I can't add users from Domain B. It says it can't find them. And on the SQL monitor server on domain B it won't allow me to add users from domain A. It can't find them. It appears that it can only authenticate a user in a single domain - even though domain A and domain B have a full trust relationship.
From the way this is working I it appears to me that windows authentication can only validate users in a single domain. / comments
The only issue is with Windows authentication. I have two domains, let's say A and B. I have a SQLMonitor server on domain A. I have another one on domain B. The service account used for both...
SQL Monitor and multiple trusted domains
I've been trying out the Active Directory authentication. In my company we have more than one domain, but they all are trusted. What I am finding that is I have a SQL Monitor server in domain A, ...
Keep getting Timeout expired errors.
We keep getting timeout expired error messages when trying to commit changes or refresh. Sometimes I have to attempt to commit changes 8 or more times before I don't get a timeout error. I am not...
Read-only alert screen
Details from an alert can be called by going to this web page and passing the alert ID.http://servername/Alerts/Details/99999
I'd like to be able to use this web page in a read-only format. Someth...
Monitoring SQL servers from two different domain
Are there any issues with monitoring SQL servers from two different trusted domains? The SQL account is the same for all servers. It appears to work OK but I thought I read something somewhere ab...
Suggestion Clear after ... on alerts
There are certain types of alerts where I want to collect the information but I don't want to have to manually clear them. For example, take a long running query. If I go to the monitor page I wa...
Database list filter / Readonly account suggestion
First I'd like to say that I do like this product.
I know it's been suggested before and I too have need of a read-only type account that doesn't allow changes to the configuration. Perhaps the co...
I'll take a look at the views.
As an example, I have alertID 70009 that is for a SQL server job that failed. On the web page when I click on the alert I see the error message for the failed job:
Job outcome message: The job failed. The Job was invoked by Schedule 13 (Sundays). The last step to run was step 3 (CaptureProject). NOTE: Failed to notify ....
There is a view called data.cluster_sqlserver_agent_job_history_instances_view.
In this view I see ID 906119 that a field for Cluster_SQLServer_Agent_Job_History_Message, which is the error message for this alert. It matches the server from the alert, the time, etc.(actually I started in this view, found an error, and then traced it back to the alert).
If I have the AlertID from the alert.Alert table how can I get to this view for the error message?
Thanks / comments
I'll take a look at the views.
As an example, I have alertID 70009 that is for a SQL server job that failed. On the web page when I click on the alert I see the error message for the failed job:
J...
Data dictionary?
I'd like to do some reports against some of the data in the SQLMonitor database. Is there any type of documentation on how the data all relates? Some of the data is pretty self explanetory but ot...