Error authenticating user. Cannot open database

[Manikrag]

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

[NitinSawant]

for backend you are using ms access or sql server?

[Manikrag]

sql server 2005.

Thanks,
Manik

[semomaniz]

Is the database on the same webserver? Also can you provide the connection string present in your web.config file

[Manikrag]

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]

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.