Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Access external MSSQL 2008 Server tables


Reply

4 Posts   1111 Views

Avatar
melman

1 June 2010 at 9:24am Community Member, 3 Posts

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?

Avatar
Willr

1 June 2010 at 4:52pm (Last edited: 1 June 2010 4:53pm), Forum Moderator, 5511 Posts

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.

Avatar
melman

21 June 2010 at 7:08am Community Member, 3 Posts

Willr,

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?

Avatar
melman

22 June 2010 at 2:54am Community Member, 3 Posts

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?