Connect to SQL Server through IP address

by

Here are couple more things you can try.

Check if sql server is configured to listen on that IP address. If your server has multiple IP addresses that doesn’t necessarily mean that it can automatically accept connections from all IPs.

To set this go to SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for {instancename} -> TCP/IP -> IP addresses tab

Here is also some info that will guide you when setting up firewall.
What you want to do with the firewall is to enable TCP and UDP traffic on port 1433 for both incoming and outgoing traffic.

http://www.howtogeek.com/112564/how-to-create-advanced-firewall-rules-in-the-windows-firewall/

Now, if you have physical firewall or some other software firewall other than windows default you’ll have to contact your network admin

More Related Contents:

  1. Datatype for storing ip address in SQL Server
  2. If condition in SQL Server 2008
  3. Comma separated results in SQL
  4. Which are more performant, CTE or temporary tables?
  5. Search all tables, all columns for a specific value SQL Server [duplicate]
  6. When/Why to use Cascading in SQL Server?
  7. SQL WHERE.. IN clause multiple columns
  8. SQL Server: combining multiple rows into one row
  9. Database scheme, autoincrement
  10. SQL Server: Index columns used in like?
  11. How can I select from list of values in SQL Server
  12. Configure Lucene.Net with SQL Server
  13. SQL Server tables: what is the difference between @, # and ##?
  14. Getting execute permission to xp_cmdshell
  15. Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility
  16. Forcing a query timeout in SQL Server
  17. Sql Server – connect with windows authentication
  18. SQL Server ON DELETE Trigger
  19. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  20. SQL Server – Auto-incrementation that allows UPDATE statements
  21. FOR XML PATH(”): Escaping “special” characters
  22. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  25. Converting Columns into rows with their respective data in sql server
  26. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  27. SQL Server – How to insert a record and make sure it is unique
  28. “If not exists” fails on SQL CE
  29. Does the `nodes()` method keep the document order?
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment