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 |
|
bshaw
Starting Member
1 Post |
 Posted - 2005-05-05 : 10:32:40
|
| Currently, my company is running SQL Server 7 on NT 4 (NT authentication). We are preparing for a move to Win2k3, and SQL 2005. As part of the server move, new domains will be created. An example of an existing SQL login via NT 4 is AlphaBetaCompany/bshaw. The new Win2k3 domain and proposed login will be ABC/bshaw. I've queried sp_helprotect, sp_helpuser, sp_helprolemember. Just not sure what to do script-wise with the data. I've also generated a table script (less the table) using EM, and selected Users, Roles and Logins. I've edited the old domain name changing to the new. Just not sure what to execute, and in what order. What I was thinking of doing was establishing a dev NT server with the new domain, restoring the prod db on our dev server, running the modifed script (where I replaced AlphaBetaCompany/bshaw with ABC/bshaw), and see if we can make things work.I can script users, roles permissions. But this domain name change complicates things. Anyone have some advise/scripts for this new sqlteam member. Thanks for taking the time. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-05-06 : 00:00:23
|
| You're upgrading to SQL Server 2005??????????????? Are you sure? When?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-06 : 07:36:46
|
hey keep us posted on the upgrade... --------------------keeping it simple... |
|
|
|
|
|
|
|
|
Scripting question