Print Page | Close Window

Connecting to Remote Server from Vista machine

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=755
Printed Date: 11-Jun-2026 at 4:48am


Topic: Connecting to Remote Server from Vista machine
Posted By: BillG
Subject: Connecting to Remote Server from Vista machine
Date Posted: 05-Apr-2008 at 9:04pm
I have an app that connects to a remote SQL Server through a VPN.  The app connects fine from XP machines but fails to connect from a Vista machine.  It can't seem to even find the sql server.  This is not an Ideablade problem because I have another app which just uses ado.net without Ideablade and I can't connect from a Vista machine.  I have tried turning off the firewall.   I have tried it using both Vista Business and Vista Home Premium.  The error that I get is
 
"[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied."
 
  There are dozens of suggested solutions by searching Google but none of them work.  I am guessing that the problem can't be server related since it is working from XP.  It has to be a Vista problem.   Have anyone seen this problem and can give me a solution?  Obviously my easy solution is to tell the client that they can not move to Vista but as they buy new machines it is getting harder to find XP machines.  And that is probably not the best professional solution.



Replies:
Posted By: BillG
Date Posted: 29-Apr-2008 at 7:36am
I solved the problem.  When connecting to a SQL Server database remotely from a Vista machine, the configuration string must use the ip address, ip port for the data source instead of the name of the server.
 
ex.  data source=192,168.100.5,1433 not SQL_SERVER
 
Although the name of the server works from XP, it doesn't from Vista.
 
 



Print Page | Close Window