NAT and SQL Server and Exchange Server

NAT and SQL Server and Exchange Server
In computer networking, the process of network address translation (NAT, also known as network masquerading, native address translation or IP-masquerading) involves re-writing the source and/or destination addresses of IP packets as they pass through a router or firewall. Most systems using NAT do so in order to enable multiple hosts on a private network to access the Internet using a single public IP address (see gateway).




According to specifications, routers should not act in this way, but many network administrators find NAT a convenient technique and use it widely. Nonetheless, NAT can introduce complications in communication between hosts.


SQL SERVER

SQL stands for Structured Query Language
Sql server is a database server
It’s a server client structure where client query the server for data
It consists of Enterprise manager and query analyser
Enterprise manager is used to manage sql databases

It has two types of databases
  1. System databases
  1. Master database: stores info about all other databases in short METADATA  If it crashes entire sql needs to be rebuilt.
  2. Model
  3. Temp
  4. Ms db
  1. User databases
Any database that you create in Enterprise manager

In windows services, after installation we get service
Mssqlserver
Sql server agent

EXCHANGE SERVER

Exchange server is a mail server used for mailing purpose as well as public folders
Two editions: standard and enterprise

It has system manager (exchange 2003 and exchange 2000)
It’s a frond end server for all internal and external mails coming through
For installing exchange, following needs to be installed
  1. SMTP
  2. NNTP
  3. IIS (Internet information service) mostly used for accessing mails over the web called OWA (outlook web access)
  4. WWW (world wide web)

OWA is a web interface used to access mailbox remotely to read mails as well as send mails.

Microsoft outlook needs to be installed on client machine to access mails through exchange server.

Exchange also stores public folders to store information like NEWS, activities etc.
Which users can access anywhere?

EXCHANGE is usually integrated with active directory and hence it relies on AD for user information.

It relies on two important services
  1. Information store service
  2. System attendant service



No comments:

Post a Comment