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 |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
 Posted - 2004-07-21 : 08:03:38
|
| We changed our domain server from nt4.0 to 2003.Now none of our NT intigrated security will work.AS all my applications us this I have a Big problem!!!!!!Any Ideas???JimUsers <> Logic |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 08:17:59
|
| What errors are you getting? Are you using AD now as well?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-21 : 09:41:45
|
| Yes on AD. errors are user not authorized even though the individual has rights- verified this in EM. Wierd..... Global groups seem to work but not individuals.JimUsers <> Logic |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 09:50:10
|
| Did the SID's change by any chance? Add a new user and let me know if that works. Also, you didn't change the domain designation did you?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-07-21 : 10:00:52
|
| What happens if you backup/restore the DB then reassign the logins?-------Moo. :) |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-21 : 11:44:19
|
| Sids Did not Change.Backup/restore no effect.This was a reinstall of SQL on this server.I Was not able to recover master from backup as soon as it loaded it crashed SQl Server. Had to rebuild Users but it only likes groups.JimUsers <> Logic |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 12:19:18
|
| And did adding a new user work?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-07-21 : 14:57:07
|
| Yes a new user works.I had to take out all the permissions at the table level and reset them. What a chore!!!JimUsers <> Logic |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-21 : 16:44:07
|
| ??? Pretty much the only thing that can cause that is a SID being out of sync. You ran sp_change_users_login 'Report' on each database?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Permissions and 2003 server