Activity overview
Latest activity by TheLonelyDBA
thanks for pointing that, Evan! I voted for it, because it is my main request regarding this product.
thanks for all! / comments
thanks for pointing that, Evan! I voted for it, because it is my main request regarding this product.
thanks for all!
Hi Evan. we tried to open the firewall ports but could not get the WMI ports on target servers fixed, so we could not monitor them after all. Also because of secondary domain here, another thing I tried to overcome this was installing a second relay on a different server, but the installation would give me a error about the relay already existing.
Unfortunately our corporate network policies prevent us from using it to monitor all our databases in one single monitoring instance.
if possible, I would like to give the suggestion to allow more than 1 relay to be installed. for corporate networks with such restricted rules it would be great to have a relay for each VLAN/Domain. / comments
Hi Evan. we tried to open the firewall ports but could not get the WMI ports on target servers fixed, so we could not monitor them after all. Also because of secondary domain here, another thing I ...
Hello Evan!
Sorry I rushed you so much, and took this long to post back! for the past 2 days I was busy running your tests and configuring the SQL Monitor Hosted collection. As I believe you can see from my account, IT WORKED! =D
You were correct: we had some permission issues on our side. Our network is higly "firewalled" and we also have 2 distinct domains, without any direct trust relationship.
Because of this issue, I was trying to configure the Relay server using local server accounts, as the monitoring server will not always be able to authenticate on the monitored instance domain. Unfortunately this did not work well - the connection was made, but some pieces of it didn't work. The tests you suggested were key to confirm it.
I had to resort to using my own domain account to do the data collection, and give up on monitoring the servers at the second domain. But for now it is working as expected.
I would just like to ask one question before we close this support request:
- do you know if in the future it would be possible to use Local accounts instead of Domain accounts to do the collection?
thanks, / comments
Hello Evan!
Sorry I rushed you so much, and took this long to post back! for the past 2 days I was busy running your tests and configuring the SQL Monitor Hosted collection. As I believe you can se...
hi Evan! I'm so glad you are back [image]
of course I will run the test you pointed me. and I will update the support request inside the ticketing system (I guess I should have asked for help there, but could not think straight with this registry thing on my head).
again, sorry for rushing you guys so much - but as the beta will go off at the end of this month, I wanted it up and running to showcase to a few co-workers here before that date.
thanks! / comments
hi Evan! I'm so glad you are back
of course I will run the test you pointed me. and I will update the support request inside the ticketing system (I guess I should have asked for help there, but c...
aaaaand same message is happening to another server, again without any cluster services on it. :shock: / comments
aaaaand same message is happening to another server, again without any cluster services on it. :shock:
Evan, could you help me out on another registry entry?
Error: Status: Monitoring stopped (Incorrect credentials or insufficient permissions)
Date: 12 May 2014 5:45 PM
Group: Registry
Event: OpenSubKeyOrNone: \\<my_machine_02>\HKEY_LOCAL_MACHINE\Cluster
Outcome: Incorrect credentials or insufficient permissions
Exception: Win32Exception
Exception message: Access is denied
the problem is: the account used is local administrator, and such "Cluster" key/value does not exist in the registry hive listed. This is a standalone w2008 server that should not have anything labeled "cluster" on it.
ty / comments
Evan, could you help me out on another registry entry?
Error: Status: Monitoring stopped (Incorrect credentials or insufficient permissions)
Date: 12 May 2014 5:45 PM
Group: Registry
Event: OpenSub...
yes, I was referring to the "#fsG" (and any other code too). / comments
yes, I was referring to the "#fsG" (and any other code too).
thanks for your detailed explanation, Evan.
I tried to do a search about the error before posting here, but could not find an index of messages/codes. do you guys have anything like that to help us?
regards, / comments
thanks for your detailed explanation, Evan.
I tried to do a search about the error before posting here, but could not find an index of messages/codes. do you guys have anything like that to help us...
So, back I am.
Unfortunately I was not able to duplicate the conditions that caused the first error ("missing dbo schema"), because I had to configure my SQLMonitor Hosted acct with a different server.
But I am still facing some errors that are preventing the monitoring, and in my understanding they should only generate alerts. This happens when I have a database marked as Read-Only (or a Snapshot) and the login used to collect the data is not given SA rights.
In this scenario, the monitor will try to connect to the unavailable database, fail, and stop monitoring. I believe it should only fail the connection and generate an alert, continuing monitoring the other databases.
"Configuration > Monitored servers > Show Log (for a specific instance)"
Date: 5 May 2014 4:46 PM
Group: SQL
Event: #LVG
Outcome: Incorrect credentials or insufficient permissions
Exception: SqlException
Exception message: The server principal "<my_login>" is not able to access the database "<my_snapshot>" under the current security context.
The only workaround I found was to mark the database as writable, create the monitoring login, and mark it as read-only again - or just drop the snapshot in this case. / comments
So, back I am.
Unfortunately I was not able to duplicate the conditions that caused the first error ("missing dbo schema"), because I had to configure my SQLMonitor Hosted acct with a different ser...
SQL Monitor issues with Windows Registry
Hi. I just opened this topic to register one issue I found while testing SQL Monitor Hosted - and the solution found.
I was having some errors while trying to set up the monitoring on my Windows Se...