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.
| Author |
Topic |
|
mrose1120
Starting Member
11 Posts |
 Posted - 2006-08-11 : 01:37:08
|
| Hi all, I had started a thread a few weeks ago about orphaned users on an SQL migrated database and got great responses. First wanted to say thanks to all who responded and I have one other question! The database users are now telling me that there are problems with the DBO account. Is there something that normally happens when I migrate a database with the DBO? If any articles or fixes on this would be well appreciated. Thanks. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-11 : 07:05:16
|
| >>"The database users are now telling me that there are problems with the DBO account."You need to explain what the problem is.CODO ERGO SUM |
 |
|
|
mrose1120
Starting Member
11 Posts |
Posted - 2006-08-11 : 09:44:14
|
| When I go to the users of the database, click on dbo, then click on the "db_owner" role membership, and click properties, the permission button on the next screen is greyed out. But basically in the old server they could do all administrative tasks which the application allowed them. Since migrating, I ran a script to fix the orphaned users, but besides that had done nothing, but they are having trouble changing passwords and things of that nature. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-08-11 : 11:50:10
|
| what you are seeing is normal, ask them if the case is consistent like changing passwords, I tend not to trust users and always try to replicate the scenario as close as possible...the only thing that may be of interest to you is the ownership assignment,check who is the "dbo" on the database, should be sa and not blankuse sp_changedbowner 'sa' to transfer ownership or reassign--------------------keeping it simple... |
|
|
|
|
|
|
|
|
dbo account not working since migration