SQL Server Performance Forum – Threads Archive
Couldn’t see the Login Name of dbowner in databaseHi, I couldn’t see the Login Name of dbo ( it should be ‘sa’) in the Users branch of a company database. So, when login to the database, it said that Login failed for user ‘sa’.Please see the attachment for details.
Did you meet this problem ? Love in vain is better than love no one.
Hi,<br />What Authentication Mode you are using ? Windows or Mixed ? What is your SQL Server Version , is it MSDE ?! if yes then you need to set your Authentication mode to Mixed or SQL .<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
It’s Mixed Mode, with the other databases, I could see the name ‘sa’, but with the new databases I have created, couldn’t see, just see ‘dbo’. I’m using SQL Server 2000 Standard Edition, SP3. Love in vain is better than love no one.
You will always see "dbo" as the login corresponding to "sa" in the Users list – that’s just the way it is. If you are getting an error logging on as user "sa", then double-check that you’re entering the correct password for "sa" on this particular instance of SQL Server. Other than that, normally when you’re having problems logging on to a database that has been moved from a different SQL Server instance, you can use sp_change_users_login to sort out the problem with non-matching ID – except that "sa" is the only login that always has the same ID, so that cannot be an issue.
Also you can use SP_CHANGEDBOWNER statement to change the owner of the database.
BTW have you restored this database recently? Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
No, that’s the new database I create.
Love in vain is better than love no one.
Can you check in EM, on the Properties form for the database, on the General tab, who is the Owner? It should say "sa", if not then like Satya suggested run sp_changedbowner (see BOL for details).