MSSQL Table access in a Faststack deployment

[JDTurner]

Hi

I have an installation of Sugar 6 running on Apache and MSSQL deployed using the faststack installer.

Is it possible to access the SQL tables directly from an MS SQL Server console. I am working with one of our MSSQL db people to provide some integration to our ERP system so ideally we are looking to populate data directly overnight.

At the moment we do not seem to be able to connect so I am wondering if it is something to do with the FastStack installation.

Thanks

Justin

[Angel]

It shouldn't be a problem as Sugar doesn't lock you out of the backend through any of its installers.

Take a look at the config.php file in the Sugar program files directory and it should contain the SQL login credentials/connection info that would permit you to connect.

[JDTurner]

HI Angel

Thanks for this. we now have a connection the the DB tables.

Thanks for you help

Regards

Justin