Hello, I want to use SilverStripe 2.4 for a new website project. Just a quick question: is it possible to access MSSQL on an external MS Windows 2008 Server from another LAMP-installation? Or do I have to install SilverStripe 2.4 on a Windows 2008 Server with PHP enabled?
You can point to an external database server. In fact thats how I run all my mssql projects. When you define your database instead of using localhost simply use the IP or domain of the server you wish to connect to.
Thanks for responding, but I wasn't specific enough.
This is the case:
Silverstripe 2.4 installed on Linux-server with MySQL. My client has database tables in another external MS SQL Server 2008 which have to be read in in het LAMP-hosted SilverStripe site. What's the correct way to read in those external MS-databases in the SilverStripe website? Where do I have to configure this and how can this be done?
Please, is here anyone on this forum with some detailed info about:
- installing Silverstripe 2.4 on Linux/Apache/MySQL/PHP5
- import data from external MS SQL databases on another server?