Dear Zephyr_hex,
Are all these only apply to Sharepoint server 2007 but not Sharepoint team service 3.0 ?
Main Topics
Browse All TopicsDear all,
I want to setup the Sharepoint team service 3.0 to authenicate with SQL server 2005 login for security sick, anyway to do it? modify the web.config files? please advice how can I do modify the original one.
The reason I do it is because I find the form and SSO authenication doesn't work and only windows NTLM works but I don't want that, this will only use the login on that local machine.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Sharepoint uses Windows Authentication by default which is VERY secure. The background services should be configured to use domain service accounts. Form Based Authentication is actually less secure unless you use SSL (which slows the site) and many features don't work with it.
If your client computers are on the same domain as the Sharepoint server use the default Windows Authentication. It's secure and fast.
If you want to use 'Form Based Authentication' here is a starting point: http://www.codeplex.com/fb
As zephyr_hex recommended use SSL for the log in page.
Do not use SQL accounts for the Sharepoint services and be sure to use a local login account.
tedbilly,
The main objective is do not use local login account in that local Sharepoint team service account.
But as far as I konw, the FBA comes from Sharepoint team server 3.0 doesnt' works, I tried that, the same login account and password used in Windows Authenication doesn't work. So that only way is to use www.codeplex.com/fba?
for intranet user, I agree to use domain login of course as it is NTLM, but the main point is it is not released to public and it is already very secured.
Yeah, SSL of course, for any kinds of internet based login page !
the one in http://www.codeplex.com/fb
tedbilly,
Yeah, that one still in beta and in WSP format, I will try it and I am wondering !
But if you try to setup sharepoint team service for external staff need to login from internet/from home, what authenication method will you use?
that codeplex, someone tell me this also, I am afraid that it is some kind of application back door from security point of view.
tedbilly,
Do you know if I have to use the codeplex to work, do I need to create a separate database to store user login name ? using http://technet.microsoft.c
Yes VPN can be encrypted and yes once the VPN connection is established they simply use the intranet like they would if they were at work.
If use use secure VPN you can simply use the default Windows Authentication without any extra work.
If you use 'Forms Based Authentication' and a SQL authentication provider then yes you'd need a SQL database to store the logins. However, I'd avoid this if you can. Windows Authentication is a better choice for Sharepoint because all features are supported in Sharepoint with it.
Dear tedbilly,
OK, you mean don't use FBA as long as it is really needed, but for internet user, FBA with SSL is necessary, right?
Then what I am thinking is how/where to store to userID, How to intergrate the FBA with the DB created by using http://technet.microsoft.c
Based on your requirements I feel that 'Form Based Authentication' isn't a good choice. I'd use Windows Authentication with secure VPN. FBA has many problems with Sharepoint.
Even if your staff work from home to access a corporate website on the internet I would still use Windows Authentication with SSL because it's more secure.
Tedbiliy,
For your comment: "Even if your staff work from home to access a corporate website on the internet I would still use Windows Authentication with SSL because it's more secure.", this is for FBA, right?
What is the problme you found out for FBA? the white paper say this also but it just say problem, it didnt' sya what problem it is.
if our staff don't have VPN, then your suggestion doesn't works, right?
Many features won't work with FBA. Specifically the client integration.
Read the following from http://msdn.microsoft.com/
Important:
When you use forms authentication, client integration is disabled by default because client integration does not natively support forms authentication. You might be able to use many client integration features with forms authentication, and there are workarounds available to implement varying levels of client integration functionality with forms authentication. Specifically, starting in the Office 2007 Cumulative Update for April 2009 (Microsoft Help and Support), Microsoft Office Word, Microsoft Office Excel, Microsoft Office PowerPoint, and Microsoft Office SharePoint Designer all have native support for forms authentication, as described in Forms Authentication in SharePoint Products and Technologies (Part 3): Forms Authentication vs. Windows Authentication. If you plan to use client integration with forms authentication, you must fully test any available solutions or workarounds to determine whether the performance and functionality are acceptable in your environment. Microsoft Customer Support can provide commercially reasonable support to help you troubleshoot published workarounds.
Deciding to Use Forms Authentication
Some organizations want to use Windows users and groups in SharePoint Products and Technologies, but enter credentials via forms authentication. Before using forms authentication, determine why to use forms authentication in the first place: What is the business driver? If user accounts are stored in a location other than an Active Directory domain controller, or if Active Directory is not available in a particular environment, using forms authentication with a membership provider is a good choice. But if you want to force logon only via forms authentication, but still use Windows and all of the integrated features it provides, you should consider an alternative such as publishing the SharePoint site with Microsoft Internet Security and Acceleration (ISA) Server 2006. ISA Server 2006 allows users to log on by using a forms authentication Web form, but treats them like Windows users after authentication. This implementation provides a more consistent and compelling experience for end users.
Yes you should use SSL for the sign in page. You don't have to use it for all pages with FBA.
I'm giving you the recommended strategies from Microsoft. I'm sorry you don't understand the solutions however, I know that they are far safer than FBA, will perform better and allow you to use all features.
Business Accounts
Answer for Membership
by: zephyr_hexPosted on 2009-10-05 at 16:04:38ID: 25500673
methods for authentication: om/en-us/l ibrary/ cc2 62350.aspx #section2
/dotnet/wi ndows-form s/configur ing- forms- authentica tion-in-sh arepoint-2 007/
http://technet.microsoft.c
in particular, you may want to look at Forms authentication
http://www.simple-talk.com