Tuesday, May 05, 2009

Gotcha Of The Day: Accessing a remote instance of Microsoft SQL Server

I interact with MySQL and PostgreSQL all the time and I'm comfortable doing so via Unix command (my preference) or via myPhpAdmin or phpPgAdmin. So I was surprised how tripped up I got today when I needed to access a Microsoft SQL Server over a remote connection.

Trying to figure out which product I needed, and what if anything was free, was surprisingly tricky.

When it's all said and done, I found that Microsoft SQL Server Management Studio Express worked like a charm, and was even free to download. I just plugged in the hostname of the server the hosting provider gave me, and set it to SQL authentication, and I was accessing tables in no time.

Any great tools I should know about for MS SQL?

No comments:

Post a Comment