Error 15401 Windows Nt User Group Not Found
Contents |
360 games PC games error 15401 sql server 2012 Windows games Windows phone games Entertainment All Entertainment
Error 15401 Sql Server 2014
Movies & TV Music Business & Education Business Students & educators
Windows Nt User Or Group '\administrators' Not Found.
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Msg 15401 Sql Server
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All sp_revokelogin Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn q322988 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users microsoft sql server reported sql message 15401 severity 16 Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping sp_grantlogin each other. Join them; it only takes a minute: Sign up Windows NT user or group 'DOMAIN\USER' not found? up vote 4 down vote favorite 2 I am trying to create users on a SQL server from an https://support.microsoft.com/en-us/kb/324321 Active Directory group as an application I am working with does not natively support Windows authentication and relies upon individual logins being created on the SQL server, as application level permissions are managed in the application rather than using SQL roles. Due to this, each user that is to access the application needs their own user creating against the SQL instance that the applications database is on, so that the user can then be assigned individual http://stackoverflow.com/questions/15089617/windows-nt-user-or-group-domain-user-not-found permissions within the application. I am reading the list of users from the Active Directory group we have designated using the following; exec master..xp_logininfo 'domain\groupname', 'members' This returns output similar to the following; account name type privilege mapped login name permission path DOMAIN\USER user user DOMAIN\USER DOMAIN\GROUPNAME For the most part, the users returned in this list can be created on the SQL instance without any drama. I am creating the users as SQL accounts using sp_grantlogin in the first instance, before moving on to allow each new login access to the application database. However, a handful of users are being reported as not existing. I get the following error as a result of running sp_grantlogin; Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49 Windows NT user or group 'DOMAIN\USER' not found. Check the name again. Obviously in the above error message, I have removed the actual username. Why would xp_logininfo return a user that cannot be created with sp_grantlogin? Is there anything obvious that I am missing? sql-server active-directory share|improve this question asked Feb 26 '13 at 12:52 user1451185 support.microsoft.com/kb/324321/en-us –David Brabant Feb 26 '13 at 13:08 the user definitely exists in AD, the potential for the suser_sid being a duplicate is unknown, as select suser_sid('DOMAIN\USER') returns NULL, the domain controller is available (I assume) as I'm able to run
with sys http://www.mikesaysmeh.com/how-to-fix-windows-nt-user-or-group-servernameadministrators-not-found-in-mssql/ admin (sa) server roles? Getting the error below? I have a very simple fix. Windows NT user or group 'COMPUTERNAME\Administrators' not http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=191253 found. Check the name again. (Microsoft SQL Server, Error: 15401) Instead of adding "COMPUTERNAME\Administrators" change it to "BUILTIN\Administrators" and it will sql server work just find. Just erase your computer/server name and replace with BUILTIN. This fix should work for SQL Server 2005, 2008, 2012, and 2014. Filed under: Tech Leave a comment Comments (0) Trackbacks (0) ( subscribe to comments on this post 15401 sql server ) No comments yet. Leave a comment Cancel reply Name (required) Email (required) Website No trackbacks yet. Dell DSET report default password » « How to fix - WordPress Upgrade Download failed. SSL certificate problem: unable to get local issuer certificate Support Meh Blogroll 303 Cyling Culture War GearHost Inc Record Label (Legally Free Music) Team Gluten Free CategoriesCategories Select Category Coding Games Living with the gluten-less curse Regarding Mike Tech Uncategorized Calendar October 2016 M T W T F S S « Aug 12 3456789 10111213141516 17181920212223 24252627282930 31 Underverse Register Log in Entries RSS Comments RSS WordPress.org Copyright © 2016 Mike Says Meh · Powered by WordPress Lightword Theme by Andrei Luca Go to top ↑
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2012 Forums Transact-SQL (2012) Creating a login in the SQL Server instance Reply to Topic Printer Friendly Author Topic rafael.soteldo Starting Member 36 Posts Posted-02/11/2014: 08:59:19 Hi there:I'm trying to develop applications that have the database on one machine and the application interface on other machines over a network.I'm studying WCF to accomplish this.I'm using VS2012, SQL Server Express 2012, and Windows 7 Ultimate x64 with IIS7.In the WCF Documentation are instructions aimed at having Sql Server enable IIS to connect to the SQL Server instance.One of those is: CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS; GO The documentation says that it creates a login in the SQL Server instance for the Windows account used to run IIS. This enables IIS to connect to the SQL Server instance.I tried it in my instance of Sql Server Management Studio 2012 and I receive this error:quote:Msg 15401, Level 16, State 1, Line 1Windows NT user group 'NT AUTHORITY\NETWORK SERVICE' not found. Check the name again.I already installed WCF on Windows and registered aspnet, using the command prompt with Administrator privileges.What could I be doing wrong here?Thanks in advance for your time-------Rafael Soteldo Edited by - rafael.soteldo on 02/11/2014 09:11:48 ahmeds08 Aged Yak Warrior India 737 Posts Posted-02/12/2014: 07:32:27 http://support.microsoft.com/kb/324321/en-usJaveed Ahmed Edited by - ahmeds08 on 02/12/2014 07:35:01 rafael.soteldo Starting Member 36 Posts Posted-02/12/2014: 07:45:18 quote:Originally posted by ahmeds08http://support.microsoft.com/kb/324321/en-usJaveed AhmedHi,Thank you for answering,This page won't open and it tells me that the information is en