connecting 2 different companies together?

I have the following situation that I need some help with.
My company host a CRM system, the front end is on our web server and back end (SQL DB) is located on it's own crm server, external users can access the system by using a web log in where they can run reports ect and get access to the CRM outside the business.
We have an external company who we need to provide a front end web log in just like ours which will sit on our web server but links to their SQL DB so they are basically using our web server for the log in and then route to their server and access their DB.
Any advice would be great.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Is this Microsoft CRM, or is it a custom CRM app ... or something else?

Microsoft CRM has an Internet Facing Deployment setup that will allow you to accomplish what you're trying to do.  However, you'll need to buy a full license for every user using this approach.  You could also buy an external connector license and get a partner portal web app to keep costs a bit lower (assuming you have a lot of external users).

If you're using something else, then I would imagine that it would be somewhat similar - you would need to provide access to your web-based CRM solution without requiring users to go through your firewall, just like any public facing website or web application.

If you have a lot of secure data in your network, and you're using a home-grown CRM app, then you may want to consider moving your CRM and SQL servers to a separate hosting facility to keep them arms-length from your IT innards.
Techno-Man-ukAuthor Commented:
yes i am using microsoft crm the internet facing deployment sounds useful.
Okay, that helps.  You can peruse the Microsoft CRM Implementation Guide for instructions on installing the Internet Facing Deployment (IFD).  

Implementation guide:

Instructions on using the IFD:

Hope that helps.

BTW: The above assumes you're on CRM 4.0 (3.0 does not have an IFD setup, though there are other options you can take advantage of).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Techno-Man-ukAuthor Commented:
yes im using 4 so will give it a go cheers for that
Techno-Man-ukAuthor Commented:
would the IFD allow me to link the 2 companies togther or would I need to set up a VPN or something similar as well?
Techno-Man-ukAuthor Commented:
Also If the sql db sits in another companies domain will the IFD allow me to run searches on it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.