Re: Can't get global config data and KB 900499 doesn't help

Are you using Windows Authentication or SQL Authentication?

The account you use to create the database MUST have the following rights on
the Database . Database Creater role and Security Administrator role.

Bob Fox
http://bobfox.net


"dbuchanan" <dbuchanan52@xxxxxxxxxxx> wrote in message
news:1146816338.275584.44230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,

Please help me with When I submitted the page I received the error
"Unable to get global configuration data"

Some Facts
I am having problems installing SharePoint Services
I am running Windows Server 2003 SP1
I installed Windows SharePoint Services with SP2
I chose the option to use my SQL Server 2000 SP4 as database rather
than installing MSDE
I used the command line c:\folder\setupsts.exe remotesql=yes and the
Server Farm option suggested by the "Windows SharePoint Services
Administrator's Guide" for "Single Server Deployment"

When Installation completed a configuration page opened and I chose
"StsAdminAppPool (NT Authority\Network Service)" for the application
pool.

For Security configuration I chose NTLM as recommended.

(By the Way - Some More Facts:
I have other SQL Server Reporting Services Installed.
I have Virtual Server 2005 R2 Installed )

I then reset IIS as suggested.

Next the configuration went on to ask me for the server and database.

When it gave me errors and would not create a database I went ahead and
created a database I called "SharePoint".

When I submitted the page I received the error "Unable to get global
configuration data."

Upon research I was directed to KB 900499, KB 823287 and website
http://www.kbalertz.com/kb_823287.aspx

These gave me a lot of understanding about what was the cause. I
followed the instructions resulting in no success and more confusion.

Here is what I did....

I followed the instruction at http://www.kbalertz.com/kb_823287.aspx
but it did not solve it. The database still had me as the dbo.

So I went on to
http://support.microsoft.com/default.aspx?scid=kb;en-us;900499. I
followed the instructions as carefully as I could but this left me with
more questions.

Here are some notes.

It said to run this code...

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;

Against the content database.

I wrote it as....

DECLARE @AdminVSAccount nvarchar(255)
DECLARE @ContentVSAccount nvarchar(255)
SET @ContentVSAccount = N'NT AUTHORITY\NETWORK SERVICE';
SET @AdminVSAccount = N'NT AUTHORITY\NETWORK SERVICE';
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;

And ran it against my database named "ReportServer"

I got these results...

Granted login access to 'NT AUTHORITY\NETWORK SERVICE'.
Granted login access to 'NT AUTHORITY\NETWORK SERVICE'.
Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line
33
The login 'NT AUTHORITY\NETWORK SERVICE' does not exist.
'NT AUTHORITY\NETWORK SERVICE' added to role 'db_owner'.

A little different results than it suggested I would get.

For the configuration database it suggested that I run this code...

DECLARE @AdminVSAccount nvarchar(255)
DECLARE @ContentVSAccount nvarchar(255)
SET @ContentVSAccount = N'Domain\AdminAccount';
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'

I wrote it as...

DECLARE @AdminVSAccount nvarchar(255)
DECLARE @ContentVSAccount nvarchar(255)
SET @ContentVSAccount = N'NT AUTHORITY\NETWORK SERVICE';
SET @AdminVSAccount = N'NT AUTHORITY\NETWORK SERVICE';
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'

And ran it against "SharePointTempDB" and got these results....

Granted login access to 'NT AUTHORITY\NETWORK SERVICE'.
Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line
33
The login 'NT AUTHORITY\NETWORK SERVICE' does not exist.
'NT AUTHORITY\NETWORK SERVICE' added to role 'db_owner'.
'NT AUTHORITY\NETWORK SERVICE' added to role 'dbcreator'.
'NT AUTHORITY\NETWORK SERVICE' added to role 'securityadmin'.

Also different than I was told I would get

The instruction for the content database for substituting
Domain\Account names was...
Note Where Domain\ContentAccount is the domain user account for the
content virtual server, and where Domain\AdminAccount is the domain
user account for the administration virtual server.

The instruction for the configuration database for substituting
Domain\Account names was...
Note Where Domain\AdminAccount is the domain user account for the
content virtual server, and where Domain\AdminAccount is the domain
user account for the administration virtual server.

I only see one Virtual Server under WebSites of the local computer
under IIS in the MMC. Which is which and what is what????

And what is the "Content database" and what is the "Configuration
database"?
I made a database named "SharePoint" and later somewhere along the way
SharePointTempDB showed up. Which is which?

Both databases still have my login as dbo and login "NT
AUTHORITY\NETWORK SERVICE" is said not to exist even though that is the
account offered by the SharePoint configuration page. I don't know how
to get back to that page to change the account if I needed to.

Please help me out of this mess. What do I do to make SharePoint work?

dbuchanan



.

Relevant Pages

  • Cant get global config data and KB 900499 doesnt help
    ... When Installation completed a configuration page opened and I chose ... DECLARE @AdminVSAccount nvarchar ... DECLARE @ContentVSAccount nvarchar ... EXEC sp_grantlogin @ContentVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Share Point Services
    ... Change the database ownership and permissions for the configuration database ... On the new server, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer. ... DECLARE @AdminVSAccount nvarchar ... EXEC sp_changedbowner @AdminVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Permission in database
    ... You can create database roles and assign object permissions to these ... EXEC sp_addrole 'Administrators' ... GRANT SELECT, INSERT, UPDATE, DELETE ON Sales TO Administrators ...
    (microsoft.public.sqlserver.security)
  • Re: stored procedure
    ... Seems you can't have a variable for the database name in CREATE DATABASE. ... the whole CRE¤ATE DATABASE command in a variable and use EXECto execute the statement. ... But why do you want to create a database from inside a stored procedure? ... >> is done inside EXEC so it is in its own scope. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Ownership
    ... can I declare database ownership on more than one ... believe the performance difference is noticeable for most applications. ... then grant select permissions on the views. ... EXEC sp_changedbowner 'MyLogin' ...
    (microsoft.public.sqlserver.security)