468,136 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Error authenticating user. Cannot open database

Hi Team,
I have copied one ASP.NET application on a new server and configured it all.Now I am getting below error when I am trying to authenticate users thru LdapAuthentication function. This function is authenticating user and thn reading data from datbase server. DOMAIN\WEBSERVER$' is nowhere in the picture but still I am not able to read the database.

Here is the error.
__________________________________________________ ________________
Error authenticating user. Cannot open database "XXXX" requested by the login. The login failed.
Login failed for user DOMAIN\WEBSERVER$'. SQL=SELECT ID FROM PS_TBL WHERE LOWER(RTRIM(DOMAIN_NTLOGIN_ID))=LOWER('MSHARMA')
__________________________________________________ ________________

Please help!!

Thanks,
Manik
Aug 19 '09 #1
5 2717
NitinSawant
270 100+
for backend you are using ms access or sql server?
Aug 19 '09 #2
sql server 2005.

Thanks,
Manik
Aug 19 '09 #3
semomaniz
210 Expert 100+
Is the database on the same webserver? Also can you provide the connection string present in your web.config file
Aug 19 '09 #4
database is on the same server

conn. string is

"data source=server\\SQLEXPRESS;Integrated Security=SSPI;Database=datbase;User ID=U;Password=P;MultipleActiveResultSets=True;";
Aug 19 '09 #5
Frinavale
9,735 Expert Mod 8TB
Make sure that the database on the server is configured to allow your application to connect to it.

Use the SQL Configuration Manager to edit the database user that your application is using to connect to the database. Make sure that this user has the proper permissions set so that it do what it needs to do.
Aug 19 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by le0 | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.