Playing with SQL 2012…(and a rookie mistake)


So I thought I would install SQL 2012 Express with Advanced Services on a Windows 2008 R2 box in the hopes of playing with the new edition and using it as a platform for a new SQL Monitor Solution I am building.

First thing I learned, the hard way, was .NET 3.5 SP1 (which is required for SQL 2012) is not “enabled” by default on Windows 2008. It is installed, but not enabled.  Open System Manager and find “Features”.  Click “Add New Feature” and select .NET 3.5.  This will prompt you to enable IIS and all associated features need to enable .NET 3.5.

Once this pre-requisite was “installed” installation of SQL Express went without a hitch.  I used default settings in most places, except for Service Account information.  I setup a domain service account to run the SQL Services.  All was good.

I then opened SQL Server Configuration Manager to enable TCP/IP connection so I could have remote access.  Except one simple problem, I couldn’t connect.  I double checked all my steps, and still could not connect.  After some “Bing”-ing (I dislike that G company), I realized my “rookie mistake”.  Thanks to this 7 YEAR OLD blog post, realized I forgot to enable SQL Browser.    http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

Silly, silly me!

Advertisements

Posted on April 24, 2012, in SQL, SQL 2012. Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Humor Me a T-SQL Princess

DBAs really do have a sense of humor

Andrea Allred presents RoyalSQL

Bringing happy endings to all your data stories.

IDERA Community

A community site for users of all IDERA product and SQL community members.

Strate SQL

Data Adventures with a Architect

SQL Sanctum

A Join on SQL And Everything Else

Grant Fritchey

Intimidating Databases and Code

rhondastephens

To Catch A Falling Cactus

SQLSwimmer

Swimming through the Sea of SQL

SQL Studies

 Live, Learn, Share

Aunt Kathi's SQL Server Home

Learn SQL Server from your favorite aunt!

Jen's Blog: We Owls

...stuff. Also, things.

Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL

Voice of the DBA

Writings from Steve Jones, the Voice of the DBA

Glenn Berry's SQL Server Performance

Semi-random musings about SQL Server performance

%d bloggers like this: