By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,696 Members | 2,213 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,696 IT Pros & Developers. It's quick & easy.

Cannot open database requested in login 'xyz'. Login fails.

P: n/a
One basic ASP.NET database issue….
I have a c# app running on a iis6 on one win2k3 adv servermachine &
database on other win2k server machine…(in the same domain)

Using windows authentication in web.config. Set impersonate =true .
Connection string has Integrated security=SSPI. Logging in with my ID
which is system administrator and has rights all DBs on the sql
machine.

But still, I get this error..(even I tried putting for test purpose
the username & pw in identity tag, but still same error.)
(My app is working fine with db & iis on same machine)
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 11
LineNumber: 0
Message: Cannot open database requested in login 'xyz'. Login fails.
Login failed for user 'XYZDomian\v-xyz'.
Number: 4060

I tried the option of using Ntwork share in a custom application pool
& giving the access rights to the network share on the sql machine.
But this too didnt work..

Any help on this is appreciated..

Thanks,
Nandi
Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
set impersonate = false.
and give the default aspnet account (or the identity in which application
pool is running) database access.

Av.
"Nans" <go********@mastek.com> wrote in message
news:71**************************@posting.google.c om...
One basic ASP.NET database issue..
I have a c# app running on a iis6 on one win2k3 adv servermachine &
database on other win2k server machine.(in the same domain)

Using windows authentication in web.config. Set impersonate =true .
Connection string has Integrated security=SSPI. Logging in with my ID
which is system administrator and has rights all DBs on the sql
machine.

But still, I get this error..(even I tried putting for test purpose
the username & pw in identity tag, but still same error.)
(My app is working fine with db & iis on same machine)
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 11
LineNumber: 0
Message: Cannot open database requested in login 'xyz'. Login fails.
Login failed for user 'XYZDomian\v-xyz'.
Number: 4060

I tried the option of using Ntwork share in a custom application pool
& giving the access rights to the network share on the sql machine.
But this too didnt work..

Any help on this is appreciated..

Thanks,
Nandi

Nov 18 '05 #2

P: n/a
You have to allow windows authentication on the and add the aspnet account
in the database

Regards
Martin
"Nans" <go********@mastek.com> wrote in message
news:71**************************@posting.google.c om...
One basic ASP.NET database issue..
I have a c# app running on a iis6 on one win2k3 adv servermachine &
database on other win2k server machine.(in the same domain)

Using windows authentication in web.config. Set impersonate =true .
Connection string has Integrated security=SSPI. Logging in with my ID
which is system administrator and has rights all DBs on the sql
machine.

But still, I get this error..(even I tried putting for test purpose
the username & pw in identity tag, but still same error.)
(My app is working fine with db & iis on same machine)
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 11
LineNumber: 0
Message: Cannot open database requested in login 'xyz'. Login fails.
Login failed for user 'XYZDomian\v-xyz'.
Number: 4060

I tried the option of using Ntwork share in a custom application pool
& giving the access rights to the network share on the sql machine.
But this too didnt work..

Any help on this is appreciated..

Thanks,
Nandi

Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.