Solved and sql server 2008

Posted on 2008-10-22
Last Modified: 2012-05-05
Is there anything different i need to do to run or install sql server 2008 express compared to the 2005 express version?

 I have a website worling fine with 2005 sql Ex and have to prt it with 2008 ex which i just downloaded.

What else do i do to configure sql server 2008  ex?
Question by:jagguy
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22783177
as per my knowledge both are same ...

Author Comment

ID: 22783190
what was the name of sql server manager interface thing? ssmsmse?
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22783221
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.


Author Comment

ID: 22784090
i have winXP pro and previously I have got sql ex 2005 to work with and sql server smse.

your link says i need windows 2008 server and iis7?

I just want to test on my machine so i dont need a server for this.

Author Comment

ID: 22784100
PS I already installed sql server ex and i just downloaded and ran the file.
I did nothing of the sort with instructions below so I am confused?
LVL 51

Accepted Solution

Mark Wills earned 500 total points
ID: 22785626
Now, you are fine, the only area of difficulty is when you install 2008, it can get confused with the 2005 client. Best to uninstall 2005 client before loading 2008 - you can see 2005 server from the 2008 SSMS, so shouldn't present too much of a concern. There has been some issues when installing on server environments, simply because of various other tools that are installed (e.g. third party tools to monitor / attach to database). You should install as named instance to make sure there is no confusion with "(local)".

OK, so a bit of reading...

Then technet how to install :

Then 'guide' to working with multiple versions (from BOL) :

and if you do run into difficulties... here are a few links for you ... and maybe the following will help (sorry about the reading) :

Do you have 2005 or earlier installed as well ? In which case there is a bit more that could be complicating life...

Have you seen this ?

I have heard that "unless you remove the SQL 2005 client you cannot install SQL 2008 Client"  see :
It does talk about express, but is doing the "tools" version and is the same engine, so though it might be of some benefit...

Manny has a step by step installing 2008 on a 2005 box - shows a couple of interesting things :

Do you have SQL Prompt installed ?

Also, Keep a watch out for "SQL Server 2008 Cumulative Update" currently :


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question