Re: Sharepoint Problem

From: Pat Coleman (pcoleman_at_foodireland.com)
Date: 02/14/05


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
> created
> For example.. Administrators, System, Creator Owner have full
> permissions?

I assume this is the directory where the website contents reside, in my case
InetPub\Mydomainname

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
processing.
2005-02-12 10:08:33.90 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] 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
> rights.
>
>
> SBS Newsgroups:
>
> SBS v4.x: microsoft.public.backoffice.smallbiz
> SBS 2000: microsoft.public.backoffice.smallbiz2000
> SBS 2003: microsoft.public.windows.server.sbs
>
> "Pat Coleman" <pcoleman@foodireland.com> wrote in message
> news:%23Sp1RkREFHA.392@TK2MSFTNGP14.phx.gbl...
>> 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 ???
>>
>>
>>
>
>



Relevant Pages

  • RE: copy permissions from one user to another?
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- ADD USER TO SERVER ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- SET COMMAND TO FIND USER PERMISSIONS HAS IN CURRENT DATABASE ...
    (microsoft.public.sqlserver.security)
  • Re: Effective Permissions Error with Domain User
    ... I set the database compatibility to 2005. ... server profile trace and found that it was calling the Execute As User. ... This leads me to believe it is some sort of permissions issue. ... Did you get these database from SQL Server 2000 by using a RESTORE command? ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent DELETEs in a table
    ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
    (microsoft.public.sqlserver.server)
  • Re: Disable Sysadmin to view metadata in SQL2005
    ... you are looking for a DRM solution for your database. ... Server does not provide such a solution. ... SQL Server Engine ... If the permissions are not granular ...
    (microsoft.public.sqlserver.security)
  • Re: Table permissions: No matter what I set all users have full access?
    ... I have created a new Windows user the ... logged on to another PC as that user and can still access the database with ... The new user does not have a login on the server and is ... I even created a login for the user and denied SELECT permissions on various ...
    (microsoft.public.access.adp.sqlserver)