Re: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

It's already set to use "SQL Server and Windows" authentication.

Mark

Sahil Malik [MVP C#] wrote:
You need to use SQL Server authentication instead of Windows authentication.
There are ways to use Windows Auth with ASP.NET, but changing over to SQL
Server auth. is the simplest quickfix to your problem.


--
- Sahil Malik [MVP]
http://blah.winsmarts.com


<mark.norgate@xxxxxxxxx> wrote in message
news:1151678886.154475.131090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm using ASP.NET 2.0 and Windows Server 2003.

A common problem it seems, and I've followed all the advice on the
world wide interweb but I still get the following message:

Cannot open database requested in login 'verfiy'. Login fails.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

I've added VERIFY\IIS_WPG to the Verify database users, as well as NT
AUTHORITY\NETWORK SERVICE, just to be on the safe side, assigned them
both the db_owner role, but still get the above error. My connection
string looks like this:

Server=localhost;Database=verfiy;Trusted_Connection=True;

What am I missing?

Ta, Mark


.

Relevant Pages

  • Re: How to stop TransactionScope from starting distributed transaction
    ... Are you using SQL Server 2000? ... Sahil Malik [MVP] ... use SAVE TRANSACTION in distributed transaction". ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Text of Startup Option Application Title
    ... This is a quote from Mary Chipman, SQL Server MVP, ex-Access MVP, and author ... DAO was designed, customized, and tweaked specifically for the Jet ... ADO was designed as a general-purpose data access wrapper around OLE ...
    (microsoft.public.access.formscoding)
  • Re: Autonumbers vs Identity Key
    ... "Pat Hartman (MVP)" wrote: ... The reason that SQL Server doesn't assign an autonumber immediately is ... > I then had to make bF9 true before doing the recalc, ... >> Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.conversion)
  • Re: Active/Active clustering
    ... > The OS and the SQL Server executables gets installed on the local drive. ... > Mike Epprecht, Microsoft SQL Server MVP ... So, I need an SAN attached storage device, so ...
    (microsoft.public.sqlserver.clustering)
  • Re: Login failed for user NT AUTHORITYNETWORK SERVICE
    ... So how I modify it for SQL authentication? ... Sahil Malik [MVP] ... Cannot open database requested in login 'verfiy'. ...
    (microsoft.public.dotnet.framework.adonet)