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 |
|
ezyeric
Starting Member
2 Posts |
 Posted - 2008-01-22 : 22:57:19
|
| Is there a way to change a logins based on domain users, we just changed domains so all the domain\login logins are not working anymore. Do I have to reapply every security on every database object? There has to be a fix for this, its a common thing.Any help is greatly appreciated, everything i googled applied to SQL Server 2000 and system tables that dont exist in 2005 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-22 : 23:13:53
|
| No, have to create sql logins with new domain accounts. |
 |
|
|
ezyeric
Starting Member
2 Posts |
Posted - 2008-01-22 : 23:46:17
|
| wow that sucks,Well in that case whats the best way to give select access to everything in a database (without using schemas)?? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-23 : 22:50:46
|
| Put user in db_datareader role. |
|
|
|
|
|
|
Domain Change (User Logins Broken)