Re: Share Point Services

From: John P. Grieb (john.grieb_at_reuters.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 15:11:58 -0400

I had the exact same problem.

Here is an excerpt from the SharePoint Administration Guide that will resolve the problem for you:
Change the database ownership and permissions for the configuration database
  1.. On the new server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2.. In the Connect to SQL Server dialog box, in the SQL Server box, type the server name, and then click OK.
  3.. On the Query menu, click Change Database.
  4.. In the Select Database of server_name box, click the configuration database (sts_config), and then click OK.
  5.. In the Query pane, type the following query.
DECLARE @AdminVSAccount nvarchar(255)
DECLARE @ContentVSAccount nvarchar(255)
SET @ContentVSAccount = N'domain\contentaccount';
SET @AdminVSAccount = N'domain\adminaccount';
EXEC sp_grantlogin @ContentVSAccount;
EXEC sp_changedbowner @AdminVSAccount;
IF NOT EXISTS (SELECT * FROM sysusers WHERE name=@ContentVSAccount)
          EXEC sp_grantdbaccess @ContentVSAccount;
EXEC sp_addrolemember 'db_owner', @ContentVSAccount;
EXEC sp_addsrvrolemember @AdminVSAccount, 'dbcreator'
EXEC sp_addsrvrolemember @AdminVSAccount, 'securityadmin'
EXEC sp_addsrvrolemember @AdminVSAccount, 'processadmin'
Note In lines 3 and 4, replace domain\contentaccount and domain\adminaccount with the domain account for the content virtual server and the domain account for the SharePoint Central Administration virtual server. If the accounts are the same, SQL Query Analyzer will display an error, but the process will still succeed.

  6.. Click the Execute Query button to update the database.
Change the database ownership and permissions for the content databases
  1.. On the new server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2.. In the Connect to SQL Server dialog box, in the SQL Server box, type the server name, and then click OK.
  3.. On the Query menu, click Change Database.
  4.. In the Select Database of server_name box, click the content database you want to update, and then click OK.
  5.. In the Query pane, type the following query.
DECLARE @AdminVSAccount nvarchar(255)
DECLARE @ContentVSAccount nvarchar(255)
SET @ContentVSAccount = N'domain\contentaccount';
SET @AdminVSAccount = N'domain\adminaccount';
EXEC sp_grantlogin @ContentVSAccount;
EXEC sp_grantlogin @AdminVSAccount;
EXEC sp_changedbowner @AdminVSAccount;
IF NOT EXISTS (SELECT * FROM sysusers WHERE name=@ContentVSAccount)
          EXEC sp_grantdbaccess @ContentVSAccount;
EXEC sp_addrolemember 'db_owner', @ContentVSAccount;
Note In lines 3 and 4, replace domain\contentaccount and domain\adminaccount with the domain account for the content virtual server and the domain account for the SharePoint Central Administration virtual server. If the accounts are the same, SQL Query Analyzer will display an error, but the process will still succeed.

  6.. Click the Execute Query button to update the database.

--------------------------------------------------------------------------------

"Gene Miller" <anonymous@discussions.microsoft.com> wrote in message news:fc2201c43e86$6e99f5e0$a301280a@phx.gbl...
>I am running Web Server 2003 and have just installed
> Sharepoint services.I also have a SQL database server that
> I named CATHARSY-2003. The Default Databases were
> installed.When I try to manage the Share point services
> through the web interface (Windows SharePoint Services
> Set Configuration Database Server ) I am prompted to fill
> in "SQL Server database name" Upon doing so and using my
> Administrator Login I get a response on a new page "Login
> failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error
> code: 18456). " Could sombody explain this?...
>

Loading