Hi,
First off, i'm going to give you some background information of what position i'm in to better understand where I am comming from and want to do. I inherited a very small companies network about 9 months ago couple months out of school, so i've slowly been understanding the ins and outs of everything. One of the last things I have gone deep into is our SQL server, which I've never used before now. A couple of months ago, we had a power line go down a couple blocks down and the entire streets power went out for about 6 hours, and when it came back our PDC was corrupted and crashed. I built a new PDC but with a different domain name since the company has been meaning to change it to fit their company name, instead of using the default "workgroup". Anyway, I bring it up and first thing I change over is the application server where the SQL server is installed. I couldn't open any of my applications, which you probably all would have guessed. So my question(s) is/are:
1. Are there any settings I can change to make it look for the new domain instead of the old one to make it work? (how would I do that? the only tool i'm kinda familiar with is enterprise manager, which was just by exploring it)
2. My second question is keeping the same domain name, and computer name as my old PDC, and hooking everything back up to that, would THAT work without changing settings? or minimal settings? I'm VERY hesitant to do this since we really have no budget for IT support, and if I change "domains" it HAS to work since I can't move it back to the old one which is running off a Secondary DC.
I've searched a few threads and found some potential help, but one was for NT server
(Which btw, we are using w2k AS, and want to move to w2k3 eventually, so once we get a new server i'll need to install SQL again, but thats not for a very long time)
and i wasn't sure if that would work with w2k.
Sorry for my run ons and rambling, but I hope you all understand what I was trying to say.
Thanks for any help, it's all appreciated.
First off, i'm going to give you some background information of what position i'm in to better understand where I am comming from and want to do. I inherited a very small companies network about 9 months ago couple months out of school, so i've slowly been understanding the ins and outs of everything. One of the last things I have gone deep into is our SQL server, which I've never used before now. A couple of months ago, we had a power line go down a couple blocks down and the entire streets power went out for about 6 hours, and when it came back our PDC was corrupted and crashed. I built a new PDC but with a different domain name since the company has been meaning to change it to fit their company name, instead of using the default "workgroup". Anyway, I bring it up and first thing I change over is the application server where the SQL server is installed. I couldn't open any of my applications, which you probably all would have guessed. So my question(s) is/are:
1. Are there any settings I can change to make it look for the new domain instead of the old one to make it work? (how would I do that? the only tool i'm kinda familiar with is enterprise manager, which was just by exploring it)
2. My second question is keeping the same domain name, and computer name as my old PDC, and hooking everything back up to that, would THAT work without changing settings? or minimal settings? I'm VERY hesitant to do this since we really have no budget for IT support, and if I change "domains" it HAS to work since I can't move it back to the old one which is running off a Secondary DC.
I've searched a few threads and found some potential help, but one was for NT server
(Which btw, we are using w2k AS, and want to move to w2k3 eventually, so once we get a new server i'll need to install SQL again, but thats not for a very long time)
and i wasn't sure if that would work with w2k.
Sorry for my run ons and rambling, but I hope you all understand what I was trying to say.
Thanks for any help, it's all appreciated.
