Re: Error code: 18456

From: Ian Morrish (ian_morrish_at_hotmailDotCom)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 22:07:27 +1200

Looks like your IIS Application pool is running under the built in Network
Service account. This account doesn't have rights to create a database on
the SQL server. You should change the app pool to use a domain account that
has appropriate SQL server rights (covered in the admin guide)

Regards,
Ian
http://www.wssdemo.com

"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:00fe01c49f44$bfe07f90$a601280a@phx.gbl...
>I am setting up a new install of WSS using SQL2000. When I
> attempt to connect WSS to SQL from the Set Configuration
> Database Server page I get Login failed for user 'NT
> AUTHORITY\NETWORK SERVICE'(Error code: 18456).
>
> I am using Sharepoint Products and Technologies REsource
> Kit as a refernece. This section of the book is somewhat
> vague.
>
> Help!!!!
>
> Thanks...

Relevant Pages

  • Re: PerfMon recording to SQL 2005
    ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 express security issue
    ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ... You do not have to use the "sa" account and it's not recommended using this account because every hacker knows that SQL Server has a built-in sysadmin account which is called "sa". ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express security issue
    ... Ekrem Onsoy ... I can't use Windows authentication because I can't control account creation in client machine, ... I can't control user attached to my database because it is his own machine, I can't set any file permission, so the last security measure is to use SQL authentication to protect my data. ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET, Win2k, SQL 2k on an intranet (w/Kerberos?)
    ... In your place I would go trough database and have mirrored accounts in SQL ... you can create views on SQL server to filter out ... Grant ASPNET account logon rights to SQL server and limit ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Unable to write to user profile...
    ... I've given the account rights to manage profile as well. ... On the database level, could you provide more information on the rights i need to grant the account? ... Microsoft Online Community Support ...
    (microsoft.public.sharepoint.portalserver.development)