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

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

Sharepoint form authentication with SQL Server and Oracle both.

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

I want to create registration form which will create user in SQL Server for sharepoint 2007. I have another database also in Oracle which is having table with user detail. How can we make username in SQL Server which will check in SQL Server and Oracle both which will check that it is already exits or not.

Now when user added in sharepoint 2007 I need to add that username in sharepoint group with some role defination for document libarary. User can be in SQL Server  (i.e. aspnetdb) or in Oracle. How can I do that using both database at same time.

Next thing also I wanted to know How can I add user in some group for only for specified days for example 10 days only then it would be removed automatically from that group. 

View Complete Post

More Related Resource Links

Creating a Folder in SharePoint Server 2010 From Oracle Form


Dear all,

I have an Oracle Form where I am recording Employee Details.

What I want is whenever i am recording an Employee Details I want a folder for the employee to be created in the SharePoint Server 2010 site.

Is this achievable?

If so, please guide/help me.



Creating a Folder in SharePoint Server 2010 From Oracle Form


Dear all,

I have an Oracle Form where I am recording Employee Details.

What I want is whenever i am recording an Employee Details I want a folder for the employee to be created in the SharePoint Server 2010 site.

Is this achievable?

If so, please guide/help me.



SharePoint - Report Server - Client Certificate authentication

Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

Cannot publish InfoPath 2010 form template to SharePoint Server 2010 RC

Hi all, I am MSFT in Vietnam. I created a SharePoint list using InfoPath 2010 RTM 64bit. After publishing it to SharePoint 2010 RC, I see an error message:  Click on button "Show Details" the message is The list schema does not match the schema of this form. Refresh the data source and publish the form again. When I create new item based on published SharePoint list, I can see plain form not browser enabled InfoPath form. I checked InfoPath Form Services, everything seems to be good. What should I do to publish SharePoint list from InfoPath 2010 to SharePoint 2010 as browser enabled form?

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.

Server Side Validation for SharePoint 2007 Form Fields


Hi Guys,

Need to validate NewForm.aspx and EditForm.aspx of SharePoint custom list. My current implementation is by using JavaScript. It's working fine.

Someone suggested JavaScript is not a good approach.I am unable to fetch ids dynamically by JavaScript only for few fields (people picker, calendar control) and in that case i have hard coded the ids. hardcoding is always a bad approache.

Is there any way to validate those mentioned form at server side? Is it really good way to think that my validation can put inside Event Handler?

thanksArup MCTS - SharePoint

Play Sudoku

Form Based Authentication(FBA) with Oracle database

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

SharePoint Form Authentication site showing Error for few actions in Picture library.


I have extended my web application (with zone Extranet) and enabled Form Authentication, Enabled Client Integration and SSL.

My problem is: In my picture Library 

     1. Actions - Download/Send to actions are not working, getting error message: "Picture Manager is unable to open   pictures over the internet that are not from a windows SharePoint Services picture Library. Please specify a valid picture library and try again".

    2. Actions - Open with Windows explorer getting the error message:"Documents in this folder are not available. The folder may have been moved or deleted, or network problems may be preventing a connection to the server".

   3. In the Explorer view i am getting : "Please wait while Explorer View is loaded. If Explorer View does not appear, your browser may not support it".

But when I open the same library and do the above actions in default zone (port 80), it is working perfectly.

I have SharePoint service pack 1 and infr

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!

Form based authentication on current web application SharePoint 2010



I have question about creating form based authentication. I want to have different authentication in the same web application in the same time. For now I have windows authentication and I want to extend it to Form base authentication. I follow procedure on link http://blog.summitcloud.com/2009/11/forms-based-authentication-sharepoint-2010-fb/ step by step but it doesn't work. Also when I try to change authentication in Central administration to Forms it is not possible because that option is disable. Is there any setup for overcome this issue.

Thank in advice.


WCF over SSL with Forms Authentication on a Sharepoint Server


I want create web services in SP over SSL via Forms Authentication so I can consume them in a WPF app. The services seem fine as I can navigate to them via the browser and they don't throw an error. The SSL is done by a self certificate so I get a warning in my WPF when I create my service reference. However I added some code to override certificate checking as this is a learning exercise and I want to tackle one thing at a time. The web config for the web service is below but when I use this code in my client I get an error :

An error occurred when verifying security for the message.

Here is the stack trace: googling seems to point to resyncing my machines clock but the client and server are on the same machine.


Server stack trace: 

 at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.ProcessReply(Message reply, SecurityProtocolCorrelationState correlationState, TimeSpan timeout)

 at System.ServiceModel.Channels.SecurityChannelFactory`1.SecurityRequestChannel.Request(Message message, TimeSpan timeout)

 at System.ServiceModel.Security.SecuritySessionSecurityTokenProvider.DoOperation(SecuritySessionOperation operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout)

 at System.ServiceModel.Security.SecuritySessionSecurit

Unable to open document in IE From Sharepoint Site using Form authentication


I have created sharepoint site using MOSS 2007 and am using  "Form” Authentication.

After Successfully logging into site, when I attempt to open an MS office document from the document library, It pops up an authentication window. Once I close the authentication window, the document Opens, if I don’t close the authentication window, the document does not open.

This is happening only in Internet Explorer.Documents are opening without entering credentials in “google chrome” and “Mozilla”. The authentication pop-up itself does not appear.


Vidya Jeerahalli

Form based authentication in sharepoint 2007


Hi ,

I have implemented form based authentication(LDAP) on SharePoint site. everything working fine.But we are not able to resolve the user with display name for first time.(User are stored in active directory.)

Like if i want to give an access to user over site, we need to provide usename or email address. once it will be part of site, if i want to add that particular user in any other group of the site then display name would work fine.

Issue is only with first time adding a user on site with display name.

my observation is, once the user first time added, sharepoint keeps the profile entry in content database(UserInfo Table). so that next time, that table is reffered. thats why second time, display name will be resolved with people picker.

Please provide some help.


Navin Srivastava








Is it possible to publish an InfoPath form when I cannot see the SharePoint Server?


I feel like I'm in a Catch-22, but also that I may be missing something obvious.

I want to publish an InfoPath form for a SharePoint Server to be used as a web based form. The form is going to be in a Form Web Part, with a button to submit it (no InfoPath chrome).

The catch is that I cannot directly connect to the sharepoint server from my dev machine.

So here's where I am:

- To have a button to submit the form, I have to use a submit action; can't save.

- To have a submit action, it has to have a data connection.

- To have a data connection, I have to connect to the SharePoint Server. There's no way that I've found to manually configure this - InfoPath always wants to talk to the server, and refuses to proceed if it can't.

- Publishing the form  - any SharePoint publishing wants to talk to a SharePoint server, even an Admin Deployed form (which is silly). I haven't tried publishing as a network form then doing an admin deployment anyway, since I can't get past the data connection issue; but if I do - will this work?

Note to the dev team: cut the umbilical on SharePoint. It's *nice* to be able to talk to a SharePoint site while creating connections and publishing, but it's not always possible in the real world. I should be able to create an InfoPath form, data connections, and publish it on a box that'

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this
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