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

yes, I've tried all of these sugestions.

"Rick Byham, (MSFT)" wrote:

Have you enabled remote connection using the SQL Server Surface Area
Configuration tool?
Are you connecting to a named instance as <computer_name>\sqlexpress ?
Is the SQL Server Browser service running to resolve the name to the port?
The Books Online connectivity tutorial provides details on all these at
http://msdn2.microsoft.com/en-us/library/ms345318(sql.90).aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Josh" <Josh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:857A02EF-C1CC-493B-99CD-9813E123363A@xxxxxxxxxxxxxxxx
I diabled the firewalls on both pc to see if that would make a diffenence
and
it still doesn't allow the SQL to connect. Not really sure what could be
causing this if it isn't the firewall. Also tried switching between NAmed
Pipes and TCP/IP, still doesn't connect.

"William (Bill) Vaughn" wrote:

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 Resets
    ... If it were SQL that was falling short, ... The default backlog for SQL Server is 5. ... System.InvalidOperationException: Internal connection fatal error. ... From time to time, under heavy loads, we are getting resets at ...
    (microsoft.public.sqlserver.connect)
  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (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)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)
  • 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