Read-access for public or for dynamic IP?
We work with a company that wants to host some of our listings on their website, but we use a database and they don't have a "dedicated IP" like we do, so I can't just put their IP in the "safe" list...
Is there some way to allow them read-access to our database?
Just create user in security with read only access to that specific database.
MS SQL have variety of different levels to choose from.
In general, you want to avoid allowing database connections from any IP address. Build a simple web service or page to relay the needed records in a JSON, XML, or CSV format, over SSL, if desired, and contingent on some agreed upon access key (or "password").
There is a third option:
If your network admin familiar with VPN you can allow them authorized access to your database via VPN connection.
And yet you will need specific user with read only access.
Because even over super secure connection you do not want anyone connect to your database server and mess with unintended data.
Or that can be achieved by web service to throw all data in XML format at authorized request...
Last edited by alexsts; 06-05-2012 at 04:26 PM.
Unless you're a developer telecommuting from home over VPN. (Okay, excuse me while I get back to work... )
Originally Posted by alexsts
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
NogDog is correct, VPN access is for developers not for displaying your content on someone site.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)