Sunday, 2 June 2013

SQL Server Instances

  • Each Installed Copy of SQL Server is called Instance.
  • We can have multiple instances of SQL Server on same Box.
    • Default Instance
    • Named Instances
  • We may need multiple instances because of variety of reasons
    • For two different applications needing diffrent security senarios.
    • For Licencing issues etc.

No comments:

Post a Comment