RE: Authentication of SharePoint Services 2003 with SQL Server 2000
From: Ken K (KenK_at_discussions.microsoft.com)
Date: 01/27/05
- Next message: dspiral: "Infopath: Can I do this?"
- Previous message: Wendy B: "Documents Uploaded to Doc Libraries turn to Gibberish"
- In reply to: Samuel: "Authentication of SharePoint Services 2003 with SQL Server 2000"
- Next in thread: Samuel: "RE: Authentication of SharePoint Services 2003 with SQL Server 2000"
- Reply: Samuel: "RE: Authentication of SharePoint Services 2003 with SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 14:41:05 -0800
You need to give NETWORK SERVICE 'Database Creation' rights.
The problem is to find NETWORK SERVICE to enable you to do this.
In SQL Server Enterprise Manager specify Database Creation rights for
NETWORK SERVICE after you've found it hiding away in IIS_WPG Local Groups.
"Samuel" wrote:
> I have installed SharePoint Services 2003 using SQL Server 2000 as backend
> database, both of them are installed on the same machine.
> After installation completed, I try to create ConfigDB by specifying the
> machine name of my local machine using windows authentication (my current a/c
> is administrator)
> the following message appear.
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error code: 18456).
>
> How to solve it? Is that mean I can't use windows authentication for my
> sharepoint? Do I need to create DB user account for sharepoint?
> Also, What account should be used to access the SQL server in production
> environment? and what priveledge is needed?
>
> Thanks.
- Next message: dspiral: "Infopath: Can I do this?"
- Previous message: Wendy B: "Documents Uploaded to Doc Libraries turn to Gibberish"
- In reply to: Samuel: "Authentication of SharePoint Services 2003 with SQL Server 2000"
- Next in thread: Samuel: "RE: Authentication of SharePoint Services 2003 with SQL Server 2000"
- Reply: Samuel: "RE: Authentication of SharePoint Services 2003 with SQL Server 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
