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

Error authenticating user. Cannot open database

P: 62
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
Share this Question
Share on Google+
5 Replies


100+
P: 270
for backend you are using ms access or sql server?
Aug 19 '09 #2

P: 62
sql server 2005.

Thanks,
Manik
Aug 19 '09 #3

Expert 100+
P: 210
Is the database on the same webserver? Also can you provide the connection string present in your web.config file
Aug 19 '09 #4

P: 62
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
Expert Mod 5K+
P: 9,731
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.