Help connecting to remote SQL server in Mgt Studio

I'm trying to connect to a SQL server via IP address.  I keep getting the error in the screenshot.  I also have a screenshot showing my Firewall rule, and my IP settings in my registry.  Any ideas on how I can connect?

My remote server shows this in the security event logs on the server I'm trying to connect to



The Windows Filtering Platform has blocked a packet.

Application Information:
      Process ID:            0
      Application Name:      -

Network Information:
      Direction:            Inbound
      Source Address:            (my source server)
      Source Port:            61377
      Destination Address:      (this server)
      Destination Port:            1433
      Protocol:            6
sql.jpg
sql2.jpg
arthurh88Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nishant joshiConnect With a Mentor Technology Development ConsultantCommented:
There is an problem with your configurations.
go to start>program>sql server>configuration manager in which you will find tcp/ip..

Regards,
nishant
0
 
arthurh88Author Commented:
you were exactly correct!   I opened configuration and sure enough, TCP was not enabled.  Thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.