[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Connecting Remotely To My SQL SERVER 2005 Fails, Please Help.

Posted on 2008-02-04
3
Medium Priority
?
200 Views
Last Modified: 2010-03-19
Greetings Everyone!
I have this problem which I have been trying to sort out but so far no luck, I hope someone could help me with it, here it is:
I have Installed SQL SERVER Developer's Edition on my Windows Vista Ultimate, And I have Installed Microsoft Access 2007 on another computer on my LAN. When I try to connect to my SQL SERVER from my other computer using MS.Access the connection Fails, I get a message its contents summery is that "Server Doesn't Exists or Access Denied". I have checked the SQL SERVER 2005 Configuration Manager and I have Enabled TCP/IP protocol and Name Pipes as well, and restarted my whole computer  just in case, and I still can't connect to my SQL Server remotely using MS.ACCESS.
Could someone help please.
Thanks in advance.
~salman~
0
Comment
Question by:salman_sulaiman_2008
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
dampsey earned 2000 total points
ID: 20821212
if you have a firewall (external or vista default) please turn off the firewall and try again.
0
 

Author Comment

by:salman_sulaiman_2008
ID: 20821726
Greetings Dampsey!
It worked mate! I disabled the firewall and everything worked out beautifully.!
thanks!

~salman~
0
 

Author Comment

by:salman_sulaiman_2008
ID: 20821727
Greetings Dampsey!
It worked mate! I disabled the firewall and everything worked out beautifully.!
thanks!

~salman~
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question