.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

Feedback requested: Default schemas for Windows groups

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :Sql Server

We want to seek your feedback on understanding the scenarios where you need to assign default schemas to Windows groups.  Based on the requests we have received and reading through one of the longest threads on this issue (http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/7d46a024-7ed5-4c9b-b091-3640dc04f5a1/), it seems there are multiple solutions that people are trying to achieve using default schemas:

-          Have a default schema as part of the user's session that is set up by the application (through something like SET DEFAULT_SCHEMA = <foo>).  Any objects referenced or created will be bound to that schema.

-          Have a setting in SQL where it rejects any object reference without a schema.  This enforces the app to always use 2 part names (best practice).  This works best when you have access to the application source code or are writing a new application.

View Complete Post

More Related Resource Links

Rectangular Default Windows Button

Hi i am messing a bit with styles. I think the following code should make the normal "Button" rectangular, but on my Windows 7 machine only the left side of the button. The blue focus rectangle never changes its rounded corners. <Button> <Button.Resources> <Style TargetType="theme:ButtonChrome"> <Setter Property="RoundCorners" Value="False" /> </Style> </Button.Resources> Rectgangle Button </Button>  I used ' xmlns:theme="clr-namespace:Microsoft.Windows.Themes;assembly=PresentationFramework.Aero" '. Thanks and Greets Balkoth

how to override the default popups for windows logins for guest users?


how to override the default  popup for windows logins for guest users?

So that guests will be provided with restricted access?


Creating default SharePoint groups for upgraded sites



I am doing some testing in preparation for a DB attach upgrade from MOSS 2007 to SharePoint Server 2010, and I've run across a bunch of old sites that do not have the default Owners, Members, and Visitors groups. Without those groups (specifically, without Members) we won't be able to take full advantage of the My Sites Memberships page. 

I noticed, though, that when I "Enable Enterprise Features" for all current sites from within Central Administration, sometimes those groups get created on a site that didn't have them before. I've done this on a few different environments and it doesn't seem to always create those groups. Now, I didn't think I had to run Enable Enterprise Features because our 2007 environment was Enterprise, but then I realized some of the sites were created back in SharePoint 2003 and enterprise features might never have been run on the sites when it was upgraded to MOSS 2007. 

So the question: is running Enable Enterprise Features for current sites supposed to create the default groups if they don't exist (along with everything else it does)? Is that the recommended way to get groups made for all sites so site admins/owners can add people to that new Members group which allows the users to visit their My Site page to view all the sites they are members of?


Are nested Windows groups supported as SQL Server 2008 logins?


I am attempting to configure a new SQL Server 2008 instance to use Windows authentication, and am encountering a problem when adding Windows domain groups as logins. Specifically, Windows users who are direct members of a Windows group that has been added as a login behave normally. Users who are members of groups that are, in turn, members of other groups which have been added as logins are unable to connect.

In a simplified example, consider the following:

Group: MYDOMAIN\DataViewers
  Member: MYDOMAIN\Hazel
  Member: MYDOMAIN\Seamus

Group: MYDOMAIN\DataEditors
  Member: MYDOMAIN\Vaughan
  Member: MYDOMAIN\Liesel

Group: MYDOMAIN\AllUsers
  Member: MYDOMAIN\DataViewers <-- This is a group
  Member: MYDOMAIN\DataEditors <-- This is a group

If I add the MYDOMAIN\AllUsers group as a SQL Server login (and map it to some databases), none of the end users (i.e. Hazel, Seamus, Vaughan, Liesel) can connect. If I add the MYDOMAIN\DataViewers or MYDOMAIN\DataEditors groups as logins, though, their members can connect. Similarly, if I add an end user directly to the AllUsers group, they can connect normally.

It appears as if the nested group model I had envisioned is not supported in SQL Server 2008, but I have been unable to find any documents that state this conclusively. Therefore, my q

Programatically Find Out All Existing Windows Users,Groups Using VB.Net or C#.Net


Hi to all 

What I need is to enumerate all existing windows user-groups (those like Administrators, Power-Users etc. but even my own created groups, I think you know what I mean) - all within some C# code. 

I thought this might be easy but I searched all the Internet to find the solution, however, I still can't do it... 

Is there anybody who could help me ??? 
Thanks a lot, I really really need your help. 


SQL Server Login - Windows Groups

We are trying to standardise access to SQL Server in our oraganisation.

We are installing SQL Server Management Studio locally for all our developers and DBA's.

The DBA login in sql server has been given the 'sysadmin' role. The DBA domain account has been made a member of the following Windows Groups,

- Remote Desktop Users
- Users

Our developers have been given the appropriate database role. Their domain admin account has been made a member of the following Windows Groups,

- Users

Can you advise whether this is a correct setup, if not can you suggest an alternative ?
Do we need to put Developers in the 'Users' group ?


How to set the default culture Info for all thread of an application independant from the Windows UI


A classic 'european' topic?

I am working with Windows7Pro in German, and VS2010 in English. I whish I had all exception handling in english.
Thus, I set the explicly the current culture to english:
 var culture = new CultureInfo("en-us");
 Application.CurrentCulture = culture;
        Thread.CurrentThread.CurrentUICulture = culture;
        Thread.CurrentThread.CurrentCulture = culture;

But I do still have some exception in German, because 'by design', .NET Framework considers the Windows UI language as default culture when a new thread in created (e.g. by GUI controls), as I read here http://www.dotnetmonster.com/Uwe/Forum.aspx/winform/14177/setting-culture-of-threads

What is the motivation for such a design? It has always been a problem for us in Europe working with multi languages: it is quite difficult to ensure the software is working properly whereever it is rolled out.
Is there a way to define the default culture of all children threads?

Windows 2003, IIS 6, ASP.NET is not authorized to requested resources.



I have a asp.net 2.0 website, it has a function to create fdf file using the data from database. To fulfill this function I am using an external dll - fdfacx.dll, it is from Adobe FDF Toolkit.

Register the dll (on development machine), create the wrapper, then put into website bin folder.  Then put it to IIS 5.1 on windows 2000 server, works fine, but when put it to windows 2003 server, an error occurred:


Retrieving the COM class factory for component with CLSID {......} failed due to the followed error: 80070005

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.UnauthorizedAccessException:
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate=&quo

problem with connecting to local SQL Server 2008 default instance using windows authentication




I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.


2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT:]



This us

Jquery UI buttons style return back to windows default button



i have placed my 

    <link type="text/css" href="css/smoothness/jquery-ui-1.8.5.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.5.custom.min.js"></script>

<link type="text/css" href="css/smoothness/jquery-ui-1.8.5.custom.css" rel="stylesheet" />
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-1.8.5.custom.min.js"></script>

under my template.master - master page.

so i make a new page based on my master page.&nb

Re-create sharepoint default groups


Using Sharepoint Foundations 2010

I have deleted the sharepoint default groups, <sitename> owners, <sitename> members, <sitename> visitors from my root site http://sharepoint

I am not able to recreate them manually as they already exist (somewhere hidden). This is proven by creating a new subsite (http://sharepoint/testsite) which indeed creates the default groups.

How do I re-create them in the root site once again.

Thx, Joe

Default .NET support in Windows versions


I'm trying to figure out what versions of .NET are supplied by default in different versions of Windows. I can't find this information in one place, but so far I have:

Win XP: ?
WinXP SP1: ?
WinXP SP2: ?
WinXP SP3: ?
Win Vista: .NET 2.0 and .NET 3.0
Win Vista SP1: ?
Win 7: .NET 3.5 SP1 (includes .NET 2.0 SP1 and 3.0 SP2)

Can anyone extend this list or tell me where to find this information?


Windows Service Applications Tutorials

You can easily create services by creating an application that is installed as a service. For example, suppose you want to monitor performance counter data and react to threshold values. You could write a Windows Service application that listens to the performance counter data, deploy the application, and begin collecting and analyzing data.

Serving Silverlight Apps from Windows Mobile

Even if mobile dev is not my every day work, thanks to the .Net Compact Framework, it's still .Net programming.

Here is the scenario:

You come back home, you have a windows mobile phone wifi capable and you want to quickly get access to your phone pictures from your home network.
You just activate the Wifi, run my app and then browse to the provided link from any computer on the network.

Getting Started with Windows SharePoint Services

Of all of the capabilities of SharePoint, I thought I would start with the most basic installation - as a corporate intranet. It is likely that we will need to discuss some of the elements of SharePoint as we go along, so this also gives us the opportunity to review these elements for future reference.

Before going into too much detail, I would like to point out that you can try the core SharePoint framework (known as Windows SharePoint Services or WSS) for free. On Microsoft's Web site you can download a trial version of Virtual PC 2004 (VPC). Using VPC, you can install the Windows 2003 Evaluation Kit and the WSS add-on. This combination will give you 45 days to evaluate the setup.

Building a Searchable Phone Directory with Windows SharePoint Services

I want to continue to build out the intranet site we've started in our previous articles. A standard item in every intranet is a staff/employee list. Most companies implementing Windows SharePoint Services (WSS) are large enough to have a database that contains all employees. We will use the aggregation features of SharePoint to include data from this database into our intranet.

Getting Started with Windows Communication Foundation

Windows Communication Foundation (WCF) provides a unified framework for rapidly building service-oriented applications that makes it easy to build and consume secure, reliable, and transacted Web services. It unifies the capabilities in ASMX, WSE, Remoting, COM+, and MSMQ; therefore developers need to learn only one programming model.
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