none
Create login for group of windows

    General discussion

  • On each windows, system defaults Users group. I want to create a login for Users group. I tried but SQL denied and show error

    "

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

     

    Create failed for Login '[SeverName]\Users'.  (Microsoft.SqlServer.Smo)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.6020.0+((SQL11_PCU_Main).151020-1526+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

     

    ------------------------------

    ADDITIONAL INFORMATION:

     

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

     

    ------------------------------

     

    Windows NT user or group '[SeverName]\Users' not found. Check the name again. (Microsoft SQL Server, Error: 15401)

     

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6248&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

     

    ------------------------------

    BUTTONS:

     

    OK

    ------------------------------

    "

    Please help me to resolve.

    Thanks

    Friday, December 16, 2016 5:38 PM

All replies

  • Windows NT user or group '[SeverName]\Users' not found. Check the name again


    And you are sure you entered (or selected?) the right Windows domain group; but the error message it seems not?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, December 16, 2016 6:26 PM
  • I just created a group. the TSQL command should be

    USE [master]
    GO
    CREATE LOGIN [PUBLISHER\Users] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
    GO

    Where publisher is the name of my server.

    Did you try SeverName\Users? When you browse for the users windows group you need to select the object type groups, then type users and click the check name button to validate it.

    Friday, December 16, 2016 7:27 PM
  • Yes. I am sure. Because I choose from browser 
    Saturday, December 17, 2016 4:06 AM
  • Yes, I did. But I can not do like you.

    I just tried but don't work

    Saturday, December 17, 2016 4:07 AM
  • List all account in Users group:

    - Ai Le

    - NT Authority\Authenticated Users (S-1-5-11)

    - NT Authority\Interactive (S-1-5-4)

    - Philix

    The detailed message

    ===================================

    Create failed for Login 'PHILIX09\Users'.  (Microsoft.SqlServer.Smo)

    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.6020.0+((SQL11_PCU_Main).151020-1526+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
       at Microsoft.SqlServer.Management.SqlManagerUI.CreateLoginData.LoginPrototype.ApplyGeneralChanges(Server server)
       at Microsoft.SqlServer.Management.SqlManagerUI.CreateLogin.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)
       at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
       at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
       at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
       at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

    ===================================

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
       at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImplFinish(StringCollection createQuery, ScriptingPreferences sp)
       at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()

    ===================================

    Windows NT user or group 'PHILIX09\Users' not found. Check the name again. (.Net SqlClient Data Provider)

    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6248&EvtSrc=MSSQLServer&EvtID=15401&LinkId=20476

    ------------------------------
    Server Name: PHILIX09
    Error Number: 15401
    Severity: 16
    State: 1
    Line Number: 1


    ------------------------------
    Program Location:

       at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
       at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)


    Saturday, December 17, 2016 4:24 AM
  • I suspect you are running Windows 10.  What edition are you running? Home?

    Saturday, December 17, 2016 1:35 PM
  • That is Windows server 2012 r2
    Monday, December 19, 2016 8:09 AM