Solved

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

Posted on 2007-11-27
2
198 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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Read about achieving the basic levels of HRIS security in the workplace.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

762 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