Solved

How do I  query a SQL Database on a different server from a hosted website

Posted on 2007-11-27
2
199 Views
Last Modified: 2013-11-24
Our Website is hosted by a third party company.  We want to enter events into our Microsoft CRM that stores everything in SQL Server on a SBS2003 server in our office.  The server in our office is running IIS and exchange so we have access out to the internet.  How do we do a query over the web to read from the database so we can display the results on our website?
0
Comment
Question by:utahspc
2 Comments
 
LVL 29

Expert Comment

by:Michael W
ID: 20359111
You could install/utilize an SQL ODBC driver to allow connections via the Internet to the SQL server.

Also, remember to open the TCP & UDP ports on the firewalls to allow the systems to connect. Default installations of SQL Server monitor TCP port 1433 and UDP port 1434.

Verify ODBC connectivity to SQL Server:
http://support.microsoft.com/kb/138541

Building SQL Server Applications Overview
http://msdn2.microsoft.com/En-US/library/aa174556(SQL.80).aspx

TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/kb/287932
0
 
LVL 9

Accepted Solution

by:
Biffster007 earned 500 total points
ID: 20362238
Hi,

Yep, that's one way of doing it although there is always a potential risk associated with giving direct access to your CRM SQL database from the internet.

Alternatively you could setup some sort of reporting structure where reports are made available on your website.

And yet another alternative is to setup a web service which your website can connect to which in turn retrieves the data you want to display on your website and passes it back to the caller of the web service.

Cheers,
MH
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now