CODEWITHSUNDEEP
sql-serverazurehybrid
Neo
Neo

Reputation: 16239

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?

Upvotes: 0

Views: 2102

Answers (2)

Rahul Tripathi
Rahul Tripathi

Reputation: 172608

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.

Upvotes: 2

Joe Taras
Joe Taras

Reputation: 15399

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.

Upvotes: 2

Related Questions