Advertisement
- Home
- Microsoft
- Development
- MS SQL Server
- SQL Server 2005
- Connect to remote SQL Server 2005 Express database via ODBC
Advertisement
- 1. chapmandew 1,139,490
- 2. angelIII 656,012
- 3. aneeshat... 347,059
- 4. ee_rlee 305,823
- 5. dtodd 190,705
- 6. brejk 170,605
- 7. ptjcb 151,519
- 8. mark_wills 146,165
- 9. PFrog 98,658
- 10. acperkins 86,575
- 11. dqmq 75,630
- 12. dportas 74,146
- 13. momi_sabag 71,940
- 14. maradam 71,186
- 15. Thomasian 70,100
- 1. angelIII 1,936,203
- 2. chapmandew 1,139,490
- 3. aneeshat... 912,164
- 4. ptjcb 515,911
- 5. Yveau 505,473
- 6. dtodd 401,710
- 7. PFrog 368,686
- 8. dqmq 346,978
- 9. imitchie 324,100
- 10. ee_rlee 305,823
- 11. appari 277,897
- 12. Lowfatsp... 220,339
- 13. rboyd56 192,515
- 14. SQL_SERV... 183,215
- 15. acperkins 181,914
| 03.06.2008 at 05:25PM PST, ID: 23221790 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Connect to remote SQL Server 2005 Express database via ODBC
Zones:
SQL Server 2005, MS SQL Server
Tags:
Microsoft, SQL Server 2005 Express
I have just created a SQL Server 2005 Express instance running on Windows Server 2003.
I need to connect to this server over the internet using an ODBC connection. Although I am able to configure an ODBC connection locally and connect to the database, I am unable to connect remotely. ***The server is set for local and remote connections already***.
I would very much appreciate it if someone could walk me though what needs to be done server side and client side where the ODBC connection resides.
Thank you in advance.
Start your free trial to view this solution
I need to connect to this server over the internet using an ODBC connection. Although I am able to configure an ODBC connection locally and connect to the database, I am unable to connect remotely. ***The server is set for local and remote connections already***.
I would very much appreciate it if someone could walk me though what needs to be done server side and client side where the ODBC connection resides.
Thank you in advance.
Question Stats
Zone:
Microsoft
Question Asked By:
sinsoush
Solution Provided By:
kdc415
Participating Experts:
1
Solution Grade:
B
Views:
322
Translate:
Loading Advertisement...
Loading Advertisement...
| Microsoft |
- Internet Protocols
- Applications
- Development
- OS
- Hardware
- Windows Security
| Apple |
- Operating Systems
- Hardware
- Programming
- Networking
- Software
| Internet |
- Search Engines
- File Sharing
- WebTrends / Stats
- Spy / Ad Blockers
- Web Browsers
- New Net Users
- Web Development
- Chat / IM
- Anti Spam
- Web Servers
- Anti-Virus
- Email Clients
| Gamers |
- Tips
- Online / MMORPG
- Puzzle
- Emulators
- Action / Adventure
- Role Playing
- Consoles
- Game Programming
- Strategy
- Sports
- Misc
- Computer Games
| Digital Living |
- Hardware
- New Net Users
- New Users
- Software
- Digital Music
- Gaming World
- Home Security
- Apple
- Networking Hardware
| Virus & Spyware |
- Vulnerabilities
- IDS
- Encryption
- Anti-Virus
- Operating Systems Security
- Software Firewalls
- WebApplications
- Cell Phones
- Operating Systems
- Internet
- Hardware Firewalls
| Hardware |
- Handhelds / PDAs
- Displays / Monitors
- Components
- Networking Hardware
- Peripherals
- Laptops/Notebooks
- Storage
- Servers
- Desktops
- New Users
- Misc
- Apple
| Software |
- System Utilities
- Industry Specific
- Network Management
- Photos / Graphics
- Page Layout
- VMWare
- Misc
- Web Development
- OS
- CYGWIN
- Voice Recognition
- Message Queue
- Quality Assurance
- Security
- Firewalls
- MultiMedia Applications
- Development
- Database
- Office / Productivity
- Business Management
- OS/2 Apps
- Server Software
- Internet / Email
| ITPro |
- OS
- Storage
- Encryption
- Operating Systems Security
- Apple Hardware
- Laptops & Notebooks
- Servers
- Networking Hardware
- Peripherals
- Devices
- Displays / Monitors
- WebTrends / Stats
- Search Engines
- Firewalls
- WebApplications
- IDS
- Vulnerabilities
- Email Clients
- File Sharing
- Spy / Ad Blockers
- Web Browsers
- Web Servers
- Networking
- Anti-Virus
- Chat / IM
- Anti Spam
| Developer |
- Web Servers
- Web Browsers
- Game Programming
- Dev Tools
- Industry Specific
- Office / Productivity
- Database
- CYGWIN
- Web Development
- Search Engines
- File Sharing
- WebTrends / Stats
- Programming
- Content Management
- Application Servers
- Protocols
| Storage |
- Removable Backup Media
- Storage Technology
- Servers
- Grid
- Remote Access
- Backup / Restore
- Misc
- Hard Drives
| OS |
- Miscellaneous
- Security
- Development
- Linux
- VMWare
- MainFrame OS
- Unix
- Apple
- OS / 2
- AS / 400
- BeOS
- Microsoft
- VMS / OpenVMS
| Database |
- Oracle
- Miscellaneous
- MySQL
- Software
- Sybase
- Contact Management
- PostgreSQL
- Data Manipulation
- Clarion
- InterSystems Cache
- Siebel
- MUMPS
- OLAP
- SQLBase
- SAS
- GIS & GPS
- 4GL
- Berkeley DB
- DB2
- Informix
- Interbase / Firebird
- FoxPro
- Reporting
- LDAP
- Filemaker Pro
- MS SQL Server
- dBase
- MS Access
| Security |
- Misc
- Web Browsers
- Software Firewalls
- Operating Systems Security
- File Sharing
- Spy / Ad Blockers
- Vulnerabilities
- WebApplications
- IDS
- Anti-Virus
- Encryption
- Anti Spam
- Email Clients
- VPN
- Chat / IM
| Programming |
- Editors IDEs
- Installation
- Handhelds / PDAs
- Multimedia Programming
- System / Kernel
- Algorithms
- Game
- Signal Processing
- Project Management
- Open Source
- Database
- Misc
- Languages
- Processor Platforms
- Theory
| Web Development |
- Scripting
- Blogs
- Web Servers
- Software
- Search Engines
- Web Graphics
- Images
- Internet Marketing
- Images and Photos
- Components
- Document Imaging
- Web Languages/Standards
- Illustration
- WebApplications
- Fonts
- WebTrends / Stats
- Authoring
- Digital Camera Software
- Miscellaneous
| Networking |
- Protocols
- Apple Networking
- Network Management
- Message Queue
- Application Servers
- Content Management
- File Servers
- Email Servers
- Misc
- Java Editors & IDEs
- Wireless
- Networking Hardware
- Backup / Restore
- System Utilities
- ISPs & Hosting
- Web Servers
- Storage Technology
- Removable Backup Media
- Servers
- Broadband
- Grid
- OS / 2
- Novell Netware
- Unix Networking
- Windows Networking
- Security
- Telecommunications
- Operating Systems
- Linux Networking
| Other |
- Community Advisor
- Lounge
- Community Support
- New Net Users
- Philosophy / Religion
- Math / Science
- Miscellaneous
- URLs
- Expert Lounge
- Politics
- Puzzles / Riddles
| Community Support |
- Suggestions
- New to EE
- New Topics
- Community Advisor
- CleanUp
- Announcements
- General
- Feedback
- Input
- EE Bugs
| 03.06.2008 at 06:33PM PST, ID: 21066825 |
You would need to configure SQL to listen on a specific port and open that port in the firewall on the remote side, but that is not a good idea as it exposes the database to the internet. I would recommend setting up a VPN connecdtion between the locations/servers.
| 03.06.2008 at 07:07PM PST, ID: 21067014 |
Thank you for your response kdc415.
For testing purposes, would you please explain how I need to configure SQL Server Express to listen. I have the ability to open any ports I need to and I have Management Studio installed.
Thanks for your help.
For testing purposes, would you please explain how I need to configure SQL Server Express to listen. I have the ability to open any ports I need to and I have Management Studio installed.
Thanks for your help.
| 03.06.2008 at 07:28PM PST, ID: 21067119 |
Open the SQL Configuration Manager
Expand Network Configuration and click on Protocols then double-click TCP/IP
Click on the IP Address tab
Set the TCP port for the ip address you're connection to, 1433 is default for higher versions, use a non-standard port (like 1200 or something) to thwart attacks if you're going to expose it. (Not sure about Express, default may be 0 for dynamic?)
You'll need to use TCP/IP to connect, not SQL Native Client - not sure about your client app.
Expand Network Configuration and click on Protocols then double-click TCP/IP
Click on the IP Address tab
Set the TCP port for the ip address you're connection to, 1433 is default for higher versions, use a non-standard port (like 1200 or something) to thwart attacks if you're going to expose it. (Not sure about Express, default may be 0 for dynamic?)
You'll need to use TCP/IP to connect, not SQL Native Client - not sure about your client app.
| 03.07.2008 at 04:54AM PST, ID: 21069464 |
kdc415: "You'll need to use TCP/IP to connect, not SQL Native Client - not sure about your client app."
The client app uses an ODBC connection. This should be OK because I can set it to TCP correct?
The client app uses an ODBC connection. This should be OK because I can set it to TCP correct?
| 03.07.2008 at 06:58AM PST, ID: 21070670 |
That is fine. Just make sure the port matches what you set on the server. That is found by clicking the Client Connection button in the ODBC config screen. Hope this helps.
| 03.07.2008 at 07:47AM PST, ID: 21071255 |
I am able to do everything you discuss here. Then configure an ODBC on the local machine and works just fine. However, once I attempt to connect from another machine I get the attached error. The server running the sql server instance does not have virus protection or windows firewall running. The ports for 1433 and 1434 have been forwarded on the router.
I will be happy to give you the points for this b/c it does work locally, it just would be nice to know what is causing my issue?
I will be happy to give you the points for this b/c it does work locally, it just would be nice to know what is causing my issue?
| 03.07.2008 at 08:05AM PST, ID: 21071470 |
I assume you're trying to connect using the IP address and not the server name? Unless you have some name resolution ability for the client, you'll have to use the ip address.
If that's not it, I'll need to know more about the network topography. Is the client machine in private address space behind a router? Or have public address behind router? The next step is determining why the packets aren't getting through, or back to the client. Try scanning that port from the client.
Let me know what you find.
If that's not it, I'll need to know more about the network topography. Is the client machine in private address space behind a router? Or have public address behind router? The next step is determining why the packets aren't getting through, or back to the client. Try scanning that port from the client.
Let me know what you find.
Accepted Solution
| 03.07.2008 at 10:06AM PST, ID: 21072744 |
Yes, in the ODBC connection under 'which sql server do you want to connect to' I am entering the ip address\sqlexpress. I have also tried just the ip address with sqlexpress.
The client machine is behind a router with a private address. I will do some work to see about scanning the server port from client. I would assume I just need to scan port 1433...and 1434 if I use TCP dynamic ports?
Thank you for your continued assistance. I will get you my results and hopefully wrap this up soon!
The client machine is behind a router with a private address. I will do some work to see about scanning the server port from client. I would assume I just need to scan port 1433...and 1434 if I use TCP dynamic ports?
Thank you for your continued assistance. I will get you my results and hopefully wrap this up soon!
20080236-EE-VQP-29 / EE_QW_2_20070628
