Sharepoint Detective work

Today I was looking at a malfunctioning Sharepoint (for enterprise Portar) the problem was that it could not find the database for either configuration or content which meant that it was pretty much screwed. I am not the one who installed this so I did not know there to start looking. Since I am not very proficient in Sharepoint I decided to start from the beginning… Where should the database be located? I tried launching Sharepoint Central Administration… did not work. Tried launching the Sharepoint Powershell Admin console… Could not find farm… I looked in the eventlog… no mention of any SQL Server name…

So I searched around abit online and found the most basic setting… where does Sharepoint expect to find:

SharePoint 2007:
SharePoint Server config database connection string location for SharePoint Server 2007
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.O\Secure\ConfigDb

SharePoint 2010:
SharePoint Server config database connection string location for SharePoint Server 2010
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.O\Secure\ConfigDb

SharePoint 2013:
And for SharePoint 2013…
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.O\Secure\ConfigDb

So this meant that I found the SQL server and could continue troubleshooting…

Links:

https://absolute-sharepoint.com/2013/06/sharepoint-server-config-database-connection-string.html

Uppgredera CompanyWeb i efterhand

När man migrerar till SmallBusiness Server 2011 tar man som bekant en backup av Sharepoint databasen från den gamla servern och återställer den i den nya servern. Man använder sedan följande kommando för att koppla upp databasen I Sharepoint:

Mount-SPContentDatabase –Name ShareWebDB –Webapplication http://companyweb

Om man vill kan man direkt uppgradera utseendet till det nya SP2010 gränssnittet genom att istället köra:

Mount-SPContentDatabase –Name ShareWebDB –Webapplication http://companyweb –UpdateUserExperience

Om man missat detta kan man I efterhand använda följande för att uppgradera:

$web=get-spwebapplication http://companyweb
Foreach ($sites in $web.sites)
{$sites.visualupgradewebs()}

/Johan

Multiple templates for a document library

Today a customer asked me if he could create multiple templates in the same document library (in our case Excel spreadsheet). The answer is of course Yes. Here is how you do it.

  • From the Site Actions menu, select Site Settings.
  • select Site content types.
  • Click the create link at the top
  • Enter the content type name, description, and parent content type. Use the content type “Spreadsheet”,  give it a description.Set the Parent Content Type, choose Document Content Types/Document.
  • Click the OK button to finalize the creation process.
  • Go to Advanced settings.
  • Use for instance Excel to create a template file.
  • Select “Upload a new document template” and browse to the template. Click Upload.
  • Now go to the document library where you want to add the template and click Settings – Document Library Settings.
  • Select Advanced Settings and change “Allow management of content types” to yes. Click OK
  • Under Content Types click “Add from existing site content types”
  • Choose the one you created and click Add and OK

Content types defined at a site level are available to that site and all subsites. It’s recommended that you don’t change the existing content types. 

Links

http://www.officesharepointpro.com/content/890/Creating-and-Using-a-New-Content-Type-in-SharePoint-2007.aspx

I want Sharepoint to open links in a new window

First, open the schema file for the links list feature.  In my case, it was located at:
C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12TEMPLATEFEATURESLinksListLinksschema.xml
In this file there should be two instances of the following:
 
<Column Name="URL" HTMLEncode="TRUE" /><HTML><![CDATA[">]]></HTML>
 
Replace them both with this:
 
<Column Name="URL" HTMLEncode="TRUE" /><HTML><![CDATA[" target="_blank">]]></HTML>

 

Links

http://weblogs.asp.net/bryanglass/archive/2008/03/07/changing-links-list-in-sharepoint-2007-to-open-in-new-browser-window.aspx

Using NLB (Network Load Balancing) with Sharepoint

Today I set up my first NLBd Sharepoint. The problem I had was that when I took down the first installed server the second one did not work. The problem was that the Sharepoint installation did not use the the NLB cluster address, it used the address of the fists server.

 

The solution is called Alternate Access Mapping. You need to change the URL in alternate access mapping to the Cluster URL. Here is how:

  1. Start Central Administration
  2. Go to the Operations tab
  3. Click on Alternate Access Mappings under Global Configuration
  4. You should now see a list of your web applications, switch over to the one you want to map to the new URL by selecting it from the drop down on the right side
  5. Change the default field to the NLB address

 

image

 

Links:

http://blog.henryong.com/2007/01/17/alternate-access-mapping-in-sharepoint/

Enabling Adobe Acrobat in Windows Sharepoint Services 3.0

1. Download the Adobe PDF iFilter 6.0 and install it
2. Download and run the zip mentioned here

Links

http://geekswithblogs.net/sspotts/archive/2006/11/03/96045.aspx
http://www.adobe.com/support/downloads/thankyou.jsp?ftpID=2611&fileID=2457
http://msmvps.com/blogs/cgross/archive/2004/10/26/16679.aspx

Sharepoint Tips and Tricks

Installing Language Pack

  1. Download the Language Pack from here
  2. Install the Language Pack
  3. Run the SharePoint Products and Technologies Configuration Wizard

Note: All sites and site collections created before install the install will not be converted. All new sites can be creted in the new language.

Links

Deploy language packs (Windows SharePoint Services 3.0)
Install available language template packs (Windows SharePoint Services)
Windows SharePoint Services 3.0 Language Pack
Johan Dewes Svenska Sharepoint Blog
Create a subweb (v1.0)
Downloads for Windows SharePoint Services
Windows SharePoint Services 3.0 Technical Library
Administrator’s Guide for Windows SharePoint Services (v2.0)
SharePointCommunity Wiki
SharePoint-Tutorials
Mart Muller’s Sharepoint Weblog

 

Microsoft Office SharePoint Server 2007 VHD

Q I Am Getting An Error When I Am Trying Out Ny New ASPNET Application It Looks Like This FO

Q: I am getting an error when I am trying out ny new ASP.NET application, it looks like this:

Access to the path “C:WINDOWSMicrosoft.NETFrameworkv1.1.4322Temporary ASP.NET Filesdasblog99184a323905a458” is denied.

A: This happens when you promote the server to a domain controller according to this article in the Microsoft Knowledge Base. It says it applies to Sharepoint but it solved my problems with my dasBlog installation.

Link