DB connection error
From: Spookie (alopez_at_la911.com)
Date: 06/09/04
- Next message: Cameron: "Images on Page"
- Previous message: Cameron: "Re: Source for How To's"
- Next in thread: anonymous_at_discussions.microsoft.com: "DB connection error"
- Reply: anonymous_at_discussions.microsoft.com: "DB connection error"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 14:00:14 -0700
I have made numerous attempts to configure sharepoint 2003 for a web farm
configuration. My problem is in attempting to connect to our SQL server to
set up the configuration DB. We have SS2K EE installed on two computers, one
is on the local host and the other is remote. In both cases I get the
following error message. I have verified that our SS2K EE instances are
configured for case insensitive collation. So what else can be the problem?
----------------------------------------------------------------------------
--------------------------------------------
You receive the "Error accessing database" error message and other error
messages when you try to create a SharePoint Portal Server 2003 or a Windows
SharePoint Services configuration database
View products that this article applies to.
SYMPTOMS
When you install Microsoft Office SharePoint Portal Server 2003 or Microsoft
Windows SharePoint Services with Microsoft SQL Server, and you try to create
the configuration database, you receive the following error message:
Error accessing database. Verify that the database server name and the
instance name (if present) are correct. Also, ensure the configuration
database administration account has sufficient permissions on the server or
instance and the service corresponding to your SQL Server instance is
running.
When this issue occurs, the database is created but does not function. If
you continue after you receive this error message, and you try to create a
Portal, you receive the following error message:
Portal creation failed. Please see the portal creation log for more details.
The following error may also be recorded in the Portal log file:
10:29:54 Portal creation job exception. (status=PortalAdminJobStatusFailed)
Microsoft.SharePoint.SPException: Must declare the variable '@SiteId'.
(Error code: 137). ---> System.Runtime.InteropServices.COMException
(0x81071717): Must declare the variable '@SiteId'. (Error code: 137).
If you are installing Microsoft Windows SharePoint Services, and you try to
extend a virtual server, you receive the following error message:
Must declare the variable '@SiteId'. (Error code: 137).
CAUSE
This issue may occur if the SQL Server is configured to use case sensitive
collation. SharePoint Portal Server 2003 requires that the collation name
for the database be Latin1_General_CI_AS_KS_WS. This name most closely
matches the Microsoft Windows NTFS file system collation.
RESOLUTION
To resolve this issue, use case-insensitive collation in SQL Server. The
collation for SQL Server 2000 is configured when SQL Server is installed. To
resolve this issue, remove, and then reinstall SQL Server with
case-insensitive collation.
MORE INFORMATION
For information about how to install SQL Server with case-insensitive
collation, follow the instructions in your SQL Server documentation.
For additional information about a related issue, click the following
article number to view the article in the Microsoft Knowledge Base:
306492 Error Message: Unable to prepare tables in database...
----------------------------------------------------------------------------
--------------------------------------------
- Next message: Cameron: "Images on Page"
- Previous message: Cameron: "Re: Source for How To's"
- Next in thread: anonymous_at_discussions.microsoft.com: "DB connection error"
- Reply: anonymous_at_discussions.microsoft.com: "DB connection error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
