PC Review


Reply
Thread Tools Rate Thread

Cannot open database requested in login 'HumanResources'. Login failed for user 'companyDomain\BOSIIS$'.

 
 
Homer
Guest
Posts: n/a
 
      22nd Sep 2007
Hi,

I have an ASP.NET 2.0 Intranet app that works fine on a test server
running on Win2003 Server with IIS 6.0. However, it fails when I port
it over to the production server running on the same OS. I compared
all the configurations and everything matches. I then re-run the
aspnet_regiis; I even granted "NT AUTHORITY\NETWORK SERVICE" full
access to aspnet_Membership and aspnet_Roles. I don't know why the
app uses a local user account instead of the "NT AUTHORITY\NETWORK
SERVICE" account. Please help me.

Thanks,
Jonathan Kha

 
Reply With Quote
 
 
 
 
Alexey Smirnov
Guest
Posts: n/a
 
      23rd Sep 2007
On Sep 22, 1:47 am, Homer <HomerS...@gmail.com> wrote:
> Hi,
>
> I have an ASP.NET 2.0 Intranet app that works fine on a test server
> running on Win2003 Server with IIS 6.0. However, it fails when I port
> it over to the production server running on the same OS. I compared
> all the configurations and everything matches. I then re-run the
> aspnet_regiis; I even granted "NT AUTHORITY\NETWORK SERVICE" full
> access to aspnet_Membership and aspnet_Roles. I don't know why the
> app uses a local user account instead of the "NT AUTHORITY\NETWORK
> SERVICE" account. Please help me.
>


Hi Jonathan

the problem is in the database and not in the ASP.NET. Go to the
database and check if windows authentication is allowed and the aspnet
account is in the user list. You can also create a new database
account and use it to open database from ASP.NET application.

Hope this helps

 
Reply With Quote
 
Homer
Guest
Posts: n/a
 
      24th Sep 2007
On Sep 23, 8:29 am, Alexey Smirnov <alexey.smir...@gmail.com> wrote:
> On Sep 22, 1:47 am, Homer <HomerS...@gmail.com> wrote:
>
> > Hi,

>
> > I have an ASP.NET 2.0 Intranet app that works fine on a test server
> > running on Win2003 Server with IIS 6.0. However, it fails when I port
> > it over to the production server running on the same OS. I compared
> > all the configurations and everything matches. I then re-run the
> > aspnet_regiis; I even granted "NT AUTHORITY\NETWORK SERVICE" full
> > access to aspnet_Membership and aspnet_Roles. I don't know why the
> > app uses a local user account instead of the "NT AUTHORITY\NETWORK
> > SERVICE" account. Please help me.

>
> Hi Jonathan
>
> the problem is in the database and not in the ASP.NET. Go to the
> database and check if windows authentication is allowed and the aspnet
> account is in the user list. You can also create a new database
> account and use it to open database from ASP.NET application.
>
> Hope this helps


Hi,

My app is an asp.net 2.0 app with no impersonation. By default, I
expect Network Service be used. The database uses Windows
Authentication. I added the "NT AUTHORITY\NETWORK SERVICE account to
the database. I checked the security setting on the app folder at C:
\Inetpub\wwwroot\HumanResources and verified that NETWORK SERVICE is
added to the folder. Am I missing anything here?

Thanks,
Jonathan Kha

 
Reply With Quote
 
Alexey Smirnov
Guest
Posts: n/a
 
      25th Sep 2007
On Sep 24, 10:58 pm, Homer <HomerS...@gmail.com> wrote:
> On Sep 23, 8:29 am, Alexey Smirnov <alexey.smir...@gmail.com> wrote:
>
>
>
>
>
> > On Sep 22, 1:47 am, Homer <HomerS...@gmail.com> wrote:

>
> > > Hi,

>
> > > I have an ASP.NET 2.0 Intranet app that works fine on a test server
> > > running on Win2003 Server with IIS 6.0. However, it fails when I port
> > > it over to the production server running on the same OS. I compared
> > > all the configurations and everything matches. I then re-run the
> > > aspnet_regiis; I even granted "NT AUTHORITY\NETWORK SERVICE" full
> > > access to aspnet_Membership and aspnet_Roles. I don't know why the
> > > app uses a local user account instead of the "NT AUTHORITY\NETWORK
> > > SERVICE" account. Please help me.

>
> > Hi Jonathan

>
> > the problem is in the database and not in the ASP.NET. Go to the
> > database and check if windows authentication is allowed and the aspnet
> > account is in the user list. You can also create a new database
> > account and use it to open database from ASP.NET application.

>
> > Hope this helps

>
> Hi,
>
> My app is an asp.net 2.0 app with no impersonation. By default, I
> expect Network Service be used. The database uses Windows
> Authentication. I added the "NT AUTHORITY\NETWORK SERVICE account to
> the database. I checked the security setting on the app folder at C:
> \Inetpub\wwwroot\HumanResources and verified that NETWORK SERVICE is
> added to the folder. Am I missing anything here?
>
> Thanks,
> Jonathan Kha- Hide quoted text -
>
> - Show quoted text -


Hi Jonathan

try to add into your pages

User: <%=User.Identity.Name%>

to see what user is running your application. It looks like in the
second case you would have the companyDomain\BOSIIS$

Check what authentication mode you have and also check the Security
tab on IIS to see if there any difference.

Hope it helps

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot open user default database. Login failed. Login failed for user 'HEMPC\ASPNET' Tony Johansson Microsoft ASP .NET 3 2nd Jan 2010 04:09 PM
Cannot open database requested in login <DBName>. Login fails. =?Utf-8?B?QUw=?= Microsoft ADO .NET 1 7th Feb 2006 03:17 PM
Cannot open database requested in login 'x'. Login failed for user =?Utf-8?B?QnJpYW4gS2l0dA==?= Microsoft C# .NET 7 9th Jan 2006 09:59 PM
Cannot open database requested in login ''. Login fails. Login failed for user ''. Nevena Microsoft ADO .NET 1 16th Apr 2004 06:55 PM
Can not open Database (MS SQL) requested login failed =?Utf-8?B?Qm9iYnk=?= Microsoft Dot NET 2 9th Mar 2004 06:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:08 AM.