.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

"NT Authority\SYSTEM" is member of Windows Administrators group? How to check it?

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :Sql Server
I have workgroup Windows XP Pro SP3 with SQL Server 2008 R2 I have read the answer of Satya SKJ in Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005 topic in this forum (*): "Local System account. The name of this account is NT AUTHORITY\System. It is a powerful account that has unrestricted access to all local system resources. It is a member of the Windows Administrators group on the local computer, and is therefore a member of the SQL Server sysadmin fixed server role" Why do not I see "NT Authority\SYSTEM" as a member of Administrators group in my computer (compmgmt.msc ---> System Tools --< Local Users and Groups --> Groups --> administrators)? I see there only  Administrator. How to check and manage the membership of "NT Authority\SYSTEM" (as well as of "NT Authority\Network Service" and "NT Authority\Local Service") in Windows? (*) Update: Now, I found the same phrase it in MS SQL Server 2008 R2 BOL [1] Cited: http://msdn.microsoft.com/en-us/library/ms191543.aspx Selecting an Account for the SQL Server Agent Service (SQL Server 2008 R2)   

View Complete Post

More Related Resource Links

CAML query to check if user is member of a specific group


I've got a nested query caml which basically should check 3 things:

  1. Check if a task has been assigned directly to the ucrrent user
  2. Check if a task has been assigned to a group the user is in
  3. Check if the user is member of a specific

The first to bullet points work like a charm, but I can't figure out how to get the last one to work. Here is what I thought should work:

query += "<Where>";
query += "<Eq><Membership Type=\"CurrentUserGroups\">";
query += "<Value Type=\"String\">Name of my specific group</Value>";
query += "</Membership></Eq>";
query += "</Where>";

Somehow it doesn't seem to be the correct approach, is there somebody who can help me out on this? Thanks

check if user belongs to a windows group C#

Hello Guys, I have eneed to check if the current windows user is part of a specific windows group say corp\BO. I tried using isinRole but it returns false no matter what.
WindowsPrincipal wp = new WindowsPrincipal(WindowsIdentity.GetCurrent()); 
bool result = wp.IsInRole(@"corp\BO_ops"); 
is there another way of doing this? pls let me know.  I'm stuck with this and could not proceed.

Check If Member of Group in AD




I am using Active Directory authentication for my website and after the user has logged in, they choose division (which is an AD group) and I want to check against that combo box (depend on what they choose) if they have access to that group. Can someone please give me some C# code on how I do this? I googled and I can't find what I am looking for. So if they click on an option in the combo box, that combo box will do postback, and tell them if they have access or not. If they dont' access, the pop up appears again till they choose one where they have access.



How to check effective permissions for a user or group for a SQL server object or whole server?

Guys, How do I see effective permissions for a user or group for a SQL server object or whole server? For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through membership in other groups) Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins… Anyway, what is the right way to see effective permissions for a user or group? Sorry for asking such a simple question, I’ve searched but found nothing relevant.

group member detail view

hi, i have add member group to my detail view. but it does not show the member group correclty. it shows a lot duplicated members. and members that are not in a group it shows that they are in the group. i know you can not modify the wss_conten database. how can i still use group member in dataview?

check user exists in which group

After entering user name, i want check user belonging to which group, group is some thing like role based if group is something group1 , then i want redirect hime to page 1, if groupis 2  then page 2 like that

How to check if a Control partially or completely obscured by other windows

In  http://social.msdn.microsoft.com/Forums/en-US/netfxbcl/thread/78289886-f3c1-405b-aaa1-722a23690245 is described how to test if a Window is obscured by other windows. Is there a way to do this wit a single control ?  Using the  GetOverlappedIntersection from the example dosent work. ? I'am not very good in Win32... but Controls implement IWin32Window also - Wht is the difference to Forms ? Thank you

NLB over windows server 2003 Cluster on the same machine group

Hi Guys, I should install MS SQL 2005 cluster on windows server 2003. There will be 2 servers in the group. Meanwhile i should set up load balancing for web application again there will be 2 servers in the group. My question is the following, as the load of the servers aren't high is it acceptable to setup load balancing and clustering service onto same windows server 2003 machines group. i.e. the same 2 servers will be a member of Load Balancing and MS SQL Clustering groups?   pls advise. thx

Sharepoint 2010 WorkFlow Task AssignedTo Windows Group doesnt send email notification

Hi, Which configuration would prevent sharepoint to send a notification when a workFlow task is assigned to a Windows Group with an email ? The same task with a single User send a notification. Thanks, Patrice      

Programatically determine windows security group name SQLServer2005MSSQLUser

When SQL Server 2005 is installed it creates a local group following this convention   SQLServer2005MSSQLUser$<computername>$<instancename>   When the machine is renamed the group name does not change.   Is there a way to programatically (.NET 2.0 or SQL query) determine the group name?May we all make money in the sequel.

How to add windows forms to wpf while the allow transparency check box is checked?

I already Know how to add System.Windows.Forms controls inside a wpf. but recently i was working on my own window(custom window i made) and i wanted to add a winows.forms controll. well it did add it and worked with out exceptions but it was no where to bee seen.  if u have time check this out and pls help out a dog here. thanks . ICE COOL!

SQL 2005: Error 15401 - Windows NT user or **group** not found


I have a fresh install of Windows Server 2008 R2 x64 Standard Edition and SQL Server 2005 x64 on top of that, with Service Pack 3. This server, SERV, is in DOMAINA which trusts (one-way) DOMAINB.

When I try to create a login for a group in my domain, I get the following error:
Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49
Windows NT user or group 'DOMAINA\groupname' not found. Check the name again.

I get the same error whether using "create login [domaina\groupname] from widnows", "sp_grantlogin [domaina\groupname]" or Manangement Studio.
This happens ONLY for groups , both in DOMAINA and DOMAINB domains. I can add individual users from both A and B and local computer. For local computer groups: I can add default Windows groups (like Users, Guests, Event Log Readers) by [BUILTIN\Event Log Readers], etc. but not by SERV\Event Log Readers; for custom created group MyLocal it's the other way around: I can via SERV\MyLocal but not via BUILTIN\MyLocal.

If I add a domain group from either DOMAINA or DOMAINB to a local group, whether my own or builtin, I can login to SQL Server remotely using creditentials of a user who belongs to that group (user DOMAINB\ux belongs to DOMAINB\group and DOMAINB\group to SERV\MyLocal). After sp_grantlogin [serv\mylocal] of cours

How to check user is a particular group


How to check user is related to a particular group , if he is assigned to multiple groups

Error 15404 - Could not obtain information about Windows NT group/user 'Dev\Administrator', error


SQL Server 2008 R2 with the latest CU floods event log with "An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'Dev\Administrator', error code 0x54b".

Domain controller is located on the same server (Win 2008 R2), this is SharePoint virtual machine. There are no DNS or Directory Service errors.

How can I troubleshoot this?


how to check if it is Windows Internal Database or sql express


I forgot if I install it as internal database or sperately installed sql express, mostly like I used the default, but I would like to confirm, is there any way to tell if it is internal database, I heard if it is, then there is no database 4GB limit, also please confirm the limit if you know. thanks

sql 2008 installation question, windows installer version check?


sql 2008 installed, but didn't get pop up for windows installer 4.5, though intallation complete, but still wants to confirm the windows installer version, however, the windows 2008 seems not like w2k3 to show all windows components you installed, I only see .net 3.5sp1 on the appwiz.cpl

site member group can only open read-only version of the document


Hi there,

According to this video:
more than 1 person can open a word document and edit it at the same time.

When I test it, it doesn't work.
I can open it fine but my colleague can only open a read-only version.
We're both using Office 2010.
I found out that I'm part of OWNER group, while the other guy is just a MEMBER group.

I've checked the permission for MEMBER, it has "contribute" permission, which allow him to edit document library:
<label for="idspnidEditListItems">Edit Items  -  Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries. </label>

If I add him to OWNER group, he can work on it like the one on the video (link above).
Or, I can add individual user and assign DESIGNER role to it.

My question is: why he has to be in the OWNER group (or DESIGNER role)?
since we have many people working on the document but only 1 person to be included in the OWNER group, it's not a good idea to add everyone to OWNER

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend