Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2007-11-27
2
Medium Priority
?
209 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 Worsham
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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

879 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