SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Job Ownership: No object was found with the name "[sa]"....


Job Ownership: No object was found with the name "[sa]"....

Author
Message
Stamey
Stamey
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2277 Visits: 1073
When I create a job it typically creates the job with my account as the owner, e.g. domain\login. The jobs fail regularly because SQL Server is unable to determine if my login ID has server access. This is stupid, and another typical problem I have run into for years. Anyway, since this occurs often, when I create a job I change the owner to SA so that SQL Server will run it without complaint. I have noticed lately though, that if I change this in SQL 2008, and select "sa" from the list of users, I get the message "No object was found with the name "[sa]", but objects with names containing "[sa]" were found. Select one or more names from this list of click Cancel to re-enter the name."

It presents a list of users, of which none contain the string "[sa]", except, low and behold, "[sa]". See attached image.

This seems to be the dumbest thing I have ever seen SQL Server do.

Anyone else ever run into this?

Thanks,
Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Attachments
SQLError.JPG (37 views, 30.00 KB)
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)SSC Guru (164K reputation)

Group: General Forum Members
Points: 164198 Visits: 33200
That is odd behavior. Have you disabled or modified the SA account in some way?

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Steve Jones
Steve Jones
SSC Guru
SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)

Group: Administrators
Points: 250738 Visits: 19814
Could someone have renamed "sa" with a character in there? Something unprintable.

If not, can you pick this "sa" and will it work? Can you enter [sa] in the box?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
P Jones
P Jones
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4779 Visits: 1534
I can get this in SQLServer 2005 (with various different servers) if I go to a job in my Management Studio (version 9.00.4035.00), right click and select properties and click the ... box for Owner. Type sa in the object names to select and click OK. Gives message as above and list of so-called matching objects to select from - none match except sa of course!
Selecting Check Names gives the same result but I note that the result set for these two is limited to sys admins whilst selecting Browse button gives every user. This makes me wonder if it is also filtering on server role (sySAdmin) as well as name - I don't have any procesSAdmins.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)

Group: Administrators
Points: 250738 Visits: 19814
Very strange. I think that someone has messed with the SA account somehow. I haven't seen this reported anywhere.

You could do one of two things. Either you can create another account and set credentials there, use it only for this.

Or call MS.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Stamey
Stamey
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2277 Visits: 1073
I am not aware of any changes to the SA account. The standard for it here is assign it a 50+ character complex PW and forget about it. No one actually logs in with it unless there is an emergency.

Thanks,
Chris

Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Ron Perron
Ron Perron
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 23
The same issue surfaced in my environment with SQL 2008 after restoring a database taken from SQL 2000. I already tried the ALTER USER WITH LOGIN command to attempt ro repair the suspect orphaned user but this did nothing to eliminate this problem. I'm not sure though if I have the correct syntax. Soory ot a DBA. Incidentally, this dilemma happens with every user I try to change Job Owners not just 'sa'.

Anyone figure this one out yet?
Ron Perron
Ron Perron
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 23
Looks as though the SQL User Interface is messed up. I opened a Support Case with Microsoft. They confirmed a coding problem and subsequently filed two Bugs for UI changes in the Select Login dialog box.

In short, this appears to be normal behaviour....for now...;-)
bill.glidden
bill.glidden
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 1
I am running into the same issue on a login other than "sa". After I'm told it's not found, I am then presented a list of objects containing the userid, and can select the one I want. Strange. I'm glad that Microsoft is working on it now.
Andreas Kreuzberg
Andreas Kreuzberg
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1852 Visits: 1117
Hi,

the previous post was from 2012. Are you sure, you have the same error, an Microsoft will fix it soon?

Kind regards,

Andreas
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search