Fixing the DBO - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Fixing the DBO

Author

Topic

dvaddi
Starting Member

21 Posts

Posted - 2007-12-03 : 15:56:01

Hi,

I have got dbo , in the database security - logins. But I do not find it in the System - Security - Logins. When I try to re-create it throws an error. The server principle - dbo already exists.

I have got all the schemas in the database under dbo.So I cannot drop the dbo from the database.

How can I fix this

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-03 : 16:00:06

There is nothing to fix. dbo is built-in and not something that you create or drop.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-03 : 16:01:39

Or change all schemas to the one you want?

E 12°55'05.25"
N 56°04'39.16"

dvaddi
Starting Member

21 Posts

Posted - 2007-12-03 : 16:05:42

This on SQL 2005. Few days back , the system crashed and we re-built the system. And after that we are unable to run the crystal reports.
And also , I do not see the 'dbo' under the system - security - logins which I am thinking is creating the problem.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-03 : 16:08:45

Post your error rather than telling us what the problem is. You can probably fix this by unorphaning your users/logins.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

dvaddi
Starting Member

21 Posts

Posted - 2007-12-03 : 16:15:29

When I try to create the login 'dbo' it gives the error

The server principal 'dbo' already exists ( Error 15025)

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-03 : 16:16:55

That's not the error that we need. We need to see the error from your reports that is making you think you need to create the dbo account.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

dvaddi
Starting Member

21 Posts

Posted - 2007-12-03 : 16:29:43

Hi Tara,

Thanks for the help. I got that fixed. The owner name under the database files was empty. So , I put the dbo as the owner and that fixed the error.

Thanks once again.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2007-12-03 : 17:17:26

We fixed our DBO. Since then he's much calmer and less aggressive.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources