469,329 Members | 1,503 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,329 developers. It's quick & easy.

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

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

Sep 21 '07 #1
2 3094
On Sep 22, 1:47 am, Homer <HomerS...@gmail.comwrote:
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

Sep 23 '07 #2
On Sep 23, 8:29 am, Alexey Smirnov <alexey.smir...@gmail.comwrote:
On Sep 22, 1:47 am, Homer <HomerS...@gmail.comwrote:
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

Sep 24 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Gopalan | last post: by
3 posts views Thread by Raymond Chiu | last post: by
3 posts views Thread by David C | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Purva khokhar | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.