Login failed for user domain\servername

[Manikrag]

Hi Team,

I am facing a strange issue, I have an application on a sever with SQL. I shifted it from one server to other. Configured all the connection strings. Now, when I am trying to access login page..it is showing below error


Error authenticating user. Cannot open database "DBAPP" requested by the login. The login failed.Login failed for user Domain\Server$'.

Strange thing is I am trying to connect with SQL authentication and not sure why this domian\server coming into picture.

I tried to search a lot on internet but did not find something helpful.

Please write if you have any idea about the issue

[Frinavale]

Double check your connection strings to make sure that they are using the correct authentication type. Double check the SQL server to make sure that you've set up the users correctly as well.

-Frinny

[Manikrag]

thanks Frinavale..hope you are doing good.

The user Domain\Server$ coming into error is not at all into picture. I checked the connection string and its correct.

[Frinavale]

I've moved this question to the .NET forum because it's not specifically an ASP.NET question. Hopefully someone here will have a better idea of what might be wrong.

-Frinny

[Curtis Rutland]

Can you post your connection string (with the sensitive details removed, obviously)?

[Manikrag]

thank you!!

My connection string is as given below and working for other forms..but end of the day I would say tht instead of connecting from below string it is trying from domain\server user which I am not sure why is happening

"data source=ServerName;Database=DatabaseName;User ID=user;Password=password;MultipleActiveResultSets =True;";