October 7, 2009 at 11:28 am
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!October 7, 2009 at 11:54 am
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
October 7, 2009 at 12:36 pm
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!October 12, 2009 at 1:04 am
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
October 19, 2009 at 10:54 am
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!October 19, 2009 at 12:02 pm
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