Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Error 5586 when creating a database in WSS 3

  Asked By: Anil    Date: May 01    Category: Sharepoint    Views: 2165

Setup (test environment) is WSS, SQL 2005 standard edition, SP2,
running on W2K3 R2 with SP2 - all as a virtual machine under VMware
ESX 3.5.

If I pre-create a content database in SQL (as I'm told this is a
preferred way to go about things), after I "add a content database"
in WSS, I appear to get a single error logged in the machines
Application logs - and the database is reported as successfully
created in WSS.

If I instead allow WSS to create the database, I don't get an error,
so presumably this is something I'm doing wrong (my SQL
knowledge/experience is pretty low I'm afraid).

The error I'm receiving is :

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5586
Date: 22/01/2009
Time: 14:49:33
User: N/A
Computer: SPTEST
Unknown SQL Exception 208 occured. Additional error information from
SQL Server is included below.

Invalid object name 'dbo.SystemVersion'.

For more information, see Help and Support Center at

In SQL, I have used a domain account (standard user), for which a
role has been created with server roles of dbcreator, public and
securityadmin. I create the WSS databases with the
Latin1_General_CI_AS_KS_WS collation. Windows authentication is used
for the Database authentication when creating the database.

On first glance, I can't see the difference between the database I
create and the one created by WSS. I (appear to) have been able to
use the database I created without any problems.

Am I doing anything obviously wrong, or does anyone know what this
error indicates?



2 Answers Found

Answer #1    Answered By: Thomas Davis     Answered On: May 01

Are you actually creating  the database  in SQL Server, or using the
psconfig utility? The latter is what I've always seen recommended, since it
takes care of some nuances that you or I might miss by going directly to the
DB server.

Answer #2    Answered By: Dominic Davis     Answered On: May 01

I've created the database  from within SQL server management studio.
I wasn't aware that psconfig allowed you to create a new content
database. I'll look a bit more at it.

Didn't find what you were looking for? Find more on Error 5586 when creating a database in WSS 3 Or get search suggestion and latest updates.