Can't connect to database when database has user and password

Question

I am developing mvc 4 projects and when I use the following connection string it works:

<add name="name" 
 connectionString="Server=.\sqlexpress;Database=dbname;
 Trusted_Connection=true;" 
 providerName="System.Data.SqlClient"/>

But when I add a username and password to this project, I can't connect to my database. I added the user credentials correctly. I have db_owner permission for this database, and in my database everything is correct. The connection string below does not work:

  <add name="DocContext"
   connectionString="Server=.\sqlexpress;Database=DocContext;
   User ID=pooria;Password=19216801;Trusted_Connection=false;"   
   providerName="System.Data.SqlClient"/>

What error do you get either in the application or the error logs on the SQL Server? — steoleary, Feb 04 '14 at 10:33
Are you sure you are referencing the correct connection string? — Gaz Winter, Feb 04 '14 at 10:48

score 1 · Answer 1 · edited May 23 '17 at 11:49

Connection String You are using follows format -

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
User ID=myDomain\myUsername;Password=myPassword;

Try using IP Address, Port in Data Source field like -

<connectionStrings>
    <add name="ConnectionStringName"
        providerName="System.Data.SqlClient"
        connectionString="Data Source=190.190.200.100,1433;
                          Initial Catalog=MyDatabaseName;
                          Integrated Security=False;
                          User ID=MyUserID;Password=MyPassword;
                          MultipleActiveResultSets=True" />
  </connectionStrings>

And the following link may help you LINK

Can't connect to database when database has user and password

1 Answers1