Re: SQL Server 2005 Express Fail to connect with Vista PCs

I was having a similar problem but was able to get it to work when I
disabled the firewall. This tells me that I needed to do some custom tuning
thereof.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Josh" <Josh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F867A7D-2EDC-4C52-9394-ED56CD1339B1@xxxxxxxxxxxxxxxx
Trying to get a Vista PC to connect to the SQL Server 2005 Express on
another
Vista PC. The PCs do have access to each other. The PCs can access the
shared folders from each other. Both PCs can ping one another. The SQL
is
the only item that does not allow access to.

We have looked at and done all the steps in the knowlage database on the
microsoft site. We have added the sqlservr.exe and the sqlbrowser.exe to
the
firewall exceptions. We have tried the SQL connection with both PC
firewalls
off to elimate a firewall issues. We have turned off all third party
software that may be interfering with the connection. The SP2 for SQL
2005
has been applied. We have uninstalled the SQL and reinstalled the SQL .
If
someone could help us, have any suggestions, or have any comments about
this
connection issue we would be happy to here from you.


.

Relevant Pages

  • Re: SQL or ISA firewall problem
    ... the I lose the connection. ... > It looks that ISA Server is not configured for the SQL Server port 1433 to ... > incoming SQL Server connections. ... If I disable the ISA firewall client I can run ...
    (microsoft.public.sqlserver.connect)
  • Re: newbie Frage zu Server-Explorer - Datenverbindungen
    ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: SQL Connectivity Lost after Reboot
    ... While connections are established to a Virtual SQL Server IP, the reply header shows the IP address of the underlying physical NIC, not the SQL virtual IP address. ... add the physical IP address from both host nodes to the allowed filter on the firewall. ... Appraently the webserver is able to establish connection to the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Kerio 2.1.5 Blocking SQL remote server
    ... Are you using SQL server or windows integrated authentication? ... Are there any other rules or default settings in your firewall that override ... I am using an ODBC connection as ...
    (comp.security.firewalls)
  • Re: How to enable Analysis Services with IIS on Win 2K
    ... Assuming that there is no firewall involved I don't see why not. ... >> Can you bring that up though the Intenet connection? ... >> SQL BI Product Unit ... >>> client machine, connected through the Internet, located outside the ...
    (microsoft.public.sqlserver.olap)
Loading