SharePoint 2007 Issues and ResolutionsIssue:Accessing Company Sharepoint Site from internal LAN using IP address or Domain name Scenario:SharePoint intranet site called “mynews” is setup on port 8098 in one of the company’s internal server, and assigned a domain name, “moss.intranews.com”. The company’s off-shore team when try to access the site by URL (http://10.20.130.140:8090/) from their workstation, browser shows “page not found” or HTTP 404 error”. Solution:1. Access SharePoint 2007 Central Administration web page.2. Click on Operations tab3. Click on “Alternate access mappings” from Global Configuration section4. Click on Add Internal URLs5. Enter http://10.20.130.140:8090/6. Set to “Intranet”7. Restart the IIS Now try to access the site with IP address and should work. Alternate access mappings provide a mechanism for SharePoint administrators to identify the different ways in which user’s access portal sites, ensuring that URLs (links) are displayed appropriately for the manner in which the user accesses the portal site. Export and Import a SharePoint SubsiteHad a situation recently where I needed to take a backup of a Wiki subsite and restore it on another SharePoint site collection's subsite residing on a different farm. In WSS 3.0, there are two new STSADM commands - import and export.The basic procedure to restore the subsite was to STSADM export the site to a file and then STSADM import it to new site collection's sub site. Note: The toplevel site is http://sspserver1:4500/ and the subsite is http://sspserver1:4500/Wiki/ Export subsitestsadm -o export -url http://sspserver1:4500/Wiki/ -filename d:\DatabaseBackup\Wiki.bak -includeusersecurity -versions 4 Import subsitestsadm -o import -url http://sspserver2:4500/Wiki/ -filename d:\DatabaseBackup\Wiki.bak -includeusersecurity A couple of things to note:The -includeusersecurity switch ensures that all the columns such as modifed by, created by are maintained.The -versions 4 switch will ensure that all versions of list items/documents are exported. You must import/export to sites that share the same template. So a team site can only be exported and imported into another team site. You will know you are trying to import into non matching templates if you get the following error: "The exported site is based on the template STS#1 but the destination site is based on the template STS#0" This means that a site based on the blank template is trying to be imported into a site based on the team template.To my knowledge there is no easy way of changing a sites templates. The following lists some of the common WSS templates:Team Site STS#0 Blank Site STS#1 Document Workspace STS#2 Wiki Site WIKI#0 Blog BLOG#0 Error Message while Importing a sub site. A list, survey, discussion board, or document library cannot have the same name as another list, survey, discussion board, or document library in this Web site. To avoid the above error message while using STSADM import, create a subsite by choosing Blank Site template and then run the above stsadm import command. A list, survey, discussion board, or document library cannot have the same name as another list, survey, discussion board, or document library in this Web site. To avoid the above error message while using STSADM import, create a subsite by choosing Blank Site template and then run the above stsadm import command. Please use an unused port for this site error in Central Admin SiteMy Central Administration site in MOSS environment was giving me following error message after restarting the server.IIS was unable to start this site. Another site may already be using the port you configured for this site. Please use an unused port for this site. Looks like changing the port number through IIS won’t do any good.You will have to do this through the command line. First navigate to following location C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN You need to use STSADM with setadminport parameterType stsadm.exe -o setadminport –port [port number] Server Farm Configuration Not Complete I was getting above error message in bright red text on left hand top corner in my Central Administration page. I made sure following services are all running,Document Conversions Launcher Service Document Conversions Load Balancer Service Office SharePoint Server Search Windows SharePoint Services Help Search Windows SharePoint Services Incoming E-Mail Windows SharePoint Services Web ApplicationThen I check on the Check Services Enabled in this Farm page (Central Administration > Application Management > Check Services Enabled in this Farm) to identify any errors. Its fine too.Then I had to finally create the Shared Services. This make the error message disappear. Could not load XSL file. The system cannot find the file specified In attempting to setup the content query web part on a MySite, after exporting the web part and re-importing it to the MySite site I then got a "Could not load XSL file. The system cannot find the file specified" error. Go to site settings of MySite and enable the "Office SharePoint Server Publishing Infrastructure" site collection features. Now the content query web part would start working.Invalid or loopback address error I was trying to install MOSS on a SQL server environment and received above error message. The SQL Server database was installed on non default TCP port. So I need to type something like “Database Server name, TCP port” when I try to create the configuration databases. But it was failing with above error.I had to update database TCP port to default 1433 port to get SharePoint successfully installed.Changing Passwords for Office SharePoint Server Accounts with STSADMServer Farm AccountTo update the server farm account, run the following stsadm command on the server that hosts the Central Administration Web site.stsadm –o updatefarmcredentials –userlogin -password You must then run the iisreset /noforce command to restart the application pool.If you encounter a Service Unavailable error when you try to access the Central Administration Web site, you must also run the following stsadm command on every other server in your server farm.stsadm –o updatefarmcredentials –userlogin -password -localOther Application Pool AccountsTo update the application pool account, run the following stsadm command on the server that hosts the Central Administration Web site.stsadm –o updateaccountpassword –userlogin -password -noadminYou must then run the iisreset /noforce command to restart the application pool.Search Service AccountsYou can use the following stsadm command to update the password for the Office SharePoint Server Search service.stsadm –o osearch –farmserviceaccount -farmservicepassword Alternatively, you can reconfigure these accounts by using the Shared Services Administration section of the Central Administration Web site.Shared Services Provider AccountsIf you change the password for an SSP account, you must update the account details by using either the Central Administration Web site or the stsadm command-line tool. You can use the following stsadm command to update an SSP account.stsadm –o editssp –title -ssplogin -ssppassword You must then run the iisreset /noforce command to restart the SSP service.The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. Central Administration > Application Management > Authentication Providers > Edit AuthenticationEnable Client Integration? - Choose "Yes" Above steps would resolve following 2 issues:1. Users will see from any List "Edit in Datasheet"2. Users will be able to see from Site Actions -> Create -> Custom List -> Import Spreadsheet To export a list, you must have a Windows SharePoint Services-compatible application.From SharePoint List, when I try to export a list to Excel, above error message is displayed.Internet Explorer is trying to use one of the OWSSUPP.DLL, so unregister one of them and try to export the list to Excel.c:\Program Files\Microsoft Office\OFFICE11\OWSSUPP.DLLc:\Program Files\Microsoft Office 2007\OFFICE12\OWSSUPP.DLLCannot connect to the server at this time. Your list cannot be publishedThis error is caused because some properties are not set properly in IIS.Right click on website SharePoint is running onSelect HTTP Headers TabEnsure you have the following properties in the Custom HTTP headersName : MicrosoftSharePointTeamServicesValue : 6.0.2.5530Restart IISShared Services Admin Site Access Denied Error I am taking over as the SharePoint Administrator, meaning I am working with another person creation. Everything has been okay, expect when I try to go to Shared Services. I have no idea what account was used to create this SSP because every account I try to log in with I keep getting an Access Denied error. Any ideas on how to gain access to this site?If you have administrative rights on the server, you can give yourself permission to get into the Shared Services.Central AdministrationApplication ManagementSite Collection Administrators,change to the site collection for the Shared Services administration (you will have to change the web application as well), and make yourself the primary or secondary site collection administrator.
