SQL Server Error - No Object was found with the name
-
I've been getting aa rather odd message from SQL When assign the owner of a SQL Job that is specific to one SQL Login. For reasons of security I've changed the Login name.
The SQL Login is MYDOMAIN\wam_bam
When clicking on the button to the right of the Owern field on a Job screen, a list of SQL Logins comes up and when i select this Login from the list and click OK I get the error message:
No Object was found with the name "[MYDOMAIN\wam_bam]", but objects with names containing "[MYDOMAIN\wam_bam]" were found. Select one or more names from the list or click Cancel to re-enter the name.
The list of SQL Loghins shown includes the MYDOMAIN\wam_Bam login and when I select it this time it takes and the world is at peace.
Any ideas? is this just normal?
Kindest Regards,
Just say No to Facebook! -
Is wham_bam a windows group by any chance !
You need a windows user account to be job owner.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
ALZDBA (10/7/2009)
Is wham_bam a windows group by any chance !You need a windows user account to be job owner.
No, the wam_bam (thank you mam) account is a service account on the domain that we use for various tasks.
Kindest Regards,
Just say No to Facebook! -
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !
And the user may have that schema name as default schema, hence it will not find dbo-objects when using unqualified objects in queries.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
ALZDBA (10/12/2009)
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !And the user may have that schema name as default schema, hence it will not find dbo-objects when using unqualified objects in queries.
Thanks for the suggestion and while I felt certain you were on to something since I am still finding and cleaning up things in some of the DB's like rogue or not used schemas, after checking I found that this SQL Login is connected to only 1 DB on the server and it is the DBo for that DB and that DB has no user schema , just the standard ones in a DB.
Any other suggestions or thoughts?
BTW, this wouldn't have anything to do with the SQL Login being connested to a Windows Account would it?
Thanks again
Kindest Regards,
Just say No to Facebook! -
Strange indeed if that user is the actual db owner!
Did you doublecheck the default schema ?
I would try the primitive way and script the full database (with all users and objects) and try to go from there on.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply