locked
Creating an account to access multiple instances RRS feed

  • Question

  • Hi,

    How do I create a SQL Server login that is allowed to access multiple instances? Can this be done using Windows authentication only or both Windows and SQL Server login? Examples or references would be appreciated.

    Thanks

    • Moved by Kalman Toth Monday, May 19, 2014 11:48 PM Not database design
    Monday, May 19, 2014 9:44 AM

Answers

  • A Login cannot have access to multiple instances, Windows OR SQL

    You need to create same login on each SQL Server Instance for which access is required.

    If possible, go with Windows Login as you do not need to manage password/policy separately.

    for example, to grant DOMAIN\VGajjar access to SQL01 and SQL02:

    1. Create Login on SQL01 for DOMAIN\VGajjar

    2. Create Login on SQL02 for DOMAIN\VGajjar


    - Vishal

    SqlAndMe.com

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 10:06 AM
    • Marked as answer by imiah Tuesday, May 20, 2014 11:35 AM
    Monday, May 19, 2014 9:59 AM
  • Hello,

    Every SQL Server instance do have it's onw user and security Management, so you have to create the Windows or SQL Login on every Server & grant permissions to the databases separatly.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 10:06 AM
    • Marked as answer by imiah Tuesday, May 20, 2014 11:35 AM
    Monday, May 19, 2014 10:00 AM

All replies

  • A Login cannot have access to multiple instances, Windows OR SQL

    You need to create same login on each SQL Server Instance for which access is required.

    If possible, go with Windows Login as you do not need to manage password/policy separately.

    for example, to grant DOMAIN\VGajjar access to SQL01 and SQL02:

    1. Create Login on SQL01 for DOMAIN\VGajjar

    2. Create Login on SQL02 for DOMAIN\VGajjar


    - Vishal

    SqlAndMe.com

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 10:06 AM
    • Marked as answer by imiah Tuesday, May 20, 2014 11:35 AM
    Monday, May 19, 2014 9:59 AM
  • Hello,

    Every SQL Server instance do have it's onw user and security Management, so you have to create the Windows or SQL Login on every Server & grant permissions to the databases separatly.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Shanky_621MVP Monday, May 19, 2014 10:06 AM
    • Marked as answer by imiah Tuesday, May 20, 2014 11:35 AM
    Monday, May 19, 2014 10:00 AM