Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-3427

puppetlabs-sqlserver can't create multiple sql_sysadmin_accounts

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: mssql
    • Labels:
    • Environment:

      Windows Server 2012

    • Template:
    • Acceptance Criteria:
      • Can install MS SQL Server without error if using an array to specify SQL SA Accounts
      • All accounts specified in the SQL SA Accounts exist and are part of the SA role
    • Epic Link:
    • Story Points:
      2
    • Sprint:
      Windows 2016-07-27, Windows 2016-08-10

      Description

      I'm trying to create a MSSQLSERVER instance with multiple sql_sysadmin_accounts per your module examples and just can't get the syntax working for the module.

      Can you provide a working example please with multiple accounts set up as a sysadmin ?

      I've tried every combination of forward and reverse slashes I can think of, as well as single vs. double quoting each element. What I'm trying to do notionally is:

      {{

      sqlserver_instance

      { 'MSSQLSERVER': features => ['SQLEngine'], source => 'S:/', sql_sysadmin_accounts => [ 'mydomain\user1', 'Administrator', 'mydomain\user2' ], }

      }}

        Attachments

        1. install-beginning.png
          install-beginning.png
          41 kB
        2. install-succeeds.png
          install-succeeds.png
          50 kB
        3. pre-install-no-sql.png
          pre-install-no-sql.png
          87 kB
        4. role-list.png
          role-list.png
          124 kB
        5. services-running.png
          services-running.png
          29 kB
        6. services-running-list.png
          services-running-list.png
          136 kB
        7. user-list.png
          user-list.png
          84 kB
        8. users.png
          users.png
          55 kB

          Issue Links

            Activity

              People

              Assignee:
              moses Moses Mendoza
              Reporter:
              vds Vince Skahan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support