<mark.norgate@gmail.com> wrote in message
news:1152099360.816994.158140@a14g2000cwb.googlegroups.com...
> Oo, really? So how I modify it for SQL authentication?
>
> Sahil Malik [MVP C#] wrote:
>> That's your SQL Server - but your connection string still uses Windows.
>>
>> - Sahil Malik [MVP]
>> http://blah.winsmarts.com
>>
>>
>>
>>
>> <mark.norgate@gmail.com> wrote in message
>> news:1151680104.821400.11180@d56g2000cwd.googlegroups.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
>> >>
>> >>
>> >> <mark.norgate@gmail.com> wrote in message
>> >> news:1151678886.154475.131090@i40g2000cwc.googlegroups.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
>> >> >
>> >
>