Solved

Help connecting to remote SQL server in Mgt Studio

Posted on 2012-03-24
3
466 Views
Last Modified: 2012-03-24
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
0
Comment
Question by:arthurh88
  • 2
3 Comments
 
LVL 14

Accepted Solution

by:
nishant joshi earned 500 total points
ID: 37762149
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
 
LVL 14

Expert Comment

by:nishant joshi
ID: 37762152
0
 

Author Closing Comment

by:arthurh88
ID: 37762159
you were exactly correct!   I opened configuration and sure enough, TCP was not enabled.  Thanks a lot
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now