.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

Hoew to block a Window account with administrator privilege ??

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
I want to block any Window users with admin privilege to login to SQL Server database. even though these users don't have the login accounts in SQL Servers, they still can login the SQLServers database.

View Complete Post

More Related Resource Links

Least Privilege: Teach Your Apps To Play Nicely With Windows Vista User Account Control


User Account Control in Windows Vista keeps the OS safe from intentional and accidental configuration changes.

Chris Corio

MSDN Magazine January 2007

Changing Windows Administrator account name

I am planning on changing the name of the administrator account in Windows for security purposes.  I plan to follow kb 816109 (http://support.microsoft.com/kb/816109/en-us) to use Group Policy to do this (we are running W2003 on servers).  My question is, will this affect anything in regards to SQL.  I have SQL2005 on a member server and normally use Windows authentication for Sql SMS and SQL services.  I can see username is filled in as 'domain/administrator' and is greyed out so it cannot be changed...if the administrator account is renamed through group policy, will Windows authentication still work with the new login name or will it only work with account name 'Administrator'? 

Same server farm administrator domain account for both Intranet and Internet Sharepoint site?

Hello,   We are planning to setup 2 streams of architecture for both Intranet and Internet web sites. Just wondering whether there is any best practices/security concerns if we are using the same domain account as the Server Farm Administrator for both Intranet and Internet platform?   Thanks,

How to change the System Account into Domain Administrator account in Sharepoint?

I'm attaching the captured image from the Central Admin of our Sharepoint Server. (http://www.experts-exchange.com/images/346242/Central-Admin.jpg) As you can see from the Central Admin image, the user account shown is "System Account", in whereas I logged in as our Domain Administrator. Then when you check it's info from My Settings, the details from the captured image System Account Info was shown. ( http://www.experts-exchange.com/images/346243/System-Account-Info.jpg) How can I change it as be DOMAIN\Administrator & not SHAREPOINT\system or System Account? Please advise...  

Cannot log in into SharePoint site with administrator account


I have set up a SharePoint environment where I have set up a test web application and a site collection.  It is important to mention that everything has been set up using the administrator account.  Once I try to logging in using administrator account it fails after 3 tries and it just give me a blank screen.
I also checked IIS for security setting but I do not see anything wrong!
As a side note I am able to connect Central administrator without any problems using the administrator account.
I think it is a security setting but I do not know where to start
Help is greatly appreciate


Rule "User account requirement for Farm administrator " failed

Hi guys,

I'm trying to install the PowerPivot for SharePoint (SP 2010) following the instructions in http://msdn.microsoft.com/en-us/library/ee210616(SQL.105).aspx

The problem is the following step:  "In Installation Rules, click Next."

Image of error: http://yfrog.com/0rproblembzlj

I'm administrator of everything. SharePoint, SQL Server, machine...

Any idea?

Need help!

"Create failed for Database" when running under administrator account without built-in account.


- I am having an application which can install several instances of sql 2008 express on my pc, in built-in administrator windows account, everthing worked well, then i created more an account and grant administrator permission on this account,  but when i logged into this account, after logged on SQL management by Windows authtication mode, then attempt to create any database in SQL management studio, i got an exception as below:

TITLE: Microsoft SQL Server Management Studio

Create failed for Database 'test'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476


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


Single shared "SQL Server Administrator" account or multiple accounts?


We have an environment where one of several admins might be asked to perform administrative tasks on a SQL Server 2008 running WS 2008 R2.

We are running mixed authentication and want admins to log in and administer SQL server and the database using their own admin accounts.

What I would like to do during installation, under "data base engine account provisioning" is add a domain security group to the list of SQL administrators and make sure that the admins who are allowed to administer SQL server and the database are in that group.

Is there a downside to doing that? for example the admin who runs the initial script to create the database might end up the owner of the DB... Will that be a problem, or is there some other approach we should take on this?

What I'm trying to avoid is having admins share a Windows account for DB administration. We mostly use remote desktop for admin tasks and that gets messy with a shared account.


MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Modal popup window in ASP.Net

A Masked div or modal popup window is a child window created from the parent window which prevents the user from interacting with parent window before he returns to the parent application.

lossing focus from model pop up window controls


hi i using a model pop up window with some textbox but when i click on textbox of model pop up focus move to back to page textbox control plz help me 

SqlServer - Windows Account to install Application from Gallery


Referring to this tutorial: http://www.asp.net/webmatrix/tutorials/download-and-install-an-asp-net-application

I selected umbraco cms and got this wizard:

I already have Standard Sql Server 2005 on my machine which I wanted to us for above DB and not SqlExpress.

I did not remember "sa" account pwd nor I use explicitly any account to connect to my Sqlserver. I use Windows Authentication account i.e implicit authentication. So I created new account and gave all rights and used it in the above wizard and was able to install the database after some struggle.

My question is: What if I want to use my Windows Account to install the database above? Why the wizard don't have any option to use Windows Integrated Authentication?

Note: I can create the DB with external user I created, just looking specifics for using Windows Authentication for above installation.

Wrong Account being used to access files - Help - No Impersonation


I run a simple .aspx website on a Windows Server 2008 machine.

There is NO impersonation, and System.Security.Principal.WindowsIdentity.GetCurrent().Name returns NT AUTHORITY\NETWORK SERVICE, which it the account which the application pool runs. In my web.config, I have <authentication mode="Forms">.


I tried to test the security of the application and server by removing file permissions to the .aspx files. I was greatly worried when the website continued to run without problem (it should not have been able to read the .aspx files).

By turning on file level auditing, I discovered that the .aspx files were being read by the machine$ account (if the machine is called Serv1, then the files would be read by the Serv1$ account, which seems to have access to all files on the local machine).


Is this a security breach or is this behaviour by design ?

Please can somebody assist, as I am worried.

ASP.Net account deleted. How to create it again?


 Hi I have created an intranet application using ASP.Net/IIS.

I normally need to web share the folder and allow full permission to ASP.Net user account.

However, I carelessly deleted this account. How to create it again ?

Pls help.... thanks.


Error while using exception handling block el 4.1


Hi Folks,


i am trying to use tyhe exception handling block of Enterprise library 4.1.


I just createda polisy and used IndexOutOfRangeException and added a replace handler and a logging handler to it.

I am using the NotifyRethrow PostHandlingAction to the exception.


During runtime I am getting an exception on the HandleException event, The exception is added below:



Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 42:             catch (Exception ex)
Line 43:             {
Line 44:                 bool reThrow = ExceptionPolicy.HandleException(ex, "ReplacePolicy");
Line 45:         

Using the ConsoleTraceListener with the Enterprise Library 3.1 Logging Block


I'm new to using the Logging application block.  I think I have a pretty good handle on how things work.  However, I'm running into a problem.  I'm using the RollingFlatFileListener and I have formatted the logging template to be more like the logging we are replacing.  However, in our console apps when the ConsoleTraceListener is added it still logs it out in the default text template format.  Is there any way to get around this?  Currently it looks like I will have to create a new TraceListener called FormattedConsoleListener that allows a text formatter to be associated with it.  Is this the only way?

set messageTemplateResourceName from resource file in Validation appication block.



  I am using Validation application block in my project and want to set validation message from resource file, but not able to do that. I tried giving the path of resource file in messageTemplateResourceType and name of resource in messageTemplateResourceName. But it did not help as I only receive the message if I have set something in messageTemplate even after setting the resource file.

Here is my code:

<validator lowerBound="1" lowerBoundType="Inclusive" upperBound="250"
              upperBoundType="Inclusive" negated="false" messageTemplate=""
              messageTemplateResourceType="Asurion.jCare.Common.Resources.UIResources.PerilTypeAndDetailsSection, Asurion.jCare.Common.Resources, Version=, Culture=neutral, PublicKeyToken=null"
              tag="" type="Microsoft.Practices.EnterpriseLibrary.Validation.Validators.StringLengthValidator, Microsoft.Practices.Enterpris

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