Search code examples
sql-serverazurehybrid

refused my local machine sql connection for 1433 port

I'm trying to connect sql server using following connection string but getting error:

<connectionStrings>
  <add name="DefaultConnection" 
       connectionString="Server=MyMachine32\SQLEXPRESS,1433;Database=MembershipDB;User ID=sa;Password=mydata@123" 
       providerName="System.Data.SqlClient"/>
</connectionStrings>

Error:

No connection could be made because the target machine actively refused it

I have already enabled TCP/IP from Sql server configuration manager. what else needed?

Solution

  • You have tagged your question with "Azure".

    So, check if in Azure settings there is a rule to grant at your machine access on DB hosted in Azure space.

    You can go here, a guide about Azure firewall rule.