Can we use Windows hosting of one Hosting provider and MS SQL database from other hosting provider?

Hi,

Can we use Windows hosting of one Hosting provider and MS SQL database from other hosting provider?
If yes, is it OK to have such an arrangement?

Really appreciate your response!

meetpdAsked:
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.

red_75116Commented:
yes, as long as you have a connection string for your ms sql database, you can connect from anywhere.  Your upload and download from the sites will count for your bandwidth so it makes sense to have them on the same server but it is possible.
0
AsishRajCommented:
Yes, you can have it but cons will outway the pros.

If you are thinking in terms of security then it would be advisable to buy a security certificate for your website.


0
meetpdAuthor Commented:
AsishRaj,

I have a security certificate. But the thing is, I have ended up buying two web hosting packages (dont ask me why). The new webhosting package requires me to pay seperately for ms sql database.

Hence I was thinking of using ms sql database which I had from my previous web host.

Keeping above situation in mind, what according to you, would be the problems that I need to be aware of?

Thanks!
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

meetpdAuthor Commented:
The web hosting packages are from two different web hosting companies...
0
AsishRajCommented:
if thats the case you can ask for money back as i am sure they should have given you a money back option.

0
red_75116Commented:
meetpd,

the biggest issue would be speed.  your queries will be faster if they are with the same hosting companies.  Dpending on your application, it might not be an issue.
0
meetpdAuthor Commented:
I am not sure of money back option...but what could be the problems that I might face in such an arrangement?
Will speed be an issue?
0
AsishRajCommented:
Lets C some Cons
  • Speed depending of type of queries done, etc, where are the two webs hosting companies located -> speed limit associated with their processing of info as well
  • will need a higher Traffic limit because of the queries done to DB to and for - extra traffic limits means extra cost
  • Security -> Need to encrypt any info to and for DB -> if you have sensitive information like customer Credit Card details, etc . Simply in other term we call to avoid hackers.
There are more issues if you do some research.

As for pros, i really dont have any good points

0

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
meetpdAuthor Commented:
I got your point. Thanks!
0
JaressLooCommented:
This really depends on your host. Unfortunately, most companies do not allow remote SQL connections. This is to prevent exactly what you're trying to do.

I had this issue a while back. I ended up just going with godaddy's new unlimited plan. You should check it out.
0
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
Networking

From novice to tech pro — start learning today.