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 2000 Forums
 SQL Server Administration (2000)
 Weird - sql logins changed default db's

Author  Topic 

1sqlover
Yak Posting Veteran

56 Posts

Posted - 2007-08-27 : 10:46:48
I noticed something strange this morning, I came in to run a report and the login would not work. So I checked the login and the default database had been changed. How can this happen?

epoh

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-27 : 10:55:52
Have you applied a hotfix or service pack?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-27 : 11:01:19
anybody else has dbo access to the server and they changed it?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-27 : 22:03:36
It'll happen if the db is recreated.
Go to Top of Page

1sqlover
Yak Posting Veteran

56 Posts

Posted - 2007-08-30 : 10:45:54
No other dbo or admin. no hotfixes. this sql 2000.

epoh
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 00:26:23
Doesn't matter, it happens if user's default db is recreated.
Go to Top of Page
   

- Advertisement -