Re: Should I place a Domain controller in each of the 40 stores?

Hi
Please see inline.
- What will happen to the login times on the POS terminal when a store
wan links goes down? I can not have the POS terminal down for a few
minutes in case it need to reboot during such a situation.

Assuming that your domain allows cached credentials, after the first successfull login the same user should be able to login any time that he/she wants, but as I said you must have at least one successful login. The problem may arise if the App needs to force the contact with the DC to validations.

- Will the POS terminal in the store be able to connect to that stores
SQL server will the Wan link to the store is down?

They should be able to do that, one common way is to use a SQL account in an mixed SQL authentication enviroment where the Apps use a dedicated local SQL account to connect to the DB, but again the app may work differently.

- Would it be safer to add the domain controllers role to all store SQL
servers?

If you're referring to have a local DC to each location, then you can garantee that you always have a local DC to process the logans, but... if that Server fails as well? In situations where it's critical to have apps running that depend on other servers like SQL, you should also consider redundancy for those servers. It's a matter of down time vs money lost on that down time vs investment on that server redundancy. Also note that although it is possible, it's NOT recommended to cluster for example a SQL server that is also a DC.

- How much administrative overhead will such a setup create for the
sysadmin?
That will depend the requirements.

- How much traffic will this add the the wan links?
That may depend of the daily changes on the DCs and the SQLs, assuming that the SQL DBs will also replicate with each others in arround all stores.

--
I hope that the information above helps you.
Have a Nice day.

Jorge Silva
MCSE, MVP Directory Services

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"ericvaningen" <ericvaningen.3lx03b@xxxxxxxxxxxxx> wrote in message news:ericvaningen.3lx03b@xxxxxxxxxxxxxxxx

am having doubts on how to architect a complete new AD structure for the
place I am working at.
We have a large number of stores that currently are not part of any
Domain.
We plan to place a SQL server in each store as part of a new POS
implementation and also migrate to XP Embedded for the POS terminals.

Now the questions arises, how to tie all POS terminals, SQl servers
into a new domain.
Currently we do not have Domain at our corporate office so we like to
create the following:

- 1 Root forrest with 2 domains: Corp_domain and Store_domain.
- Redunt Domain controllers at Corp. office
- in each of the 5 cities that we have stores in: Add domain controller
role to the SQL Server in the main store. This will function as the
nearest domain controller for the stores in that city.

Situation:
- 40 stores in 5 cities
- About 20 POS terminals per store
- 400 Corporate users
- Windows 2003 R2 servers, SQL 2005, XP embedded
- 384K Wan Links, E1 link to each Regional Office. Each week we have
several outages that can last from minutes to several hours

Questions:
- What will happen to the login times on the POS terminal when a store
wan links goes down? I can not have the POS terminal down for a few
minutes in case it need to reboot during such a situation.
- Will the POS terminal in the store be able to connect to that stores
SQL server will the Wan link to the store is down?

- Would it be safer to add the domain controllers role to all store SQL
servers?
- How much administrative overhead will such a setup create for the
sysadmin?
- How much traffic will this add the the wan links?

I appreaciate anyone who can give me information on these questions or
can point me to any improvements.


--
ericvaningen
------------------------------------------------------------------------
ericvaningen's Profile: http://forums.techarena.in/members/ericvaningen.htm
View this thread: http://forums.techarena.in/active-directory/1102464.htm

http://forums.techarena.in


.

Relevant Pages

  • Re: Should I place a Domain controller in each of the 40 stores?
    ... I would suggest to get in contact with the vendor of your store application how to handle this about 40 shops. ... We plan to place a SQL server in each store as part of a new POS ... implementation and also migrate to XP Embedded for the POS terminals. ... 384K Wan Links, E1 link to each Regional Office. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Should I place a Domain controller in each of the 40 stores?
    ... If applicable they could solve the problem, but I was referring to local SQL accounts, not local machine accounts. ... Some apps have an inital Admin that is actually an account that is created during the setup for a particular DB in a SQL server, then that account has permissions to create additional ones with specific security settings through a GUI. ... reduced drastically as the store resources are very static (as compared ... If I were you I would be more concern about SQL replication traffic, not sure how big your AD would be, but with 2003 you've LVR available as long as your Forest Functional Level is at 2003. ...
    (microsoft.public.windows.server.active_directory)
  • Re: what is the best way to store this data
    ... That's how an RDBMS would like to store them. ... Columnist, SQL Server Professional ... long lGroupIndex - id's which data group the row belongs too ...
    (microsoft.public.sqlserver.server)
  • Re: How to store HTML code in SQL server table
    ... What is the code you use to store the string you get in the SQL database? ... > Are there any conversion functions or something like this to avoid it? ... > this conversion should be done - in ASP.Net or SQL server? ...
    (microsoft.public.sqlserver.server)
  • Re: How to store HTML code in SQL server table
    ... What is the code you use to store the string you get in the SQL database? ... > Are there any conversion functions or something like this to avoid it? ... > this conversion should be done - in ASP.Net or SQL server? ...
    (microsoft.public.sqlserver.programming)
Quantcast