Connecting Remotely To My SQL SERVER 2005 Fails, Please Help.
Posted on 2008-02-04
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.