sharepointstuff's blog

I. Note the database names for the Windows SharePoint Services Configuration and Content databases. To do this: a. Stop the Default Web Site on the WSS server in IIS. b. On the Windows SharePoint Services server, go to Start , Administrative Tools , SharePoint…(read more)

The following information may help you with your IIS sites you plan to migrate to Windows Server 2003 SP1 with IIS 6.0. 

KB Articles

Disable the loopback check

Windows Server 2003 SP1 include a loopback check security feature that is designed to help prevent reflection attacks on your computer. Therefore, authentication fails if the FQDN that you use does not match the local computer name.

You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or IIS 6

http://support.microsoft.com/default.aspx?scid=kb;en-us;896861

Users receive an authentication prompt, enter their user and password credentials, then get prompted two more time and failing to a 401.2 error.

IIS log files were reporting failure on all files listed in the virtual directories under the site

Cause

The virtual directories and files permissions are not being inherited by the site. 

Workaround

Set the site’s Directory Security to Basic Authentication to push inheritance, and then set back to Integrated Windows authentication. You should receive a prompt to propagate permissions to the virtual directories. If so, select all then OK.  You may receive this prompt one more time. Try to access the site to see if you can access the site without a login prompt.

If the problem continues, remove all permissions on the Web Sites directory’s Directory Security.  You should receive a prompt to propagate permissions to the virtual directories. If so, select all then OK.  You may receive this prompt one more time. Once the permissions are inherited to all sites and virtual directories, set the Web Sites directory back to Enable anonymous access. Try to access the site to see if you can access the site without a login prompt.

Enabling HTTP Keep-Alives (IIS 6.0)

Most Web browsers request that the server keep the client connection open while the server sends multiple elements (.htm files and .gif or .jpeg files) to the client. Keeping the client connection open in this way is referred to as an HTTP Keep-Alive. Keep-Alive is an HTTP specification that improves server performance. HTTP Keep-Alives are enabled by default.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/d7e13ea5-4350-497e-ba34-b25c0e9efd68.mspx

IIS 6.0 References

Frequently Asked Questions About IIS 6.0

http://www.microsoft.com/windows2000/community/centers/iis/iis6_faq.mspx

Interne Information Services (IIS) 6.0 Resource Kit

(THIS ONE IS A GREAT RESOURCE!!!!)

http://www.microsoft.com/downloads/details.aspx?FamilyID=80a1b6e6-829e-49b7-8c02-333d9c148e69&DisplayLang=en

Default permissions and user rights for IIS 6.0

http://support.microsoft.com/?id=812614

401.1 and 401.2-Authentication Problems (IIS 6.0)

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/8feeaa51-c634-4de3-bfdc-e922d195a45e.mspx

Authentication may fail with "401.3" Error if Web site's "Host Header" differs from server's NetBIOS name

http://support.microsoft.com/?id=294382

You receive an "HTTP Error 401.1 – Unauthorized: Access is denied due to invalid credentials" error message when you try to access a Web site that is part of an IIS 6.0 application pool

http://support.microsoft.com/default.aspx?scid=kb;en-us;871179

Configuring Launch Permissions for COM+ Server Objects (IIS 6.0)

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/fd24c76b-a8d7-4033-8e31-6dbe236d92f7.mspx

Application Launch Issues (DCOM)

http://support.installshield.com/kb/view.asp?articleid=Q104986

Improving Performance of IIS 6.0 Applications (Reid A Blog)

http://reidablog.blogspot.com/2005/07/improving-performance-of-iis-60.htm

DNS References

Fixing Replication DNS Lookup Problems (Event IDs 1925, 2087, 2088)

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/Operations/43e6f617-fb49-4bb4-8561-53310219f997.mspx

IIS 6.0 Troubleshooting Tools

AuthDiag 1.0  http://msmvps.com/bernard/archive/2004/09/02/12722.aspx

IIS Log Files – Start=>Run=>Type logfiles=>Go To directory that hosts IIS site

Fiddler – HTTP Debugging Proxy Tool – http://www.fiddlertool.com/fiddler/

For Detailed information on the following tools, see 24_CHAPTER_11_Troubleshooting_IIS_6.0.doc of the Internet Information Services (IIS) 6.0 Resource Kit

http://www.microsoft.com/downloads/details.aspx?FamilyID=80a1b6e6-829e-49b7-8c02-333d9c148e69&DisplayLang=en

WFetch (WFetch.exe). This tool allows you to generate customized HTTP requests and view request and response data.

Microsoft Network SMS Network Monitor (NetMon2) Captures Network Traffic

File Monitor (FileMon.exe). This tool allows you to view and capture real-time file system activity.

Registry Monitor (RegMon.exe). This tool allows you to view and capture real-time system registry activity.

IIS Enterprise Tracing for Windows. This tool allows you to enable tracing for various providers. IIS includes a set of providers that can be used to troubleshoot various internal processes in addition to application performance. IIS Enterprise Tracing for Windows is new in Windows Server 2003. Logman.exe and Tracerpt.exe are the tools used to enable IIS ETW tracing.

Network Monitor. This network tracing utility allows you to view activity in the network stack. Network Monitor is included with Windows Server 2003.

System Monitor. This tool allows you to view and collect system performance data. System Monitor is included with Windows Server 2003.

HRPlus. This tool provides error lookup functionality.

Microsoft Debugging Tools for Windows. This tool allows you to debug and diagnose application problems.

Hopefully this will help you out.

I have been thinking about how to manage projects.  There is of course, MS Project, but I am talking about all the projects and tasks that I need to keep track of.  On a given project, if I am managing the project, I try to use tools to keep track of everything: Phase the project out, break tasks into smaller tasks, etc.  The tools I may use range from a network drive for my files, OneNote, SharePoint Issues List: Sorted by priority, and emails.

SharePoint is great for collaboration, MS Project is great for projects, but there doesn’t seem to be a tool that I have seen that will allow me to manage all of my projects both small and large, tasks, ideas, etc.  I’m looking for a one stop shop.  I have been pondering on making a SharePoint Project Dashboard that all departments can use.  I have some ideas, but I thought I would put my thoughts out there and get some feedback on what others are doing.

Please feel free to send me ideas or how you manage all your projects.  It seems to be the missing tool that most people would use.

I started working on my Project Dashboard, and I’ll post my results when I’m done.

Thanks,

~Brian

I wanted to send out a reminder for the Sharepoint User Group meeting that will be held tomorrow!

Our next SPS User Group meeting is scheduled for TOMORROW May 12th from 12-1:30pm, and back by popular demand is your fellow user group member Brian Carlson!   Brian will lead a focused discussion/demo around Sharepoint and FrontPage integration.  The detailed agenda includes:

Noon-1pm: In-depth look at Sharepoint/FrontPage integration

• WSS Customization
• Web Part Customization
• Web Part Connections
• Conditional Formatting
• Web Part Zones
• Converting Web Parts to XSLT
• and more …

1pm-1:30pm: Q&A

The meeting is located at One Market Suite 200 in San Francisco.  Directions to Microsoft’s San Francisco office can be found here:

http://www.microsoft.com/mscorp/info/usaoffices/northernca/sanfrancisco.asp

For those of you who can not make it in person, the live meeting information is included at the bottom of this email.

For additional information regarding the Sharepoint User Group, please visit our website:

http://nbaysps.sharepointsite.com/default.aspx

Thanks,

Angie Hammell

Microsoft Corporation

Information Worker Technology Specialist

Northern California

angelham@microsoft.com

310-920-7503

-+—–+—–+—–+—–+—–+—–+—–+—–+-

Angela Hammell has invited you to attend a Microsoft Office Live Meeting.

Join Meeting

This Office Live Meeting invitation is a personal invitation meant only for you. 
It should not be forwarded.  If you received this email by mistake or
require Live Meeting Assistance, please refer to the Live Meeting Assistance Center at
http://r.office.microsoft.com/r/rlidLiveMeeting?p1=7&p2=en_US&p3=LMInfo&p4=support

Take your meetings live! Microsoft Office Live Meeting is an industry leading real-time web collaboration service and you can see for yourself with our 15 day FREE TRIAL! Click on:
www.microsoft.com/meetlive
to sign up now! Or, for more information, visit:
www.microsoft.com/livemeeting.

Bay Area SPS USer Group – http://nbaysps.sharepointsite.com/

Next User Group Meeting – SharePoint and FrontPage Integration
by Angie Hammell

May 12th from 12:00PM to 1:30 PM – The Landmark @ 1 Market, Suite 200 (Microsoft SF Office)

Our next user group meeting will be held on May 12th, and back by popular demand is your fellow user group member Brian Carlson!   Brian will be presenting the integration between Front Page and Sharepoint.  He will focus on the following topics:

I had a request for a complex form that needed to have questions appear based on how the user answers questions. 

With a standard form you would need to create multiple forms for each scenario.  Using the following instructions, you can sink your multiple scenarios into one form.

This form is like a mini knowledge base or decision tree. The top questions of the form are for information gathering, then a key question or (Branch Question) is asked that determines the path the user takes.  In my form, there is one top-level Branch Question and depending on the path, the users are asked several other Sub-Branch Questions taking them on different paths within one path.

I created this form using components form my previous Blogs entries and then adding the Branch Questions. I used the Branch Questions with Hidden Sections and Conditional Formatting Rules for questions and answers.  I thought I would be able to use the Hide this control option, but this option only grays out the radio button but not the Value when selected: field.  I found the answer by adding questions that I want to hide in a section, and hiding the section based on the rules I created. By default, I hide all hidden sections.  Once a user selects an answer on a Branch Question the question(s) in the hidden section appears.  If they deselect the answer, the question(s) is hidden again.

The mini knowledge base or decision tree based form is very confusion trying to get it to work properly.  I suggest you Visio the form out using if then paths.  This will help you work out the rules.

Path A:

Top-Level Branch Question: Which path would you like to take?

·        A

·        B

·        C

·        D

Section (Not Hidden)
Sub-Branch Question 1: If A is selected un-hide this Section

·        a

·        b

·        c

·        d

Section (Hidden)
Sub-Branch Question 1: If a is selected hide this Section

Sub-Section (Not Hidden)
Sub-Branch Question 2: If b is selected un-hide this Section

Section (Hidden)
Sub-Branch Question 2: If B is selected hide this Section

Section (Hidden)
Sub-Branch Question 3: If C is selected hide this Section

Section (Hidden)
Sub-Branch Question 4: If D is selected hide this Section

Path D:

Top-Level Branch Question: Which path would you like to take?

·        A

·        B

·        C

·        D

Section (Hidden)
Sub-Branch Question 1: If A is selected hide this Section

Section (Hidden)
Sub-Branch Question 2: If B is selected hide this Section

Section (Hidden)
Sub-Branch Question 3: If C is selected hide this Section

Section (Not hidden)
Sub-Branch Question 4: If D is selected un-hide this Section

·        a

·        b

·        c

·        d

Sub-Section (Not Hidden)
Sub-Branch Question 4: If d is selected un-hide this Section

How to Hide Sub-Level Branch Questions that reside in sections:  This can be tedious.

How to hide all sections by default: Using Path A

1.      Add a Section control to the form.

2.      Add your Sub-Branch Question inside the Section. (i.e. Sub-Branch Question 2: If B is selected hide this Section).

3.      Double click on the Section to access Section Properties.

4.      Click on the Display Tab.

5.      Click on the Conditional Formatting… button.

6.      Click Add…

7.      Under If this condition is true: Select the Top-Level Question field.

8.      Then select Is blank.

9.      Check the Hide this control then click on OK.

How to hide Sub-Branch Questions that are not selected at the Top-Level Branch Question: Using Path A

1.      Add a Section control to the form.

2.      Add your Sub-Branch Question inside the Section. (i.e. Sub-Branch Question 2: If B is selected hide this Section).

3.      Double click on the Section to access Section Properties.

4.      Click on the Display Tab.

5.      Click on the Conditional Formatting… button.

6.      Click Add…

7.      Under If this condition is true: select the Top-Level Branch Question field.

8.      Select Is equal to.

9.      Select answer (B) to the Sub-Level Branch Question that you want to hide the corresponding Sub-Branch Question. (i.e. Sub-Branch Question 2).

10.  Select “or”.

11.  Then repeat steps 7 through 10 for each answer to the Top-Level Question (C and D).

12.  Then select Is blank.

13.  Check the Hide this control then click on OK.

How to hide Sub-Branch Questions that are not selected at the Sub-Level Branch Question: Using Path A

To create a Sub-Branch within a Sub-Branch you need to add multiple sections.  Each section will host the same question, but the answers will be different.  I named the sections by question name and Option 1, 2 and 3.

1.      Add a Section control to the form.

2.      Add your Sub-Branch Question inside the Section. (i.e. Sub-Branch Question a: If B is selected hide this Section).

3.      Double click on the Section to access Section Properties.

4.      Click on the Display Tab.

5.      Click on the Conditional Formatting… button.

6.      Click Add…

7.      Under If this condition is true: select the Sub-Level Branch Question field.

8.      Select Is equal to.

9.      Select answer (a) to the Sub-Level Branch Question that you want to hide the corresponding Sub-Branch Question. (i.e. Sub-Branch Question 1).

10.  Select “or”.

11.  Then repeat steps 7 through 10 for each answer to the Sub-Level Question (c and d).

12.  Then select Is blank.

13.  Check the Hide this control then click on OK.

 I hope this helps!

~Brian

Perÿthe request ofÿ Pedro Serrano, I took a screen shot of my SharePointÿhome page.to support the following Blog entries.ÿ

InfoPath Submit Button: File Naming Conventionÿ- Monday, August 23, 2004

InfoPath Job Request Formsÿ- Tuesday, August 17, 2004

This shot displays three web parts that are connected andÿformatted in FrontPage 2003,ÿÿI erased aÿfewÿitems, but youÿwill get the idea.ÿÿAll this infomation is generated on the fly based on current jobs submitted with InfoPath forms.ÿ

ÿ

ÿÿÿÿ

~Brian

ÿ

ÿ

I added a Submit button at the bottom of myÿInfoPath form.ÿÿInfoPathÿallows rules, so I used theÿfollowing rules:ÿ“Submit using data a connection” and “Close this form: No Prompt.”

Using the “Submit using data a connection”ÿI added this formula – concat(RequestBy, "_", Project, "_", today()) – to create a custom naming convention for my form to distinguish the forms in a list.ÿSample: Brian Carlson_Project_2004-23-2003.xml. ÿThen I used “Close this form: No Prompt.” to close the form after the Submit button has been pressed.

NOTE: RequestedBy and Project are fields I added to the form.ÿ You can use what ever fields make sense for the naming convention for your form.

ÿ~Brian

I've been busy, and haven't had time to Blog. .I have been playing around with InfoPath, and I like it.

I created a complex form forÿjob requests that have various stages of approval.ÿ We enabled the Event Handler for the form library, so any changes made to the form will trigger emails to all parties involved providing the fields that have been completed in the form.

When an InfoPath form created, you now have access to the form as a web part.ÿ I simple added the web part several time to the team site's home page.ÿ I used FrontPage 2003 to expose the current jobs sorted by date and priority.ÿ The remaining web parts simply state the schedule and the tasks.ÿ Using web part connections, I linked the schedule and the tasks to the open job requests web part.ÿ This allows usersÿto see a quick dashboard ofÿthe jobs.ÿ They can click on the open jobs and see the details of the schedule and tasks without opening the InfoPath form.

More to come on InfoPath forms.

~Brian

ÿ

ÿ

SharePoint is great when it comes to one stop shop for updating lists.  When creating a WSS site, navigation to team sites, common links are needed on many sites within and outside a site collection.  I created a Quick Links web part by creating a custom list with Category (Text), Sub Category (Text) and reference (Hyperlink).  I collapse the list by Category show Sub Category and Reference.  Once the Quick Links web part is to my liking, I open a site within or outside the site collection, and can use the Data Catalog in FrontPage 2003, by clicking on Manage catalog…, then entering the site name and URL to connect to all items from that site.  Using FrontPage I have to modify the web part to my liking, but once this is setup, the Quick Links is updated in one site, and all sites the Quick Links is added two is a read only version and updated on the fly.  This will reduce the time needed to update each Quick Links on the other sites.

 
1. Adding a Read Only copy of Quick Links to another WSS site.
2. Create a Quick Links using a custom list.  See my “Creating Quick Links” Blog
3. Link the sites using the Data Source Catalog: