I am getting an error : Login failed to server . Even though using the credentials I am able to login to SQL Server.
Connection string :
Data Source=localhost;Initial Catalog=DBNAME;User ID=USERNAME;Password=PWD
Userid and password is SQL authentication account