Install sqlcmd on Mac OS X

In case you need to run SQL Server scripts from your Mac, do the following to install (NOTE: I use HomeBrew.):

    • From the terminal, type:

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
ACCEPT_EULA=y brew install --no-sandbox msodbcsql mssql-tools

    • You should see something like in the screenshot. Type “YES” if prompted and be on your way.
    • Once done, type:

sqlcmd

Enable root in OS X Yosemite and El Capitan

I needed to do some file moving between users and noticed my admin account didn’t have access, so I tried “su” and “sudo” without success. Apparently, like it Yosemite, root access is disabled by default. Here’s how to enable it:


1. Open Directory Utility (I usually do it via CMD + spacebar, then type "dire")
2. Go to the Edit menu and select "Enable Root User".
3. Enter your desired root password twice.
4. That's it!

Test it out in the terminal by doing:


$ su -

Happy rooting, yo!

Homebrew: How to install on OS X

Since moving to OS X in 2011/2012 for work to do all my development, I’ve moved Homebrew to a must-have. Adding it here for archiving purposes.

From a terminal:


1. /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

2. brew tap caskroom/cask

The 2nd point is to install Homebrew Cask as well, which extends Homebrew’s functionality.

Now get brewing!

Firefox: “You are not authorized to view this page” when connecting to intranet

In case you get the error below when connecting to your Windows-based intranet using Firefox, here’s the fix:

1. In your toolbar, type “about:config
2. Search for “network.negotiate-auth.allow-insecure-ntlm-v1” and set it to “true
3. That’s it. When you access the site, it will now ask you to enter your domain creds

You are not authorized to view this page
You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept.

Please try the following:

Contact the Web site administrator if you believe you should be able to view this directory or page.
Click the Refresh button to try again with different credentials.

HTTP Error 401.2 – Unauthorized: Access is denied due to server configuration.
Internet Information Services (IIS)

Technical Information (for support personnel)

Go to Microsoft Product Support Services and perform a title search for the words HTTP and 401.
Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Authentication, and About Custom Error Messages.