refused my local machine sql connection for 1433 port

0
votes

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?

2
sql-serverazurehybrid
You aren't using a local address at all. Use .\SQLEXPRESS, (local)\SQLEXPRESS or even 127.0.0.1\SQLEXPRESS. By using a computer name you are actually making a remote connection – Panagiotis Kanavos

2 Answers

2
votes

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.

2
votes

Please check the Firewall setting, most likely it is stopping it. Try to turn off your Firewall and check if it works. Also it may be that the process which is hosting the service is not listening on that port.