|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'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 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. Show quote 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 > It's already set to use "SQL Server and Windows" authentication.
Mark Sahil Malik [MVP C#] wrote: Show quote > 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.norg***@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 > > Hi Mark,
Just to make sure - is your asp.net app on the same machine as database? -- Show quoteMiha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ <mark.norg***@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.norg***@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 >> > > Yep, it is.
Miha Markic [MVP C#] wrote: Show quote > 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/ > > <mark.norg***@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.norg***@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 > >> > > > That's your SQL Server - but your connection string still uses Windows.
- Sahil Malik [MVP] http://blah.winsmarts.com <mark.norg***@gmail.com> wrote in message Show quote 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.norg***@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 >> > > Oo, really? So how I modify it for SQL authentication?
Sahil Malik [MVP C#] wrote: Show quote > That's your SQL Server - but your connection string still uses Windows. > > - Sahil Malik [MVP] > http://blah.winsmarts.com > > > > > <mark.norg***@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.norg***@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 > >> > > >
www.connectionstrings.com <--- check that site out :)
Show quote 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.norg***@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.norg***@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 >> >> > >> > >  |
|||||||||||||||||||||||
Other interesting topics