Is SQL Server 2 tier architecture or 3 tier architecture

  • Hi Team,

    Can anybody please let me know Is SQL Server 2 tier architecture or 3 tier architecture ?

    Thank You.

    Regards,
    Raghavender Chavva

  • I would call it just 1 tier application which consists of multiple tiers. 😎

    This question about SQL Server is a bit irrelevant.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • Can be both and/or can be used in N-tier architecture....

    If your client app is accessing SQL Server directly, it can be considered as 2-tier app.

    If your client app is accessing middle-tier such as MTS/COM+ and those middle tier components access SQL Server, it can be 3 tier.

    If you use web browser to access your you web server that in turns accesses SQL Server, it will be 3 tier architecture...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply