[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

How to Use AD Authentication for Visual Web Developer 2005 Express Edition

Hello all,
    Here is my requirement : I wanna show my employee payslip info in online (At present Intranet). Actually our Pay Details are in Oracle DataBase. I'm using Visual Web Developer 2005 Express edition. I'm planning to make a login in page so that users need to autheticate with there AD User Name and password and from there I'm planning to check the details comparing with there corresponding mail id's in AD and in Oracle Database.How Can I do this ? If possible after all this I'm planning to Publish this one into SharePoint. Is it possible ?
0
PillalamarriVenkateswaraRao
Asked:
PillalamarriVenkateswaraRao
  • 10
  • 8
3 Solutions
 
Ted BouskillSenior Software DeveloperCommented:
In IIS and ASP.NET any web application can have 'Windows Authentication' enabled with Anonymous turned off so that only domain members can access a website.  It's built in, you don't have to write code for it.  All you have to do is get the User Identity of the person requesting the page and get the data on their behalf from your database in a form.  IIS and ASP.NET will do all the work for you and it's secure.

However, I'm going to give the same advice I give to every web developer and mandatory behavior for every developer I manage.  Build the software in an environment that matches production.  So, don't build your site in XP.  Install Windows Server in a virtual machine or as your host operating system and work on that O/S.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Thanks for the response.
Can I get the clarity on the below ones:
 If I want to develop the application then what is the process I need to follow.
  1. Shall I Create a web site under SharePoint and then, write the code for my Application ?
    • If so I will have anonymous access information availble in our SharePoint. But I need to check, Is my application is going to take Oracle database connections ?
  2. Shall I develop the applications in Visual Web Developer 2005 Express Edition ?
    • If so then how can I import my application into SharePoint ? Where I will get anonymous access information on that perticular application ?
    • Is Oracle database connections are going to work properly if I import my application ?
If possible Please give me any practical example you have done with my question.
THanks
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Hi tedbilly,
  I created a site under SHarePoint and deleted webparts in default.aspx page and taken Grid View into my page. And I was connected to my oracle database string. It's working fine.
Any valueble suggestions on this one. Because it may effect the server performance na!
And my connection string will store on individual pages. Any idea on placing web.config file for storing my connection strings ?
THanks
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Ted BouskillSenior Software DeveloperCommented:
Hmm, I just read your last 2nd last comment.  Are you intending to integrate this with Sharepoint (or at least appear to) or is it a completely separate application?
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
If possible I'm planning to integrarte with SharePoint.
But I just tried that in SharePoint default.aspx, Is it possible to connect the Oracle database. It is connecting, But when I'm accessing from the url in other system, it is not going to connect.
Anyway what you will suggest me ? Is it better to be separate application or and mingle with SHarePoint ?
Thanks
0
 
Ted BouskillSenior Software DeveloperCommented:
You can access any valid data source with custom web controls and web parts directly in Sharepoint including Oracle.  The trick is that web parts or controls accessing any external data source (including another non-Sharepoint SQL server) must be configured as 'Full Trust'

I'd recommend you work directly in Sharepoint.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Where I need to Configure as "Full Trust" ?
THanks
0
 
Ted BouskillSenior Software DeveloperCommented:
You have two choices.  You can add it to the definition of the web part assemblies when you install them using a Sharepoint Deployment Solution or you can set it globally for an entire web application in the web.config.  Look for the following: <trust level="WSS_Minimal" originUrl="" /> and change it to <trust level="Full" originUrl="" />

The following URL describes configuring code access security in Sharepoint: http://msdn.microsoft.com/en-us/library/ms916855.aspx
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Hi Again,
  I changed my trusted level to "Full". But I'm unable to access my site from other systems (Getting Internet Explorer cannot display the webpage).
One more thing, I accessed my data on one site by removing defult webparts parameters and placing my grid view component in the page. Is this correct way?
Can You please suggest me which one is the better way to design my pages ?
It is better, if I have single instance of connection string parameter.
THanks.
0
 
Ted BouskillSenior Software DeveloperCommented:
I'm a little confused by what you've done so I'm going to back up a bit and go over some basics you probably already know but I want to be sure we haven't missed anything.

Developing in Sharepoint is actually more complex than a typical ASP.NET web application.  That is because Sharepoint has specialized ASP.NET for it's own uses.  It uses it's own custom ISAPI DLL and renders all content dynamically from a database.

So, if you want to author web customization in Sharepoint you MUST do things the Sharepoint way.  If you simply start removing components in pages or add pages in Sharepoint the same way you would in a regular ASP.NET web application you will simply break Sharepoint.

Have you downloaded WSS and Sharepoint SDK's to learn how to customize Sharepoint?
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Be Fair, I had seen a bit information on WSS SDK. Can you plz suggest me which topic will provide me clear idea.  Anyway I will see that information.
Thanks.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Oh !! I understood now, What you said.
We need to care about some of the Webparts and other steps while doing creating new applications in SharePoint / to SharePoint. I'm I right ?
If it is, I had some idea on this one. Let me try with another way and let me know what happens if I do ....
Thanks.
0
 
Ted BouskillSenior Software DeveloperCommented:
Yes, you are on track now.  Depending on the site template Sharepoint defines specific web parts and controls that MUST be included in the master page and page layouts.  If they are disrupted or changed the pages will fail to load correctly.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Hi Again,
  I tired with different seanrios like with our removing any web part (Singl peace also I was not removed), The data is connecting but the site is not going access in other systesm (I add trust level to Full). But No Sucess.
So I followed one MSDN Article for Oracle database connectivity (http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx#5)
Got the first error as
"Server Error: An error occurred while retrieving the list of Databases from ServerName: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information."
So for this error I had seen the below URL
http://support.microsoft.com/kb/831092
After sample testing I added my sharepoint server address as Proxy URL in web.config file. So I got the below error
"You do not have permission to do this operation. Ask your web site administrator to change your permissions and then try again, or log on with a user account that has this permission. To log on with different account click OK"
So for this one I login as Administrator. After Logging as an administrator I got the below two errors one by one.
"The Server Unexpectedly closed the connection. "
"Server Error: An error occurred while retrieving the list of Databases from servername.
The Server Unexpectedly closed the connection.
"
So I think the connection is getting. Here I changed my Proxy address as http://192.xxx.xxx.xxx:xxxx. After giving this one I got the error problem as first one.
"Server Error: An error occurred while retrieving the list of Databases from ServerName: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information "
Any Suggestion.
Thanks
0
 
Ted BouskillSenior Software DeveloperCommented:
Did you make the full trust change to all the web.config files for the web application you are using the web part on?

Also, have you confirmed Oracle connectivity from each Sharepoint server using SQL Plus?  If the Orace drivers aren't installed correctly on the Sharepoint servers it won't work.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Sorry for asking this one. Provide me the details for the below question. So that I will get the clarity.
  What are the different steps I need follow for designing an application which will access the Oracle Database in SharePoint.
Please provide me detailed information. Or If you have any doc please provide me once.
Sorry for troubling more. This task is very important to me.
Thanks.
0
 
Ted BouskillSenior Software DeveloperCommented:
1) Install the latest Oracle Client Drivers on each Sharepoint farm server (verify connectivity on each)  The Oracle site has everything you need to do it.
2) For every web application that you want to add Oracle web parts change <trust level="WSS_Minimal" originUrl="" /> to <trust level="Full" originUrl="" />

It's really quite simple.  As long as the driver is installed properly it's easy.
0
 
PillalamarriVenkateswaraRaoAuthor Commented:
Upto now I was not get the solution. But you had guided me in different angles. Thanks for that. I will inform you when I get the success.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 10
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now