Groups | Blog | Home
all groups > sql server connect > june 2007 >

sql server connect : SQL Server 2005 Express Fail to connect with Vista PCs


Josh
6/12/2007 9:17:02 AM
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
William (Bill) Vaughn
6/12/2007 9:39:06 AM
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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]

Josh
6/12/2007 1:45:01 PM
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.

[quoted text, click to view]
Rick Byham, (MSFT)
6/13/2007 12:59:37 PM
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.

[quoted text, click to view]
Josh
6/13/2007 2:01:02 PM
yes, I've tried all of these sugestions.

[quoted text, click to view]
Rick Byham, (MSFT)
6/14/2007 8:50:15 AM
What error are you getting?
Vista doesn't automatically let you use Administrator credentials. Are you
relying on the membership of your domain login in the Local Administrators
group to provide your SQL Server permissions? Try adding domain credentials
to SQL Server as a login with membership in the sysadmin group. One way to
do this, is from the SQL Server Surface Area Configuration tool. On the
opening page, click Add New Administrator.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
AddThis Social Bookmark Button