Error: CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Error:
CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Reason:

You will get this error, when you are trying to create a new SharePoint web application using the ATTACHED DATABASE through the central admin. Because, your central admin user (that is current user to create a website) may not having a permission to create tables dynamically in the SQL Server. 

Solution:

Solution is very simple. Just attach the database in SQL Server using the current user of the central admin as the owner of the DB. (But it takes long time for me to find out the exact reason).

For example, If your current central admin logged-in username is "domain\senthil" (Assumes, senthil is going to create a new web application) , then you should attach the database using the "domain\senthil" username.

You can change the owner of the database during the "Attach databases" as per the below screenshot.

Thats It...

"New" ribbon icon disabled in central admin

Issue:

You cannot see the "New" icon in the Ribbon menu, when you are trying to create any new web application or service through SharePoint 2010 central admin in windows 7 machine.

Reason & Solution

The reason is very simple. The Internet explorer is not opened using the administrator privileges. So, Open the Internet Explorer with "Run as Administrator" privileges. How to do this?

OK, I will explain you the steps here.

1. Just right click on the IE icon.

2. There you can see a menu as "Run as Administrator".

3. In IE, browse the application. You can see the "New" icon in Ribbon menu as below:

Thats it...

Getting Blank page instead of Central Admin after installing SharePoint 2010 in Windows 7

Issue:

You will get a blank page instead of Central admin page when you are trying to access the central admin page after installed and configured the SharePoint 2010 software in windows 7 machine.

Reason:

By default, some of the authentication providers may not be installed in Windows 7 machine (inside IIS). You can check the list of authentication providers by double click on the central administration site in IIS. See the sample screenshot below.

If you double click in the "Authentication" link as I specified in the above image, you cannot see the below authentication mechanisms:

1. Windows Authentication

2. Basic Authentication

3. Digest Authentication

If they are existing, they may not be enabled.

Solution:

To add these authentication mechanisms in IIS, open the Command Prompt and type the below command. Then, wait for 2 minutes.

Command

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ManagementScriptingTools;IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility;IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation;WCF-NonHTTP-Activation

The command will be executed and you can see in IIS that these authentication mechanisms will be added. See the sample screenshot below:

Please make sure that the Windows Authentication should be enabled to access the SharePoint 2010 central administration page.

So, now you can browse the central admin page instead of blank page.

Thats it...

Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencie

Error:

Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Reason:

"Windows identity foundation pack" may be missed from your machine.

Solution:

Download the pack from http://www.microsoft.com/downloads/details.aspx?FamilyID=eb9c345f-e830-40b8-a5fe-ae7a864c4d76&displaylang=en and install it in your Windows 7 machine.

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on ....

Error:

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly 'System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Reason:

You will get this error, when you are trying to configure the SharePoint 2010 central admin (SharePoint product configuration wizard). The reason behind the error is, you might not installed the "Chart Control" in your windows 7 machine.

Solution:

So, download the chart control from http://go.microsoft.com/fwlink/?LinkID=122517 and install it.

Thats it...

The specified SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=MSSQL2008 has been upgraded to a newer version of SharePoint.

Error:

The specified SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=MSSQL2008 has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

Reason:

This error may occur, if you are trying to attach the SQL server 2008 "MDF" file in SQL Server 2008 (No typo :) ) and the SharePoint Version is MOSS 2007 with no service packs.

Solution:

Just install the WSS service pack 2 & MOSS service pack 2. Now, you can attach the database without any issue.

For more info, refer my another post here

Thats it...

Issue: "Create or extend web application" link is missing in Central Admin

Issue:

"Create or extend web application" is missing in Central Admin.

Reason:

1. Because, the current browsing user may not have the rights to create the Web application.

2. You may be browsing within "Windows Server 2008"

3. You may be browsing within the MOSS server

Solutions:

Solution 1:

Browse the Url from outside MOSS 2007 server

Solution 2: (Suggested solution)

1. Right click on the browser icon.

2. Select "Run as Administrator" option.

3. Now, go to the central admin url and you can see the "Create or extend web application" link.

Thats it.