Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Setup new machine with Windows 7 Ultimate

Posted on 2012-03-10
3
201 Views
Last Modified: 2012-04-09
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?
0
Comment
Question by:chasmx1
3 Comments
 
LVL 7

Accepted Solution

by:
ashutoshsapre earned 500 total points
ID: 37705256
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
 

Author Comment

by:chasmx1
ID: 37705304
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
 
LVL 14

Expert Comment

by:shahzoor
ID: 37706272
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question