Unknown SQL exceptions - Event 5586

Unknown SQL exceptions - Event 5586

Alert Name:   Unknown SQL exceptions

Event ID:   5586

Summary:   Microsoft SharePoint Foundation uses Microsoft SQL Server 2008 databases to store configuration settings and most of the content for the Web site. For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server 2008.
Microsoft SharePoint Foundation uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name or password (domain name and password), or a predefined system account, such as Local System or Network Service. When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application might be associated with one or many databases.

Symptoms:   The following symptom might appear:

·         This event appears in the event log: Event ID: 5586 Description: Database full error on SQL Server instance <instance name> in database <database name>. Additional error information from SQL Server is included below. <SQL error message>.

Cause: The issue is because of many reasons, below are some of the reasons

1.    Insufficient SQL Server database permissions

2.    SQL Server database is full

3.    Incorrect MDAC version

4.    SQL Server database not found

5.    Incorrect version of SQL Server

6.    SQL Server collation is not supported

7.    Database is read-only

Solution: The issue could be of many reasons so it has many different solutions that should implement to resolve the issue. One of the solution would be your saver.
Please check the link below from MS to get the solutions.

 https://technet.microsoft.com/en-us/library/ee513056%28v=office.14%29.aspx

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

How the user authentication works between share point and AD

 How the user authentication works between share point and AD

In this article I am providing the details of How the authentication process works between the share point and the AD.

1.   Client hit SharePoint site

2.   SharePoint redirects client to Identity Provider (AD) in order to get a security token

3.   Client attempts to authenticate to trusted Identity Provider (AD)

4.   The identity provider's (Security Token Service) will validate the username and password and provide a security token to a client.

5.   The client has a security token (authenticated) and submits it to SharePoint STS "Security Token Service"

6.   SharePoint STS receives security token from client and determines if we trust the issuer of that token "Identity Provider"

7.   STS then performs claims augmentation

8.   STS issues client new SAML token

9.   Client request resource "site" with new SAML token

10.   SharePoint consumes SAML token, "validates authentication successful", and builds an SPUser object in order to authorize to the secured resource

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Powershell Commands in daily use

PowerShell Commands in daily use

1.   To add SharePoint module in windows power shell

Add-pssnapin  Microsoft.sharepoint.powershell

2.   To add IIS module in windows power shell

Import-module web administration

Help Commands:

1.   Get-help

2.   Get-help *backup*( *get all the commands of backup, we can change this by different nouns)
     Get-Help Get-SPSite -Full
     Get-Help Get-SPSite -examples( Provides all the Examples of commands)

3.   Get-verb(to get all the verbs)

4.   Get-command(to get all the commands)
     get-command - noun sp*( to get only commands of SP)
     get-command -verb get*(to get only commands of get)....EX set*, update*

5.   Get-command –pssnapin Microsoft.sharepoint.powershell(to get only SharePoint commands)

6.   Commands will normally start in  verb-noun

7.   Show-command( shows all the commands in new window)

8.   The noun for sharepoint cmdlets will always starts with SP.

9.   gcm -verb get  –noun sp*( gives all the get sharepoint cmdlets).gcm is alias for get-command

10.           gcm  get-sp*( gives all the get sharepoint cmdlets)

11.           help get-spsite(provides the syntax of command for the Get-spsite)

12.           help get-spsite  -full (provides very detailed syntax of command for the Get-spsite)

13.           update-help(command to install all the help commands from internet to local system)

14.           get-help get-spsite –showwindow( shows the help commands in a new window)

15. If you know the noun but are unsure of the possible verbs available, you can enter the noun with -? to display the available verb-noun combinations. This also displays additional nouns that are similar to the one you provided. For example, SPSite -? displays the available 

16.If you have been entering several commands in a console screen, pressing the F7 function key displays a menu of the previously executed commands


 

Property values:

Select is the value that use to get the properties .

Select-object

Select *

EX: get-spweb http://expertsharepoint.blogspot.de | select *(will provide all the properties of the web)

get-spweb http://expertsharepoint.blogspot.de | select URL, site groups, roles*(will provide the properties which we mentioned)

Get-member  is the value that use to get the properties

Conditional Operators:

If,elseif,else

Switch

Constructs:

While, do while, for, do until, Foreach

Aliases:

    Start-sleep: sleep

Comparison operators:

Variables:

Out-grid view is the command to open data in Out file

Third party power shell Editors:

Power GUI – http://powergui.org

Power shell plus : http://idera.com

New In SharePoint 2013 Cmdlets:

Short cut keys:

Ctrl+J = to open the snippets

Power shell commands available on SharePoint Online:

How to setup SharePoint online management shell:

https://technet.microsoft.com/en-us/library/fp161372.aspx

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.