Login Name found as disable and blank?????

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)

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2007-11-23 : 01:43:30

Hi,

I have few queries regarding restoriing of database..

I have database back up .bak file..I successfully restored this database back up...but when i try to connect this db to my application I am unable to connect it...

when i look into property of this DB then i found two things that please i need to clear
first thing is in DB Property

Space Available is 0.00 MB

second thing is
when i go to DB>> Security >> Users >> dbo right click property

I found :
User Name dbo
Login Name as disable and blank

But same thing i checked with other DB then
I found :
User Name dbo
Login Name sa

wheather that cause my application failed to connect???????

T.I.A

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2007-11-23 : 03:22:22

When restoring a backup, the users are not taken across, use:


sp_change_users_login 'auto_fix', '<loginname>'

to fix them.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-24 : 00:56:44

May need 'sp_changedbowner sa' in this case.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources