|
Recent Articles |
How Much Does MySQL Make?
Reading Dave's post on MySQL's IPO range of $600M - $1B, I started to wonder what type of revenue we're talking about. If you have access to IDC's massive pivot table with Software Vendor revenues (license & support...
Getting The Autonumber Insert ID
I love this. So I assume most folks knew about the result attribute added to cfquery in ColdFusion 7. If not - you are missing out. It returns quite a bit of good...
MySQL Conference 2007, Santa Clara, CA
This is my first trip to Silicon Valley and the first thing that struck me as I approached the hotel was that I am certainly in one of the foremost tech havens on the planet. On the way down Great America Pkwy towards...
Removing Nulls From A DataTable
The individual cells in a DataTable can have a null value in the form of System.DbNull.Value. If the DataTable is created by querying a database through ADO.NET, you...
MySQL FULLTEXT Indexing & Searching
MySQL has supported FULLTEXT indexes since version 3.23.23. VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.
Installing A MySQL Database Using A MySQL...
Whenever you purchase or acquire a MySQL database (such as from a website like WebContents.org), chances are it will come as a MySQL injection script. An injection...
|
|
 |
|
08.14.07
SQL Server Express & Remote Access
 By Sean Corfield
What a pain this has been! I've never dealt with Microsoft SQL Server before but now that Vista runs acceptably on VMware Fusion, I figured that it would be a good opportunity to install SQL Server Express as a test database.
The download / install process was not bad but of course the default is that remote access is not allowed.
After much Googling and much messing around, I finally got everything working but I feel inclined to comment on some of the web pages out there that provide instructions on how to do this...
The correct, detailed instructions were on Microsoft's Support Site but that was not the first result in Google by a long way.
All of the top results seemed to have missing or incorrect steps.
A couple focused on opening up port 1433 in Windows Firewall.
The correct approach is to add sqlservr.exe and sqlbrowser.exe to the Exceptions pane.
At least one page focused on enabling access for a specific IP Address (and the instructions surrounding that were very complex!).
The key - from Microsoft's own support page - is to use the SQL Server Surface Area Configuration tool which makes life much, much simpler (although certainly not intuitive).
If I'd found that page first, I would not have wasted a couple of hours messing with a variety of control panels and utilities.
I so wanted to just open up a text file in an editor and fix things - this is exactly why I find Windows so frustrating and like Unix (and Mac OS X) so much better!
At the end of the day, however, I have a data source in ColdFusion 8 on Mac OS X which hits SQL Server on VMware!
Comments
About the Author:
Sean is currently Senior Computer Scientist and Team Lead in the
Hosted Services group at Adobe Systems Incorporated. He has worked in
the IT industry for nearly twenty-five years, first in database
systems and compilers (serving eight years on the ANSI C++ Standards
Committee), then in mobile telecoms, and finally in web development.
Sean is a staunch advocate of software standards and best practices,
and is a well-known and respected speaker on these subjects. Sean has
championed and contributed to a number of ColdFusion frameworks, and
is a frequent publisher on his blog, http://corfield.org/
|
