Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sharepoint Enabled Website for FrontPage DataView Access

Posted on 2004-09-26
5
Medium Priority
?
649 Views
Last Modified: 2008-01-09
Hi all. Hope you are well.

Windows 2003 Standard Edition running Office Sharepoint Portal Server 2003.

I recently decided to setup a small web hosting server for particular clients, which thanks to EE help is running like a charm! (http://www.experts-exchange.com/Web/Web_Servers/IIS/Q_21054672.html)

However,

One of my client now want to make full use of FrontPage 2003, including the ability to Insert Data View. On consultation with MS it was pointed out the the server needs to be running Sharepoint Portal in order to do that. Okay, so after many $$$ for a licence I have it installed and running. Using the Wizard (IIS) and Administration tools in Sharepoint Central I can reletavily easily setup a SharePoint Site. All content provided by the wizard.

But, my client does not want a Sharepoint "Looking" site. They want to extend their sites functionality by including database access (mdb) and other bits and pieces, and in turn making use of FrontPage to do this!

My problem (finally ;-) is the following:

a) I cannot "surf" the site without being asked for Authentication (anonymous turned on - take off Windows - give me all sorts of 401.2 errors)
b) I dont want to have the default sharepoint content installed. (not an issue - can remove - i think - manually)

So, is their away of just enabling sharepoint services on a web site so that the client can make use of his FrontPage 2003 dataview? I've tried to include just the ISAPI sharepoint filter but this doesn't seem to work. I get the feeling this sharepoint thingy is really for "intranets"...

Any advice. Thanks
Sean
0
Comment
Question by:SeanNij
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:alimu
ID: 12156748
The authentication issue:
The Sharepoint Portal works by checking out who you are and then delivering appropriate content.  If you don't want full functionality you could probably use anonymous but would need Windows Auth or Basic enabled as a backup for when you're doing administrative tasks or accessing resources that the anonymous account doesn't have access to.

The "default content" issue:
Sharepoint essentially gives you a pre-configured web infrastructure.  I'm not sure that manually deleting sharepoint content is going to do you much good because the content in there is what allows you to access Sharepoint functionality.
There are a number of resources available on MSDN that discuss how to customise Sharepoint Portal Services to suit you.
They are mainly concerned with configuring your own stylesheets, templates and building web parts to show customised content.  These are 3 overview documents that might give you an idea on how to get in there and customise it.
Part 1:  http://msdn.microsoft.com/office/understanding/sharepoint/articles/default.aspx?pull=/library/en-us/odc_sp2003_ta/html/odc_spscustomizingsharepointsites1.asp
Part 2:  http://msdn.microsoft.com/office/understanding/sharepoint/articles/default.aspx?pull=/library/en-us/odc_sp2003_ta/html/odc_spscustomizingsharepointsites2.asp
Part 3:  http://msdn.microsoft.com/office/understanding/sharepoint/articles/default.aspx?pull=/library/en-us/odc_sp2003_ta/html/odc_spscustomizingsharepointsites3.asp

The "data view" issue:
This article goes through the steps to create a dataview in a sharepoint site
http://msdn.microsoft.com/office/understanding/frontpage/default.aspx?pull=/library/en-us/odc_fp2003_ta/html/odc_fpparameterbinding.asp
The article doesn't say anything about sharepoint portal services.  It only says sharepoint services (i.e. this one: http://www.microsoft.com/windowsserver2003/techinfo/sharepoint/overview.mspx downloadable for free).
What the Portal services version does allow you to do is to index and use resources elsewhere on your network however so this may be why it was recommended.    Hopefully this is what you required or you may have just spent a large sum of money when you didn't need to.
0
 
LVL 1

Author Comment

by:SeanNij
ID: 12168534
WOW, thanks for that.

So heres the deal. New Server. New Windows 2003, SQL 2000 Plus Service Pack 3, Windows Sharepoint Services 2.0 installation - default - no funny setting - network configured.

IIS Add New Website.
Extend it through the Windows Sharepoint Services and great - first time i log on asks for template.

When i try view the site now as if i was a usual web site surfer persin somewhere on the net, I get asked for Windows Authentication. Okay, so in IIS, remove integrated authentication and tick Anonymous.

Now when I surf to the site I get. Access denied You do not have permission to perform this action or access this resource.

All i want is for my clients using my Server as a hosting server to be able to make full use of their FrontPage 2003.....

Any more suggestions...
0
 
LVL 14

Accepted Solution

by:
alimu earned 1600 total points
ID: 12175464
ok - the "The authentication issue" section of my last post applies to sharepoint services as well as sharepoint portal services.  To allow development and administrative tasks to occur while still allowing anonymous browsing you'll need to have anonymous ticked along with an NT authentication type.  
If your administrators and developers are located in the same domain you can use integrated.  
If your administrators and developers are accessing the site over the internet you will need basic authentication.

I'm using the 2000 version so I'm hoping these locations will all be the same for 2003.  Hopefully someone will correct me if I'm off target.
Administration pages(you'll need to have integrated or basic turned on to get into this):
http://YourWebDNSname/_vti_bin/_vti_adm/fpadmdll.dll

Under "users and roles" you need to enable anonymous access to your site via the "change anonymous access settings" link.
You can also add domain users and groups through "manage users" (or alternatively, create local accounts here).  This interface also lets you assign each user/group with a role on the website.  

After you have your user configuration sorted out, you can double-check everything's healthy using the "Check Server Health" link from the same admin page.  This tool will even reset NTFS security to match what you've configured.

The help file that comes with sharepoint is a decent enough guide to doing the basics.  There should be a link to it from the menu at the top of the admin page.

If you look in the IIS management console on your server, there should be another web sitting there (you've probably already seen it to extend your webs) called "Sharepoint Administration Web".  This is where you setup server-wide installation defaults including usage processing, server health checks, subscriptions, database connections.  Just check to make sure it's all setup the way you want it.

This is probably as clear as mud :) If you've got any more questions just yell.
0
 
LVL 1

Author Comment

by:SeanNij
ID: 12186936
What can I say? You are a legend! Thankyou!

Sean
0
 
LVL 14

Expert Comment

by:alimu
ID: 12187412
no problem... i spent ages trawling through whitepapers trying to migrate a sharepoint site server to server once... that's pretty much as ugly as it gets :)
glad to help.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
Debug Tools to analyse IIS process: This article focus on taking memory dumps from IIS to determine which code is taking more time and to analyse which calls hangs/causes more CPU usage. To take dumps,download the following. Install1: To st…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question