MaximumASP
Social Bookmarking
Online Shopping
asp.net hosting
UK online local dating
| More
Recent News » SQL

Open SQL Port for specific IP by ASP.NET Website

Posted by: Hannes Preishuber, on 26 Aug 2009 | View original | Bookmarked: 0 time(s)

We run a public SQL Server on Windows Server 2008 and had a lot of dictionary attacks in the past. To prevent that, do following 1) disable sa user 2) enable Windows Firewall, set a inbound rule ( here named sql) and lock the port 1433, then add the external IPs ( scope tab) which needs access from extern   Now you are save. New problem is, what happens when you have dynamic IP address on client and need access by SQL Manager or Visual Studio Server Manager. Take really long time to solve...

Advertisement
Free Agile Project Management Tool from Telerik
TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.
Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1088 | Hits: 18

Similar Posts

  • Connecting to SQL Azure with Telerik OpenAccess more
  • How to display data from different tables using one data source more
  • Accessing Images On Flickr From An ASP.NET Website Using The Flickr.Net Library more
  • Update to Logging in to DotNetNuke from a Silverlight Application with RIA Authentication more
  • How to Enhance Projects Using MSBuild on a Machine Without Telerik OpenAccess ORM Installed more
  • Installing the FTP Service for IIS 6.0 On An Alternate Port Number and Configuring Windows Firewall more
  • The Open Cloud Manifesto - what I think... more
  • ASP.NET binding with OpenAccessDataSource more
  • date validations more
  • Speeding Up FireFox When Using the ASP.NET Development Server from Localhost more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD