Re: Share Point Services

From: Mike Walsh (englantilainen_at_hotmail.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 22:20:30 +0300

I think your reply has been overtaken by events.

In his latest posting he said he is using Web Edition. Hence the inability
to install using the default installation ...

Mike Walsh, Helsinki, Finland

"John P. Grieb" <john.grieb@reuters.com> wrote in message
news:uX30#e2PEHA.2976@TK2MSFTNGP10.phx.gbl...
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?...
>