Red Gate forums :: View topic - SQL Monitor Hosted - missing "dbo" schema
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

SQL Monitor Hosted - missing "dbo" schema

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
TheLonelyDBA



Joined: 30 Oct 2013
Posts: 18
Location: Brazil

PostPosted: Mon Mar 17, 2014 10:08 pm    Post subject: SQL Monitor Hosted - missing "dbo" schema Reply with quote

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
Back to top
View user's profile Send private message
fionag



Joined: 05 Jan 2012
Posts: 32
Location: Red Gate

PostPosted: Fri Mar 21, 2014 11:58 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
TheLonelyDBA



Joined: 30 Oct 2013
Posts: 18
Location: Brazil

PostPosted: Thu Apr 10, 2014 2:56 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
TheLonelyDBA



Joined: 30 Oct 2013
Posts: 18
Location: Brazil

PostPosted: Mon May 05, 2014 9:07 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group