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