Categories
Website Development

Reset MSSQL Login

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 […]

Categories
MySQL PHP Website Development

Accessing MSSQL from Linux using PHP MSSQL_CONNECT

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 […]