Connecting Tech Pros Worldwide Forums | Help | Site Map

Error authenticating user. Cannot open database

Member
 
Join Date: Jun 2009
Location: Bangalore
Posts: 44
#1: Aug 19 '09
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

Member
 
Join Date: May 2009
Location: Goregaon, मुंबई IN :)
Posts: 85
#2: Aug 19 '09

re: Error authenticating user. Cannot open database


for backend you are using ms access or sql server?
Member
 
Join Date: Jun 2009
Location: Bangalore
Posts: 44
#3: Aug 19 '09

re: Error authenticating user. Cannot open database


sql server 2005.

Thanks,
Manik
Member
 
Join Date: Oct 2007
Location: Cape Girardeau
Posts: 54
#4: Aug 19 '09

re: Error authenticating user. Cannot open database


Is the database on the same webserver? Also can you provide the connection string present in your web.config file
Member
 
Join Date: Jun 2009
Location: Bangalore
Posts: 44
#5: Aug 19 '09

re: Error authenticating user. Cannot open database


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;";
Frinavale's Avatar
Site Moderator
 
Join Date: Oct 2006
Location: The Great White North
Posts: 5,168
#6: Aug 19 '09

re: Error authenticating user. Cannot open database


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.
Reply

Tags
authenticating database