Re: Sharepoint Problem
From: Pat Coleman (pcoleman_at_foodireland.com)
Date: Mon, 14 Feb 2005 15:22:27 -0500
> 1) Does companyweb itself work?
Yes, companyweb works OK
> 2) Permissions to the directory where the database is attempting to be
> For example.. Administrators, System, Creator Owner have full
I assume this is the directory where the website contents reside, in my case
This directory has the permissions listed above.
> 3) When you are extending the site are you creating an new application
> pool or using the DefaultAppPool? If you are creating a new app pool what
> account are you using for it? the Network Service account?
I use the defaultAppPool
4) Might check in \program files\microsoft sql server\mssql$sharepoint\log
directory for the ERRORLOG file to see if it shows any errors.
This is the Error Log :
2005-02-12 10:08:33.12 server Copyright (C) 1988-2002 Microsoft Corporation.
2005-02-12 10:08:33.12 server All rights reserved.
2005-02-12 10:08:33.12 server Server Process ID is 416.
2005-02-12 10:08:33.12 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.
2005-02-12 10:08:33.14 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2005-02-12 10:08:33.90 server SQL Server configured for thread mode
2005-02-12 10:08:33.90 server Using dynamic lock allocation.  Lock
Blocks,  Lock Owner Blocks.
2005-02-12 10:08:34.07 spid2 Starting up database 'master'.
2005-02-12 10:08:34.79 spid5 Starting up database 'model'.
2005-02-12 10:08:34.79 server Using 'SSNETLIB.DLL' version '8.0.880'.
2005-02-12 10:08:34.79 server SQL server listening on Shared Memory.
2005-02-12 10:08:34.79 server SQL Server is ready for client connections
2005-02-12 10:08:34.82 spid2 Server name is 'DELL1600SC\SHAREPOINT'.
2005-02-12 10:08:34.82 spid2 Skipping startup of clean database id 4
2005-02-12 10:08:34.82 spid2 Skipping startup of clean database id 5
2005-02-12 10:08:34.82 spid2 Starting up database 'STS_DELL1600SC_1'.
2005-02-12 10:08:35.49 spid5 Clearing tempdb database.
2005-02-12 10:08:41.37 spid5 Starting up database 'tempdb'.
2005-02-12 10:08:42.00 spid2 Recovery complete.
2005-02-12 10:08:51.78 spid51 Starting up database 'STS_Config'.
2005-02-12 10:08:57.73 spid2 SQL global counter collection task is created.
I am getting this error every hour in the Events / Applications logs
Unable to connect to the database STS_DELL1600sc_507690611 on
DELL1600SC\SharePoint. Check the database connection information and make
sure that the database server is running.
There is no web listed in IIS with an Identifier of 507690611 so I dont know
what web it is referring to.
> Hope that helps,
> David Copeland
> Microsoft Small Business Server Support
> This posting is provided "AS IS" with no warranties, and confers no
> SBS Newsgroups:
> SBS v4.x: microsoft.public.backoffice.smallbiz
> SBS 2000: microsoft.public.backoffice.smallbiz2000
> SBS 2003: microsoft.public.windows.server.sbs
> "Pat Coleman" <email@example.com> wrote in message
>> Tried to extend sharepoint extensions to a new virtual server.
>> Get the error
>> Can not create the database STS_MYSERVER_32132132 . Your database
>> installation may be corrupt.
>> I reinstalled Sharepoint from the Add Remove Programs and no luck.
>> The SQL Manager icon on bottom of screen has the MYSERVER\SHAREPOINT
>> running with the little green arrow on.
>> Any Ideas where to start ???