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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 only selected computers connect to Sql 2005

Author  Topic 

astramed
Starting Member

2 Posts

Posted - 2008-07-31 : 07:06:08
Could someone please explain why out of 8 separate computers 4 have connected to sql2005 using odbc and four have not. We are connecting from 4 different sites and each site has a computer that connected and one that did not.Obviously it is not the router firewall since one computer was able to connect at each site.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-31 : 23:33:18
Did you get any error from those unconnected machines?
Go to Top of Page

astramed
Starting Member

2 Posts

Posted - 2008-08-01 : 01:18:28
Thank you from responding. Yes the errors were sql errors 53 and 17 . Today I had the makers of the program I'm trying to network log into the computers and they could not solve the problem. We are using a vpn and the server has a RAS configured. I was able to log into the server with one of the clients and run the program by bypassing the ODBC module but the program is functioning weirdly like this alot of shimmering when the screen changes.What is going on here? Please help.Also I cannot ping the server but my client is listed on the domain server as connected. The RAS server has a separate IP address on ipconfig from LAN and WAN network interfaces.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-02 : 14:55:21
What are error messages? Did you try to ping the server with ip address? If still can't ping, there is network issue.
Go to Top of Page
   

- Advertisement -