arthurh88
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://blogs.msdn.com/b/wa lzenbach/a rchive/201 0/04/14/ho w-to-enabl e-remote-c onnections -in-sql-se rver-2008. aspx
ASKER
you were exactly correct! I opened configuration and sure enough, TCP was not enabled. Thanks a lot