How To: Change the MOSS Site Port to Port 80

My solution on Social TechNet Forum.

 

Scenario

MOSS 2007 site setup using port 2000, so the URL looked like http://justsharepoint.com:2000

Having such a URL is not a great idea, especially when you have to type in the port number 2000! Why can’t we simply type in http://justsharepoint.com and be done with!!

Read the rest of this entry »

Tip: Recycle IIS Application Pool

As a developer, quite often you may have to recycle the application pool. IISReset is an option, alternatively you can just recycle a particular application pool.

Denny has a tip to just get this done!

cscript c:windowssystem32iisapp.vbs /a “[App_Pool_Name]” /r

Source

HowTo: Set Permissions for Comments on SharePoint Blog

If you want to allow your blog visitors to comment on blog posts you will need to explicitly allow them to do so. To achieve this, you will need to setup unique permissions on your blog.
Here is the procedure:
1. Open http://your_blog_url/Lists/Comments/AllComments.aspx
2. Select Settings > List settings
3. Select Permissions and Management > Permissions for this list
4. Open Actions >Edit permissions (confirm this action when dialog pops-up)

Now you can setup unique permissions for this list. From this step forward you can add permissions for a specific user. The best approach is to give the Visitors group “Contribute” rights for this entire list.

You will also need to limit user’s ability to edit and delete only his comments.
The procedure is as follows:
1. Open http://your_blog_url/Lists/Comments/AllComments.aspx
2. Select Settings > List settings
3. General Settings> Advanced Settings
4. Choose “Only their own? for Edit access option

Source

MOSS 2007 Infrastructure Updates

Microsoft have released Infrastructure Update for MOSS 2007.
The Infrastructure Update for Microsoft Office Servers (KB951297) includes several new Enterprise Search features for SharePoint Server 2007 and the latest performance updates and fixes for the Microsoft Office Servers listed in the system requirements section below.

Key updates for SharePoint Server 2007 include:

  • New Search features such as federated search and a unified search administration dashboard.
  • Several core fixes to Search to improve performance and scale.
  • Platform performance improvements and fixes.
  • Several core fixes to the publishing Content Deployment features to improve reliability.
Download 32 bit version | 64 bit version

The update will install properly if either of the following are true:

It is recommended that you install 2007 Office servers Service Pack 1 (SP1) and the Microsoft Windows SharePoint Services 3.0 Infrastructure Update before you install this update.

Download the 32-bit version of the Windows SharePoint Services infrastructure update together with installation instructions and deployment strategies.

Download the 64-bit version of the Windows SharePoint Services infrastructure update together with installation instructions and deployment strategies.

Howto configure client alias for SQL Server

This post will show you how to configure client aliases for SQL Server. One of the security hardening measures is configuring non-standard port for SQL Server instances.

A default instance of SQL Server listens for connections on TCP port 1433. If a client computer is unable to connect to the database on TCP port 1433, it queries the SQL Server Resolution Service on UDP port 1434.

To protect the database server, you can block the standard ports used by SQL Server and configure your SQL Server instances to listen on a nonstandard port.

Configuring client aliases for SQL Server

0. Open SQL Server Configuration Manager, and expand the SQL Native Client Configuration node.

1. Right-click Aliases, and then click New Alias.

2. In the Alias Name box, type the alias you wish to use when connecting to the database server.

3. In the Port No field, type the port number that you assigned to your SQL Server instance.

4. In the Server field, type the name of your database server.

5. Click Apply, and then click OK.

Alternatively

Start, Run, clicnfg

Enable TCP/IP protocol

Clicnfg


Select properties


Select Alias Tab


Configure client aliases on your WFE servers and application servers using the above steps. You must install SQL Native Client and SQL Server Configuration Manager on each server.

Scripts to backup and restore SharePoint 2007

I can add this to my arsenal of SharePoint Scripts. Just perfect.

FULL_BACKUP.BAT – Use Control Panel – Scheduler to run once a week. Don’t forget the ‘Run As’ account also needs write access to the backup location, in addition to the Central Admin app pool identity, and the SQL Server Machine account. This command will backup the entire farm to the following file share. Don’t use drive:\directory format.

–Start–

“c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm.exe” -o backup -directory \\servername\backupshare -backupmethod full

–end–

DIFF_BACKUP.BAT – Use Control Panel -Scheduler to run when you want differential backups. Remember the same security as above, but also it will fail if you add a content DB or Web App since the last FULL backup.

–start–

“c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm.exe” -o backup -directory \\servername\sharename -backupmethod differential

–end–

IIS_MetaBase_Backup.BAT – This is used to backup your IIS Configs to each IIS server, in their respective ‘metaback’ directories. Just add an additional line for each server you want to backup. It will create a backup of the metabase called ‘WeeklyBackup’ with a version appended. The password doesn’t matter, it just makes the backup portable.

–start–

cscript.exe %systemroot%\system32\iisback.vbs /s servername /u domain\username  /p userpassword /backup /b WeeklyBackup /v NEXT_VERSION /e password

cscript.exe %systemroot%\system32\iisback.vbs /s servername2 /u domain\username  /p userpassword /backup /b WeeklyBackup /v NEXT_VERSION /e password

cscript.exe %systemroot%\system32\iisback.vbs /s servername3 /u domain\username  /p userpassword /backup /b WeeklyBackup /v NEXT_VERSION /e password

–end–

As Ben says, use at your own risk.

Stay tuned, subscribe via email

SharePoint Training on your desktop

Microsoft have now released a desktop version of Microsoft Office SharePoint Server 2007 Training kit. This release is in addition to the server version, which created a site for the training and delivered from your SharePoint portal. With the portal edition, SharePoint/IT administrators are able to track who has used the training, and what trainings they’ve taken.

The Microsoft Office SharePoint Server 2007 Training Standalone Edition is designed to help you learn how to use the features of Microsoft Office SharePoint Server. The Training topics lead you step-by-step through beginning to advanced features, including Collaboration, Business Processes and Forms, Portals and Personalization, Search, Business Intelligence and Enterprise Content Management.

The Training includes videos, interactive tutorials, and articles. The Standalone Edition is accessed through your browser after you install the application on your personal computer.

The Microsoft Office SharePoint Server 2007 Training Portal Edition, built on the Microsoft SharePoint Learning Kit, is designed for server administrators who want to help their end-users learn how to use the features of Microsoft Office SharePoint Server 2007. The Training topics lead the learner step-by-step through beginning to advanced features, including Collaboration, Business Processes and Forms, Portals and Personalization, Search, Business Intelligence and Enterprise Content Management.

The Training includes videos, interactive tutorials, and articles. In addition, the material is SCORM compliant. You can easily add or remove training topics to fit your business needs. The Training also includes a reporting function that allows an administrator/trainer to track learners’ completed training topics. You can customize the Training to fit the look and feel of your own Office SharePoint Server site.

Training topics included

Collaboration

  • Finding your way around a team site
  • Understanding permissions
  • Customizing a team site
  • Linking calendars to Outlook
  • Adding Web Parts
  • Collaborating in libraries, lists, and workspaces
  • Using blogs and wikis to share information

Enterprise Content Management

  • Document management
  • Protecting files
  • Using workflows
  • Records management
  • Creating and publishing Web pages
  • Improving compliance and support litigation discovery

Search

  • Finding files, Web sites, information, and people

Portals and personalization

  • My Sites
  • Targeting content to specific audiences
  • Managing access to your My Site

Business processes and forms

  • Streamlining business processes with forms and workflow
  • Gathering information with browser-compatible forms
  • Designing custom workflows using SharePoint Designer

Business intelligence

  • Sharing Excel workbooks as interactive reports
  • Working with a Report Center site
  • Using dashboards to drive decisions
  • Understanding Filter Web Parts
  • Integrating external data

Download Standalone Edition | Download Server Edition