Install and Configure SQL Server

R

RyGuy

I downloaded SQL Server 2008 Express from here:
http://www.microsoft.com/express/sql/download/

I'm reading a book called 'Microsoft SQL Server 2008 Step by Step'. It says
I should have this:
Click Start | All Programs | Microsoft SQL Server 2008 | SQL Server
Management Studio

I can't seem to find it anywhere!! Do I need to download something else? I
have the .NET Framework installed and I have IIS enabled too.
Thanks,
Ryan---

PS, I know this is an Access Forum, and I don't know of any SQL Server
Forums. If you could give me a link to a good SQL discussion group I would
be most appreciative!!
 
T

Tony Toews [MVP]

RyGuy said:
I downloaded SQL Server 2008 Express from here:
http://www.microsoft.com/express/sql/download/

I'm reading a book called 'Microsoft SQL Server 2008 Step by Step'. It says
I should have this:
Click Start | All Programs | Microsoft SQL Server 2008 | SQL Server
Management Studio

I can't seem to find it anywhere!! Do I need to download something else?
Click to expand...

I do have that menu item on my system. And I would think I installed
the Express version.

Try re-installing it.

Tony
 
R

RyGuy

I uninstalled and reinstalled a couple of times. Must be something else.
I went here:
http://www.microsoft.com/express/sql/download/
clicked 'Download and install'
I also clicked 'SQL Server 2008 Management Studio Express (SSMSE)' and got
the 'SQLManagementStudio_x86_ENU.exe' file.

What am I missing?

Thanks,
Ryan---
 
R

RyGuy

I am running windows XP on a thinkPad T42. At work I used Windows XP and SQL
Server worked just fine. I didn't set it up at work though; it came
installed on my machine when I received it. I am now trying to set it up on
my home PC to practice with and learn whatever I can in my free time.

Thanks,
Ryan--
 
G

Gina Whipp

RyGuy,

If it's Windows XP Home that is most likely your problem. Did you check to
what versions of Windows it would install on? At your job they probably
used Professional which is why it works there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
R

RyGuy

Ok, so I found out that I didn't have SP1, so I downloaded it from here:
http://www.microsoft.com/downloads/...bb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en


Unfortunately, I am still missing 'SQL Server Management Studio'

I have 'Microsoft SQL Server 2008' and from here I can choose:
1) Configuration Tools
2) Import and Export Data (32 Bit)

Under Configuration Tools I have:
1) SQL Server Installation Center
2) SQL Server Configuration Manager
3) SQL Server Error and Usage Reporting

Any other ideas? I'm off to a bad start if I can't even open SQL Server.....
Ryan--
 
R

ryguy7272

Ah!!!! I recognized it when I saw it. That link was for 2005, and I wanted
2008, but after searching for 2008 for a bit, I was right back to where I was
a couple days ago...downloading from here:
https://www.microsoft.com/downloads...c2-1d62-45f6-9a4a-4b76a8564a2b&displayLang=en

Then running this executable:
SQLManagementStudio_x86_ENU.exe

No matter what, I couldn't get that thing to work. I can certainly live with
SQL Server 2005 Management Studio Express!!

Thanks so much Gina!!

Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Express 2008 installation problem 1
Max Users -- Access 2007 with SSE back end 0
SQL Server Backend is Read Only 7
Linked SQL Tables don't report Cascading Updates and Deletes 2
Installing SQL Server 2008 Express with BCM installed 3
How to change or update BCM SQL Server from 2005 to 2008? 0
SQL Server install error 1
Trouble installing SQL Server 2008 Express 0

Top