SQL Server enumeration and Windows Firewall

re: SQL Server enumeration and Windows Firewall

SQLLion — Tue, 21 Jul 2009 18:47:03 GMT

SQL Server – Driver Issues Resolver

Download the tool to remove discrepancy in SQL Server 2005 / 2008 like Missing foreach enumerators (File enumerator, Item enumerator), Missing OLE DB or Ado .Net Drivers.

http://www.sqllion.com/2009/07/sql-driver-issues-resolver/

Missing Foreach Enumerators

Missing OLE DB / ADO .net drivers

Missing Tasks or Components

Good site

elexx-ui — Fri, 06 Mar 2009 06:25:36 GMT

<a href= http://index1.reezina.ru >colibry im</a> <a href= http://index5.reezina.ru >�� qip</a> <a href= http://index2.reezina.ru >mip ��</a> <a href= http://index3.reezina.ru >samsung sgh p520 armani</a> <a href= http://index4.reezina.ru >miranda �� </a>

Error when trying to create new SQL Server login via ado.Net | keyongtech

Error when trying to create new SQL Server login via ado.Net | keyongtech — Thu, 22 Jan 2009 07:15:32 GMT

PingBack from http://www.keyongtech.com/2147157-error-when-trying-to-create

re: SQL Server enumeration and Windows Firewall

Me — Mon, 21 Jul 2008 11:40:57 GMT

It is a known bug since SQL server 7 that the browser server service is buggy and firewall incompatible especially in cluster scenarions: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354534

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=296165

Troubleshooting SQL Server Cluster Installations

SQL Protocols — Tue, 17 Jun 2008 06:02:21 GMT

On a Windows Cluster it is possible to install a SQL Server Cluster, which will be a separate entity

Remote SQL Server enumeration

amitranjan236 — Fri, 06 Jun 2008 22:24:43 GMT

Hi all,

I need to know how to connect to a remote sql server using a C# window application. Let me make, my issue more clear. I want to develop a application in C#, that can connect to any SQL server whether its local or remote using valid crendentials. I saw many appliations, that search automatically into LAN for SQL Server instances. But I want user to put either server name or ip address instead of searching for insatnces automatically.

Please help me out. if there is any online resource regarding this, please put it in reply

Thanks and regards

Amit Ranjan

re: SQL Server enumeration and Windows Firewall

Manan — Fri, 07 Sep 2007 14:55:59 GMT

Acually i was not getting the list of server availbale on the network. But this article helps me to find out the solution.

Thanx a lot

Good site

whinje — Wed, 23 May 2007 15:05:55 GMT

Hello! Thank you for your site. I have found here much useful information.

Thank you!

re: SQL Server enumeration and Windows Firewall

Dino — Wed, 18 Apr 2007 11:24:47 GMT

Hi - I've got a problem where only 1 of 2 SQL 2000 instances are showing, but they both have network protocols enabled, and neither are hidden - any suggestions?

re: SQL Server enumeration and Windows Firewall

Alan Williams — Mon, 15 Jan 2007 18:56:39 GMT

I have a local copy of sqlExpress and I am writing a program to find the Instance name of the servers on the network. With windows firewall on, it was not displaying the instance name. Adding Firewall exceptions for SQLBrowser did not work. Also TCP on Port 1433 and UDP on 1434 - both restricted to local network - did not work. Finally after removing the local network restriction for the exceptions - the program was showing the instance names. I presume that the database on my computer, is on the same network as the programm. Any suggestions why I cannot apply the restrictions for local network only.

Alan Williams