SQL Monitor Hosted - missing "dbo" schema

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

SQL Monitor Hosted - missing "dbo" schema

Postby TheLonelyDBA » Mon Mar 17, 2014 10:08 pm

Hello. While evaluating SQL Monitor Hosted, I received this error on the following page:

"Configuration > Monitored servers > Show Log (for a specific instance)"

Date: 17 Mar 2014 5:48 PM
Group: SQL
Event: #zX7
Outcome: Internal SQL Monitor Hosted error
Exception: SqlException
Exception message: The specified schema name "dbo" either does not exist or you do not have permission to use it.

But it does not tell me the affected database name, so I could fix it. Is this message related to some of my DBs or is it an error elsewhere in the Beta?

thanks,
Tips and thoughts on MS SQL, Oracle and MongoDB:
http://thelonelydba.wordpress.com
TheLonelyDBA
 
Posts: 18
Joined: Wed Oct 30, 2013 8:01 pm
Location: Brazil

Postby fionag » Fri Mar 21, 2014 11:58 am

Hi
Can I check - were you able to resolve this error? I just had a look at your SQL Monitor Hosted and I don't see this error now although I notice you're still not up and running.
If you'd like some further help getting things working, please feel free to contact the team directly on sqlmonitorhosted@red-gate.com (this email address is for the hosted product specifically).
Thanks, Fiona
fionag
 
Posts: 32
Joined: Thu Jan 05, 2012 5:40 pm
Location: Red Gate

Postby TheLonelyDBA » Thu Apr 10, 2014 2:56 pm

hi Fiona.

unfortunately I was not able to resolve this yet. I need to assing the minimum possible privilege to the acct that will collect the data, and could not test other options until now.

I believe this error happens when some databases are marked as "offline" on SQL Server. It would be nice to have a report on these, but this should not stop monitoring.

i will test it again and come back to you later.

thanks
Tips and thoughts on MS SQL, Oracle and MongoDB:
http://thelonelydba.wordpress.com
TheLonelyDBA
 
Posts: 18
Joined: Wed Oct 30, 2013 8:01 pm
Location: Brazil

Postby TheLonelyDBA » Mon May 05, 2014 9:07 pm

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.
Tips and thoughts on MS SQL, Oracle and MongoDB:
http://thelonelydba.wordpress.com
TheLonelyDBA
 
Posts: 18
Joined: Wed Oct 30, 2013 8:01 pm
Location: Brazil


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 1 guest