Setup new machine with Windows 7 Ultimate

I'm setting up a new laptop which includes installing Windows 7 Ultimate, Visual Studio 2010 Pro with SQL and Office 2010.  The machine will be connected to the office domain sometimes but not always.   I plan on keeping databases on the local machine while in the development stage and then migrating them to one of our servers when we go into production.  I'll also be running the Office 2010 Suite including Outlook which needs to connect to our Exchange Server for email, contacts, etc.

I’m concerned about permissions particularly for SQL Server and Outlook when I'm not connected to the domain.  Is it better to setup an machine account on the domain and then install all the software or should I install all the software under a local machine account and then attach the machine to the domain?
chasmx1Asked:
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.

ashutoshsapreCommented:
It does not matter if you install the softwares before or after joining the computer to the domain. Advantages of using the computer on domain are that the outlook configures automatically for the domain account. SQL can use a service account created on domain.  If not joined to the domain you will have to use the local account and configure the email on outlook manually. You can create a local account for SQL in case you would use this laptop while not connected to the domain. You can migrate the database irrespective of weather the computer is joined to the domain or not.
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
chasmx1Author Commented:
I've had problems before not being able to access certain features on SQL Mangement Studio after connecting to the database. Is it better to have the DB owner be a local account or a domain account?  What about the management of the SQL instance?

Thanks
0
shahzoorCommented:
i guess if you will use a DB owner domain account then you will face problems when you are not connected to the domain
There are multiple instance tools available
use any of those
http://www.valesoftware.com/products-sql-multiple-instance-manager.php
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
Windows Server 2003

From novice to tech pro — start learning today.