Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

[mark.norgate]

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

 

[Sahil Malik [MVP C#]]

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.

 

[mark.norgate]

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

Mark

 

[Miha Markic [MVP C#]]

Hi Mark,

Just to make sure - is your asp.net app on the same machine as database?

 

[Sahil Malik [MVP C#]]

That's your SQL Server - but your connection string still uses Windows.

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

 

[mark.norgate]

Yep, it is.

Hi Mark,

Just to make sure - is your asp.net app on the same machine as database?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

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

Mark

 

[mark.norgate]

Oo, really? So how I modify it for SQL authentication?

 

[Sahil Malik [MVP C#]]

www.connectionstrings.com <--- check that site out


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

Oo, really? So how I modify it for SQL authentication?

That's your SQL Server - but your connection string still uses Windows.

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

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


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