excel - ODBC connection to SQL Server 2008 through VPN failing -
i have excel add-in allows users run queries against sql server database , return results directly spreadsheet. works fine. there user in satellite office connecting our network (shared drive, etc.) through vpn connection. when uses same spreadsheets work in main office, gets following error: [dbnetlib] sql server not exist or access denied what strange if run individual query, works fine, seems running many queries in succession makes sheet crap out. it's little difficult diagnose excel add-in runs queries internally, possibly many of those. theory when db server sees many successive queries come in ip that's outside of network, there's point @ refuses return more data. is there validity theory? there configuration changes can make db allow remote odbc connections work well? in case interested, issue creating server-side cursor, , queries time out have pay network round-trip each cell in result set. started working fine when switched client-side cursor...