Oct 23, 2007

Fix login and user issues after moving SQL Server database

Unbelievably, this happens all the time after I restored the databases on the different server,
even I used the suggestion from http://support.microsoft.com/kb/246133.

I think I'd better put somewhere for the late on usage. Here it is.

1. Check the properties of login sa.
If find your database is not mapped to sa, run the following command in Query Window.

use [your DB Name]
go
exec sp_changedbowner 'sa'

go

2. Check other users under your database.
Run the following command, you'll see the users need to be fix.

use [your DB Name]
go

exec sp_change_users_login 'Report'

go

3. Fix users listed above.

use [your DB Name]
go

exec sp_change_users_login 'Auto_Fix','yourDBUser'
go

Oct 12, 2007

Oracle bids $6.66B for BEA Systems

 
Oracle is opening its mouth again.
 
Check this Oracle bids $6.66B for BEA Systems  in Star web site.
 
Who is going to be the next?