Danushka Silva

It's all about SharePoint

July 2010 - Posts

Error: “Cannot access the local farm” – PowerShell command error

When working with PowerShell I got an error. First I thought I am making some kind of a  mistake because I am new to this as well smile_regular

PowershellError 

So I was struggling to make it happen and finally figured it out. The solution was to have administrator privileges to run PowerShell. So when you want use PowerShell don’t just click on it. Right click and Run as Administrator

PowershellError2

Bingo! Now you can use it.

PowershellError3


Please add a comment if you use this code or it helped you. So I can make my posts better.

Error: “SQL server has an unsupported version” when installing SharePoint 2010

This error message came when I was installing SharePoint Server 2010. You might not get this error all the time so first I’ll explain my environment which I tried to install SharePoint 2010. My OS was Windows Server 2008 R2 Standard 64-bit (6.1, Build 7600) and SQL Server 2008 Standard x64. So I started with SQL server which was a smooth installation and then started the SharePoint Server 2010. The setup installation went smoothly. But when it comes to the SharePoint 2010 Products Configuration Wizard, it asked the database server and credentials. So I gave the same name and credentials which I installed before. Then the error came

SP2010-Sql2008 error New

So I download the SQL Server 2008 Service Pack 1 and installed, restarted and tried again. Then I got the same error but the version number was different.

SP2010-Sql2008 error2 New

Went through everything again and finally found the solution. It was to install the Cumulative update package 2 for SQL Server 2008 Service Pack 1 on SQL server 2008.

Here are the links

SQL Server 2008 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en

Cumulative update package 2 for SQL Server 2008 Service Pack 1
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=970315&kbln=en-us


Please add a comment if you use this code or it helped you. So I can make my posts better.