Can Io swap an existin sql server with iis running an intranet to another domain

we recently acquired a company that has a 2003 with sql 2008 r2 installed and hosting their intranet. we would like to see what can be done about maintaining the functionality of the server but moving it over to domain. what is the best way to make this happen. the sql servers database is heavily integrated into the intranet. We realize that it is not ideal, but need to make it happen quickly. I understand that their will be permission issues that we will need to work through as it pertains to iis and sql. So, how do we go about it? Any help would be appreciated.
blkstrimAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Imtiaz HashamTechnical Director / IT ConsultantCommented:
Is the server a DC?  If not, please disjoin the server from their domain to your domain, presuming the IIS is on the same server
0
blkstrimAuthor Commented:
It is not a dc. Do I need to prep sql in any fashion before disjoining. How about iis
0
Imtiaz HashamTechnical Director / IT ConsultantCommented:
I would take a full backup of the server (using Windows Backup) and then disjoin to from the old domain (keep a local admin account alive otherwise you will be shafted :)).

Join the server to your domain keeping the server name unchanged.

On SQL server, you will need to enable permissions for your domain users to allow them to access the database
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

blkstrimAuthor Commented:
Got it for the first part of your answer.  What is the easiest way to enable the permissions for the users
0
Imtiaz HashamTechnical Director / IT ConsultantCommented:
Under logins, add DOMAIN\Authenticated Users to allow them permissions to the required Databases
0
Joseph NyaemaIT ConsultantCommented:
As Imtaz Hasham said... change the domain membership.

If SQL is using service accounts in the previous domain, then create new service accounts in the new domain and us the SQL Configuration Manager console to change the service accounts in question.

About the database permissions - really depends on how the web application is using the database.  i.e. could be one account that logs onto the database on behalf of users (proxy account).  Bottom line you need to look at current security settings on the databases and see  if you need to create new accounts.  If the user accounts are based on sql authentication then no changes may be necessary.  If based on ntlm authentication, then you would need to create the accounts in AD and SQL.
0
David ToddSenior DBACommented:
Hi,

Steps
Make a trust between the two domains
In SQL add new logins for your current users that match their accounts in the new domain. Don't forget yourself and the admin group!
Add a SQL authenticated login for you for safety!
Move server into new domain and reboot.
Check that your (new) login and permissions work.

HTH
  David
0
Imtiaz HashamTechnical Director / IT ConsultantCommented:
David, you are right, however, in my opinion, you would need to bring the DC which I believe he doesn't want to do as he wants to move to a his own domain
0
David ToddSenior DBACommented:
HI,

>> bring the DC
Or create a new one for the new domain. Kinda gotta do one or the other as its really difficult to have a domain without a domain controller.

Regards
  David
0
Imtiaz HashamTechnical Director / IT ConsultantCommented:
They have an existing domain, however, these are two options for them to choose from :)
0
blkstrimAuthor Commented:
Thanks guys. This gives me several options in my planning.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.