<div>
You could install/utilize an SQL ODBC driver to allow connections via the Internet to the SQL server. <br />
<br />
Also, remember to open the TCP &amp;&nbsp;UDP ports on the firewalls to allow the systems to connect. Default installations of SQL Server monitor TCP port 1433 and UDP port 1434.<br />
<br />
Verify ODBC connectivity to SQL Server: <br />
<a href="http://support.microsoft.com/kb/138541" rel="ugc nofollow">http://support.microsoft.com/kb/138541</a><br />
<br />
Building SQL Server Applications Overview<br />
<a href="http://msdn2.microsoft.com/En-US/library/aa174556(SQL.80).aspx" rel="ugc">http://msdn2.microsoft.com/En-US/library/aa174556(SQL.80).aspx</a><br />
<br />
TCP Ports Needed for Communication to SQL Server Through a Firewall<br />
<a href="http://support.microsoft.com/kb/287932" rel="ugc">http://support.microsoft.com/kb/287932</a><br />

</div>


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 [http://support.microsoft.com/kb/138541]

Building SQL Server Applications Overview
http://msdn2.microsoft.com/En-US/library/aa174556(SQL.80).aspx [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 [http://support.microsoft.com/kb/287932]


<div>
<div class="content wysiwyg-content">
Our Website is hosted by a third party company. &nbsp;We want to enter events into our Microsoft CRM that stores everything in SQL Server on a SBS2003 server in our office. &nbsp;The server in our office is running IIS and exchange so we have access out to the internet. &nbsp;How do we do a query over the web to read from the database so we can display the results on our website?
</div>
</div>


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?

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

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.

Enterprise Software

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.

Microsoft IIS Web Server

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).