Ulysses Ludwig’Blog


Creating a State Service Database for SharePoint 2010 Using Windows PowerShell

Date: 17 Jun 2010 | 3 Comments | Tags: ,, | 2010,SharePoint,Uncategorized | 
3

Problem

SharePoint health analyzer states that the state service is missing its databse.

image

Solution

Create the state server database by following the steps below

1) Login to SharePoint farm member server under the credentials of a farm administrator

2) Open “SharePoint 2010 Management Shell (don’t just open PowerShell)

image

NOTE: If you receive the “The Local Farm is Not Accessible” error see the following article: http://www.sharepointassist.com/2010/01/29/the-local-farm-is-not-accessible-cmdlets-with-featuredependencyid-are-not-registered/

3) Run the following command
PS C:\New-SPStateServiceDatabase

image

4) Verify that the problem has been resolved by clicking the “ReAnalyze Now” button

image

If the problem persists verify that the Secure Store Service has been started
image

GD Star Rating
a WordPress rating system
GD Star Rating
a WordPress rating system

Creating a State Service Database for SharePoint 2010 Using Windows PowerShell, 5.5 out of 10 based on 2 ratings

Be Sociable, Share!



About the author


ujludwig
Ulysses Ludwig is a SharePoint architect with over 16 years in the IT and computer industry. Ulysses' primary focus is SharePoint but he dabbles in the latest web technologies and likes to develop software in his spare time.


Related Posts


SharePoint 2013 Lab Build - Part 4 - Security Configuration
Probably the most critical and overlooked portion of SharePoint installation is security. Without a well thought out security strategy and a plan of action, it is likely that SharePoint 2013 will not behave...



Enabling Fly Out Menus In SharePoint 2010
So I have noticed that Google refers lots of people to my blog for “Fly Out Menus”. I imagine many of you are disappointed when you find that the article is for enabling the fly out only on the top of the page...



Geneva Error - Exception: System.InvalidCastException: Unable to cast object of type ‘Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection’ to type ‘Microsoft.IdentityModel.Configuration.MicrosoftIdentityModelSection’.
I was lazy and decided to uninstall my Beta SharePoint, delete all of the databases, then re-install SharePoint 2010 RTM on my server.  Everything ran perfectly through the install until I ran the SharePoint...





3 Comments for Creating a State Service Database for SharePoint 2010 Using Windows PowerShell

Deen

Hi,
when I run the following cmdlt
New-SPStateServiceDatabase -DatabaseServer “SPSQLDEV” -Name “SP_StateService”

I get the following error, can you please help me?

New-SPStateServiceDatabase : Operation is not valid due to the current state of
the object.
At line:1 char:27
+ New-SPStateServiceDatabase <<<< -DatabaseServer "SPSQLDEV" -Name
"SP_StateService"
+ CategoryInfo : InvalidData: (Microsoft.Offic…eDatabaseCmdlet:
NewStateServiceDatabaseCmdlet) [New-SPStateServiceDatabase], InvalidOperat
ionException
+ FullyQualifiedErrorId : Microsoft.Office.Server.Administration.NewStateS
erviceDatabaseCmdlet

GD Star Rating
a WordPress rating system
GD Star Rating
a WordPress rating system

Reply

    ujludwig

    It looks to me like the database already exists or you don’t have rights to create the database. Please verify that your app pool account has rights to create the database. Note that since I wrote this post years ago I have started to rely more on the wizard to create the state service database.

    GD Star Rating
    a WordPress rating system
    GD Star Rating
    a WordPress rating system

    Reply

    Deen

    Please ignore my earlier question, I found the problem New-SPStateServiceDatabase will not take a SQLalias as -databaseserver name.

    http://technet.microsoft.com/en-us/library/ff607677.aspx

    GD Star Rating
    a WordPress rating system
    GD Star Rating
    a WordPress rating system

    Reply




Wanna say something?