Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bgspills
Starting Member
2 Posts |
 Posted - 2003-10-08 : 11:49:22
|
| I have 2 different networks connected by a VPN. I have a SQL Server on my local network. I have 2 computers on the other network running software running OLE DB Provider. The only difference between the 2 computers is that one is running version 2.5 MDAC. The other one is running 2.7 MDAC. The one with 2.5 works fine. The 2.7 one cannot see the SQL server. Its gives me a "Description :SQL Server does not exist or access denied Source :Microsoft OLE DB Provider for SQL server". The weird part is if I take the PC that doesn't work and put it on the local network with the server it works fine. The only thing I change is the IP address on the PC. New to SQL Server so any help would be great. |
|
|
dupati1
Posting Yak Master
123 Posts |
Posted - 2003-10-08 : 12:04:35
|
| If the version of your SQL Server is SQL SERVER 2000, then you need MDAC 2.7 on the computer, else you might need other MDAC versions.Why dont you try downloading the MDAC 2.5 on the computer which doesnt see SQL Server.I am not sure whether my suggestion is right or wrong but give it a shot.ThanksVJ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-08 : 12:37:03
|
| Have you tried creating an alias to the SQL Server on the problematic client machine using Client Network Utility? The error that you are getting indicates a network problem which could mean firewall rules, incorrect settings, need an alias created, etc...Tara |
|
|
|
|
|
|
Connection Problems