Tag: MSSQL

Reset MSSQL Login

Published on October 28, 2016 Author JFLeave a comment

You have Admin rights to the machine, but you set up Microsoft SQL Server as SQL only login with SA, but you’ve forgotten your password. Here’s the dead easy way to reset this, including adding the Admin account and setting it for dual authentication. Note: due to lots of machine names, etc, I’m going to use… Continue reading Reset MSSQL Login →

Accessing MSSQL from Linux using PHP MSSQL_CONNECT

Published on July 15, 2016 Author JFLeave a comment

MSSQL_CONNECT and MSSQL in PHP on Linux You’ve yum installed php-mssql and you’re still tearing your hair out because you can’t connect to MSSQL from Linux. In this case it’s CentOS 6.7 with PHP 5.6.23 and Apache 2.2.15. You’re using mssql_connect in a basic test script like this one: <?php #################################### # PHP error handling for… Continue reading Accessing MSSQL from Linux using PHP MSSQL_CONNECT →