August 22, 2003 at 9:46 am
Hi
On one sql server running 2000 standard sp3, I have several dozen individual databases, each owned by their respective users. Recently I have been receiving reports from the users that they receive an error (occasionaly) when connecting remotely with EM.
The error they get is "login" is not a valid user in "database".
What is strange is that the database they are receiving the error message about is not the one they are trying to connect to. Their login would appear to be in no way related to that database, so I am not sure what is triggering the error message. This happens for many different users, but the database in the message is always the same.
I have checked to make sure ownership chaining is not enabled for anything on this server. Each login has access to one database as one user account. None of the logins are assigned to any server roles.
In most cases, the user can continue and access their database, but I would like to get rid of this message just the same... Anything that reduces the number of calls I get!
Any thoughts?
Thanks!
Dan B
August 22, 2003 at 10:24 am
Strange, how are they accessing the databases?
Steve Jones
August 22, 2003 at 10:33 am
Hey Steve,
They connect over the Internet using Enterprise Manager, with sql server authentication.
Thanks,
Dan B
August 25, 2003 at 4:07 am
Double checked their default database?
Andy
August 25, 2003 at 9:27 am
Yup... all the login default databases are properly set. Only one goes the the database mentioned in the error message.
I wonder if this could be a result of each login being set to dbo within their respective databases... There was another topic earlier in the month about who dbo should be, but I have not yet implemented any changes on this server.
Thanks,
Dan B
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply