Login failed for user using SQL authentication

I have a connection made with a user name say ABC. In a method I create a new instance of sqlconnection named connection1 using the same connectionstring as that of the previous connection. When connection1.open() is issued it giv开发者_JAVA百科es an exception stating that Login has failed for the user ABC. When SQL is able to connect to the user ABC for the first connection why does it fail for the second? I am using MARS=true in the connectionstring.

Thanks

What is the exact error please? And the code?

You could be connecting to a database where you have no rights, which gives a different error to a wrong password.