asked on

Hosting mssql DB on Internet based mssql instance

We have a scenario where the local web app needs to access a remote internet based mssql instance. I have a few questions?

Assuming the transactions are low and not high disk IO is this even possible? There will be a 20mbps bottleneck

Is there an encrypted sql client? If so, does this run on a different port?

ASKER CERTIFIED SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jerry_Justice

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gopher_49

ASKER

Arnold,

It's an existing desktop application. For now they want the DB remote, however, I'm proposing an application sever to push the app and in return have the mssql instance local.

Jerry,

I'll find out more details in regards to the type of transactions. We can easily setup a site to site tunnel, however, the app server deployment I mentioned above makes the most sense to me.

I'll reply back shortly

arnold

Internal app likely is not "optimized" and potentially .."..

What is the basis, what are they under the impression of archiving with mssql in the cloud?

Line of business, restrictions, requirements.

gopher_49

ASKER

I have no idea do their logic in this.. They are confused.. I'm only suggesting one config. Our app server pushing the app to them and in return the mssql instance local to the app server.

I'll let you all know something soon...

gopher_49

ASKER

After reading both of your responses I feel I'm better off simply publishing the desktop app via 2X and keeping the mssql instance on the same LAN as the app.