Geoffrey Emery
Tech Goodness

Installing Microsoft SQL Server 2008 February CTP

April 2, 2008 00:00 by gemery

I  have been burned by jumping into betas and CTP's before, but I am having major problems with not being on top of the geo-spatial data types in SQL server plus I think I might be doing a doing a presentation on this soon. So i took the plunge.

First Step install the thing..   You can download it here
http://download.microsoft.com/download/3/1/5/315b8683-3765-4426-96ec-179360abb82f/Download_Instructions_ENU.htm

Well that's really more of a download page, but you'll get the idea once you get there. I am running a 32 bit version of vista so it x86 version for me.

It rather big so it took me about 20 minutes to download at my office.

The next couple of shots are my installation.

Step 1) Installation Center

The installation Center? This totally new.  I am guessing this is due to the fact that its a CTP..But in a way i like it.

 sqlserverstep1

Step 2) Feature Selection

Yeah I don't need the replication settings. But the rest is like being in a candy shop..Mmm BI Studio...That sounds tasty..

sqlsetup2

Step 3) Instance Configuration

MSMSQL 0 Wow just when I thought I was getting good with 9.2.3042.00... I am all about the default on this one. I know I am going to uninstall this in a matter of a month when they release the RTM.

Man that was such a great build way better then 9.2.3041.00..

sqlsetup3

4) Ok this party was a bit tricky...My thoughts on this are this. I am installing this on my laptop. On one hand i want to have it all so I can get all the goodies at the same time I don't want my laptop to take a hour to start up so I disabled all but the browser and the Engine. Why on my laptop? Well I need to presentation on this i am going to need it. I tried all the service accounts use the sa account .. Yes i know this is not the good, but at this point I am just trying to get this up. It didn’t really work anyway's. So then i just set the username to nt Authority and it seemed  to take it all. Something about this is fishy.

 

 

sqlsetup5

5) Database Engine Configuration

Pretty Standard Stuff here

 

sqlsetup6

6)  Analysis Services Configuration

Pretty Standard stuff i am just setting up real basic permissions here.

sqlsetup7

7) Reporting Services

I really need to get more into this.. Its about 4th on my list to do a deep dive.

 sqlsetup8

8)   Errors and reporting....

Something about anonymous never really feels anonymous...Just kidding i checked it before i continued. Its a CTP they need all the help the can get to make the product awesome.

 

sqlsetup9

9) Sweet Lets do it...

sqlsetup10

10)  Install Away

sqlsetup11

 

About 45 minutes or so later...I looked over and it was done.. You have to restart but all in all it was pretty painless...

The Only New Screen that i wasn't comfortable with was the server configuration screen. I have a feeling that is going to come back to bite me.

What's New...more to come but i wanted to see what was up with the BI Set

Business Intelligence

Clicking on the Business Intelligence Dev Brought up Visual Studio....

image

But Inside my favorite IDE was this little edition

image T

This of course Makes sense.

Object Explorer

image

I am already loving the built in Intellisence its awesome. Minus the case sensitive part. i am going to have to turn that off.

You can see all the new stuff in here...Loving the resource Governor already..Now if only i could govern my resources more tightly..I can see it now..Sorry baby your limited to 20% of the clock cycles..I would give more but my main job is keeping me busy right now..lol

Well that's it for now..


Tags:
Categories: SQL Server 2008
Actions: E-mail | Permalink | Comments (1) | Comment RSSRSS comment feed

Related posts

Comments

April 2. 2008 10:07

James

Great job, thanks for doing all the hard work for me man.
J

James

Comments are closed