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


Top 5 Contributors of the Month
hdjk11
Shivakumaran
dfefde5
hoangnganvy1993
Post New Web Links

Managing user accounts in SQL database for form based authentication

Posted By:      Posted Date: November 04, 2010    Points: 0   Category :SharePoint
 

Hi everyone

I have just configured form based authentication using a SQL database created using aspnet_regsql.exe.
Does anyone know of an good solutions that my customer can use to manage it, add users, delete user etc

Thanks




View Complete Post


More Related Resource Links

Form Based Authentication with Custom database

  
Hi, I have a Sharepoint 2010 web application and I want to implement FBA(Form Based Authentication) for that. I don't want to use any membership providers and role providers. I have a SQL server database where we will maintain users and roles. I want to use this database for validating user credentials and authenticating them. Is this possible in Sharepoint 2010? Please reply ASAP.

Form Based Authentication(FBA) with Oracle database

  
can anybody give me configuration details for share point Form Based Authentication with Oracle database

Forms based users being prompted for windows authentication login for My Sites photos in user lists

  
Here's an issue I didn't see coming for our forms based authentication users. 

We have a web application extended to an external url to handle forms based authentication for users outside of our domain. Our setup looks like this...

Internal Users/Windows Authentication - moss.domain.com
External Users/Forms Based - mossext.domain.com
My Site for Internal Users - mysites.domain.com

When our forms based users are accessing user lists, or discussion pages that display user pictures, they are getting a windows authentication login for our internal users (mysites.domain.com) who have populated their my site with personal photo.

How do we fix this? 

How to fill out a form as another user , while using profiles database

  

I have created an InfoPath 2007 form. It works great.. I have 5 data connections to sharepoint lists and profile's database. The form displays public data (profile database) about the user, such as name, manager.. etc.

What I would like to do is have an option on the form that says " If you are not this person , click here" , manually type the persons last name , and bring up their information.

Basically , there are some people who will have someone else fill the form out for them. But I don't want them to be giving out their username and password to the system.

I want the ability to fill out a form as another user without logging off sharepoint. 


=User!UserID from windows authentication using table from another database

  

hi,

i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.

what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.

now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.

when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.

does someone knows how to do this?


AutoLogin for authenticated user via LiveID in Sharepoint 2010 (Claims Based Authentication)

  
Hi,     Im working in integrating LiveID authentication in my Sharepoint site. Live id gives back a token of the user with which i created a dummy profile using MembershipProvider.CreateUser. Now i have to auto login the user with the profile i created, i mean i have to force login to my sharepoint site using the created dummy user details without asking the user to give username n password.Any suggestion will be a great help for me to proceed.   Thanks Saravanan Michael

Form based authentication Sharepoint 2007 gets redirected to login page

  
Hi We have sharepoint 2007 site deployed on Windows server 2008, IIS 7.0.  We extended the web application to enable forms based authentication referring to link http://msdn.microsoft.com/en-us/library/bb975136(office.12).aspx#MOSS2007FBAPart1_Intro, we selected Kerberos instead of NTLM, behavior is like, when user tries to login into the site using OOB login.aspx, user again gets redirected to the login page. We tried to extend the web application again but this time we selected NTLM, but this time farm account (also is application pool identity) is not able login and exhibits same behavior as above, but for other users we are able to login. Has anyone come across this behavior? can anyone please guide me in correct the behavior? Regards, RK  Radhakrishna

how to change the web application Database connection form Windows authentication to SQL Server acco

  
Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

SP 2010 Form Based Authentication username begins with "i:0#.w|"

  
Hello there! For the life of me, i can't figure out why SharePoint keeps putting the phrase "i:0#.w|" infront of everyones username / accounts. Both on mysite and portal sites. A quick bing search revelaed that i am not the only one: http://fangdahai.blogspot.com/2010/06/i0w-is-still-there-in-sharepoint-2010.html. Anyone have a solution to fix this annoying problem? Thanks!

Form based Authentication - OpenLdap problem

  
Hi everyone,   I try to set up FBA with LdapMembership provider.   I have configured web app + STS like this : <add name="LDAPMember" type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" server="server" port="389" useSSL="false" connectionUsername="uid=portal_sharepoint,ou=people,dc=corp,dc=contoso,dc=com" connectionPassward="somthing" userDNAttribute="distinguishedName" userNameAttribute="cn" userContainer="ou=people,dc=corp,dc=carrefour,dc=com" userObjectClass="person" userFilter="((eduPersonOrgUnitDN=cn=portal_sharepoint,ou=applications,ou=organizations,dc=corp,dc=contoso,dc=com))" scope="Subtree" otherRequiredUserAttributes="sn,givenname,cn" />   I can without problem use the people picker and get user information from it. But when i try to authenticate user i have an error that say : An exception occurred when trying to issue security token: The security token username and password could not be validated.   If i look my log on the ldap i see that all the time it's the portal dn that is used to authenticate user.   I

HTTP 403 Forbidden - After Configure with Form Based Authentication

  

Dear Expert,

My existing SharePoint Site authentication Provider is set to form based authentication.
While i try to access the site by using SharePoint Designer, it prompth me access denied message.
so i had temporary change the authentication to windows, then i able access to the site by SharePoint Designer.
( is it SharePoint Designer can access to the site in form based authentication, please advice )

After done to SharePoint Designer stuff, i had change back the form based authentication with the membership provider as before.
while i goto site collection administrator to change back the FBA Admin, i'm not able to access to FBA user list. (please advice)

While i try to browse the site, it show me this "HTTP 403 Forbidden" error message. (please advice)
i had check the web.config file. it should configure correctly.

Thanks in the advance!

Best Regards,

Bey

 

 

 


Forms based authentication allow only specific users from database table

  

I have the following implementation and I'm sure there is an easy way to do what I want to do but I can't figure it out. 

1. I use forms based authentication to authenticate to my site

2.  I use active directory to authenticate the users

3.  I use the Allow Users="xxx" tag to authorize the users limited to the list that can access my site. (e.g.. even though Mary is an AD user she can't access my site unless I put her credentials in the allow users tag in the web.config file)

All is working well but I want to move the users access list (e.g.. <allow users="john" />" from the web.config to a database table so that I can create a user maintenance page for my admins to add and delete user access.   For the life of me I can't figure out how to do this and I can't seem to find an article on it either.  I'm sure I'm just not looking for the right thing, so help is greatly appreciated. 

Here is my web.config file..


<configuration>
 
    <connectionStrings>
    
        <add name="DBConnectionString" connectionString="Data Source=PRIMSRV;Initial Catalog=MAINDB;Persist Security Info=True;User ID=svc.Test;Password=password

How can I replace domain user accounts with a general database account?

  
Hi,

How can I replace domain user accounts with a general database account?

thnks,
Gok

Increase Session Time Out in WSS 3.0 Form based Authentication Site

  

How to increase session time out for form based authenticated shrepoint site ,

Default Sharepoint  time out is 30 min ...

I want session shuld expire after 120 min..


Manesh

WSS 3.0 Form Based Authentication & OWA on same web server?

  

Ok....I have Outlook Web Access (Exch2k3) configured using Form Based Authentication (FBA) on my frontend web server under the default iis site.  The web address is https://exchange.mydomain.com.....works perfect.

 

Now, I have a second iis site called SharePoint_Extranet.  This site is accessible from the web https://sharepoint.mydomain.com currently using integrated windows authentication to access.  This site uses a second IP address, with the different host header.

 

When I implemented “Forms” authentication in the Central Admin page in SharePoint....I selected my extranet web app......and the problems began.

 

Apparently, doing this stopped the OWA virtual server.....and now when I navigate to exchange.mydomain.com, it presented the SharePoint form instead....?

 

Since these are production systems, I immediately reverted the SharePoint back to windows authentication, and started my Exchange virtual servers back up....and all returned to normal.

 

My question is, can these 2 services both reside on the same iis web server using separate FBA?  If so, how can I implement it without interrupting service?

 

Any help would be greatly appreciated!


how to set read only properties to the particular info path form control based on user logged in?

  
how to set read only properties to the  particular info path form control based on user logged in?

Form based Authentication

  

So I finally got FBA to work with my Active directory server.  A users authenticates fine.  The issue i have now is when I add a user for permission based on a group using people picker.  So, if I want to add a group for permission to a site in my AD and when one of those users in the group try to authenticate they get access denied.  I am 100% certain that the user is in the group but for some reason FBA will not look for the user within the group.  Anyone have a solution or can assist me with this I would appreciate it.

modified snippet web.config

=====================

    <add name="membership"
      type="Microsoft.Office.Server.Security.LdapMembershipProvider, Microsoft.Office.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"
      server="contoso.com"
      port="389"
      useSSL="false"
      userDNAttribute="distinguishedName"
      userNameAttribute="sAMAccountName"
      userContainer="OU=Accounts,DC=contoso,DC=com"
      userObjectClass="person

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