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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Unable to set Default Schema for a group

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server
 
We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.
 
Is this by design,  a bug or a problem with our SQL Server installation?

Updated on 2005/08/29

My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message 
 
Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)
 
Additional Information:
 
--> An exception occured while executing a Transact-Sql statement or batch.
     (microsoft.SqlServer.ConnectionInfo)

     --> The DEFAULT_SCHEMA clause cannot be used with a Windows group or
          with principals mapped to certificates or asymmetric keys.
          (Microsoft SQL Server, Error: 15487)

Why can we not set a Default Schema to a Windows group?  This would be


View Complete Post


More Related Resource Links

Changing default permissions for Owners group

  
When a site is created within SharePoint (and permissions are not inherited from the parent), a default Owners, Members and Visitors group is created.  The default Owners group is assigned "Full Control".  I want this to default to a custom permission level that I have created called "Full Control - Limited".  What changes do I need to make to ensure that all new Owner groups are automatically assigned this custom permission level and NOT "Full Control"? EDIT - I have a console application which sweeps through all of the sites and changes all "Full Control" to "Full Control - Limited" but I really don't want to set a Scheduled Task each night to fix the new groups. 

unable to create a group using directive services -ASP.net C#

  
 this is what i used: public void Create(string ouPath, string name)        {            if (!DirectoryEntry.Exists("LDAP://CN=" + name + "," + ouPath))            {                try                {                    DirectoryEntry entry = new DirectoryEntry("LDAP://" + ouPath);                    DirectoryEntry group = entry.Children.Add("CN=" + name, "group");                    group.Properties["sAmAccountName"].Value = name;                    group.CommitChanges();                }               

In a group calendar, can items be made visiable to all users by default without adding them as atten

  
Well the title says it all really. We have a functioning sp 2010 site, setup this weekend, that's working great so far.  Primarily its being used for the company manual and procedures (a wiki site).  Search is working well and so on. I added a calendar with the intention of showing key company activities, plus holiday information and who's out at meetings.  We're a small company and this is unlikely to get ridiculously except on exceptional days. As it stands, when i create an item (for example someone out for a weeks holiday) unless another user adds one of the 'attendees' of the holiday event to the calendar it doesn't show up.  If I add all users as attendees then they can all see it by default. However, if I show that our chairman is attending a meeting at a client, then I can't explicitly say that the chairman is an attendee because for everyone to see it, they have to be attendees as well. I nsoed around a little and thought target audiences might be the way to go.  I configured all users and manager relationships, compiled the audience (it shows the right number of users).  However, if I setup a meeting with the chairman as an attendee, and the whole company audience as the target audience, then people still can't see it. Back to square one. So, is there an actual answer to this?  A different type of calendar, a query that

Unable to Merge columns outside Group ? Unnecessary Row height ?

  
HI , In a matrix tablix , I'm unable to merge columns outside the group . Heres a quick screen shot . http://img843.imageshack.us/img843/366/samplema.png The top 3 columns is what i meant [ Unable to Merge columns outside Group ]  and Row height of the first row ? Thanks in Advance !!Rajkumar Yelugu

Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

MySql mebership -> Unable to initialize provider. Missing or incorrect schema

  

Hi

I have installed Mysql connector/NET 6.2.4 and troied to follwe the MySql documentation5.5 chapter 21.2.4.2 "Tutorial: MySQL Connector/NET ASP.NET Membership and Role Provider"

That is:

  1.       Added autogenerateschema="true" to machine.config
  2.       Stared a website on the local filesystem
  3.       Added a connectionstring to web.config to the mysql server at my web hotel
  4.       Choosen mysql role and membershipprovideres in the Web Site Administration Tool
  5.       Now hitting the security tab results in:

Unable to initialize provider. Missing or incorrect schema. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 145)

 Line 145 in machine.config is:

<add autogenerateschema="true" connectionStringName="LocalMySqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Clear" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanu

Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

Even the web services have methods to get the windows network credentials. While trying the following code, to pass current credentials, default credentials is empty.

myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials (Here it is a null value)

Application is using Windows Authentication | NTLM.

The following code works, if the authenticat

"Person or Group" Field Default Value

  

 

I have a "Person or Group" column being used to indicate an Assigned To value for our application. I would like the value of that column to default to the current user's name - in other words, the person submitting the new list item will be the assignee by default (and has the option to change it).

 

I tried doing this through SharePoint Designer by placing [Me] in some value attributes, but it's not working.

 

Is there some way to accomplish this?

 

Thanks,

Jen

 

 


Default Calendar modification, unable to delete fields

  

Hello.  I'm new to Sharepoint Foundations 2010 (i've used Sharepoint Portal Server2007 and all the prior versions).  I would like to use the default calendar as a template but cannot delete the fields I do not want to use.  What are the steps to remove the fields (Something involving the Event Content Type) I do not wish to use?  I've tried deleting the content type but cannot (I get the following error: The last content type on a list cannot be deleted.Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: bcb50019-5830-42f3-bde6-9b0353b803e1 Date and Time: 10/4/2010 2:24:05 PM ).  If I could create a new calendar with only the fields i need that has the current view in it that would be great.  I cannot seem to get a new view to mimic the current view from the calendar webpart.  any ideas could be greatly appreciated.

 

newbie


Unable to access default.aspx page

  

When I was testing the use of some of the web parts available to some user's web page, I created a web part to list the content of some document librabry we have.

When I was editing the web part's <Actual View>, on the "Folders" category I chose the "Show this view" as "Folder of the content type", "Sent Letters" (example).

As soon as I pressed OK I was redirected to the home page of that content type list.

I tried to return to site's the Home Page by pressing the Home Page button and event typing the URL http://servername/default.aspx but I keep being redirected to the document list I chose for the web part.

This only happens to the user wich created the troublelling web part.

How can I reset the home page of that user?

Please help


Calendar View: Unable filter Recurring Event by Start/End Time and Group by Recurring Event View

  
Hi All,
I have just found several issues with Calendar View from WSS 3.0:

Unable to filter by [Start Time] and [End Time]
I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time.

Unable to use "Group By"
When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column).

Thank you and apprecate for any idea.


View all resources on a SharePoint group calendar by default.

  

I have set up a group calendar in SharePoint and added 10 items to the associated Resources list.  By default resource bookings will not appear on the group calendar unless you manually select the resources through the interface.  I would like the calendar's default view to display all bookings (or all available resources) by default.  Anyone have recommendations on the best way to do this?

Eric


Reporting Services 2005 - Scatter Report Unable to show category group

  

Hi,

  I am using scatter chart to create some sort like

 

Quantity  Time  Machine Name

12 2010-09-10 04:21:11         M1

22 2010-09-10 19:21:11  M1

100 2010-09-11 05:21:11  M1

89 2010-09-11 07:21:11  M1

 

66 2010-09-12 07:21:11  M2

18 2010-09-13 07:21:11  M2

 

68  2010-09-12 07:21:11  M3

 

X-axis show me the quantity, Y-axis shows me the time and then machine name group its time and qty under different category group. How to make it.

I have tried to use scatter chart to display but I can only see the X and Y -axis and without category group shown...  


Default Value for 'Person or Group' column in a Sharepoint 2010 Custom List

  

Hello,

In Sharepoint 2010 I have a Custom List with a column of the type 'Person or Group'.
I would like to have a default name for this 'Person or group' column.
So when a user creates a new list entry and leves the 'Person or Group' column value blank the list entry should be created with the default value für the 'Person or Group' column.

Is there a way to schieve this?

Many thanks in advance.

Roberto Rocco.

 

 


Can you change the default schema from dbo to the user's schema

  

In SQL server 2008 - there are multiple users set up with their own schema under a common database. Currently the users are set up with dbo as their default schema. Since DBA has not given write access to the users to write to dbo schema, users have to write their t-sql se create table schemaname.tablename  instead of create table tablename.

Can you make the user schema as their default schema. If yes then will a sql like create table table1 work (with out prefixing the schemaname). I could have tried but don't have the access to change the default schema for an user (not a dba)

Thanks


Problem to group radio button across gridview rows

  
In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Default ASP.NET Architecture

  
In providing an architectural approach, some assumptions are made concerning the project goals. These assumptions should be used as a litmus test to determine if the described architecture may be an appropriate fit for your ASP.NET application.
Categories: 
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