sql server 2008 express startup error

[Miro]

Hi,

I have sql server 2005 working just fine on my system.
I installed sqlserver2008 as another server on my vista machine (with a
different name than my 2005)...it all seems ok.

I can load up the SQL Server Management Studio - log in, create databases /
tables / add data and so on.

But I cannot access the server from inside visual studios 2008 pro.

So I go into the SQL Server Configuration Manager for 2008 and compare it to
my 2005 Configuration Manager.
It appears my SQL Server Agent is not running.

When I go into the properties of it and try to set it to manual or
automatic, I get an error on the screen:
(currently its set to disabled)

The remote procedure call faild. [0x800706be]
a couple seconds later I get a Microsoft Windows error:
WMI Provider Host stopped working and was closed.
-A problem caused the application to stop working correctly.
Windows will notify you if a solution is available.

Is there a service pack or some fix I need to install.
I dont mind uninstalling sql server 2008 and re-installing.
I have googled a bit, but cant seem to find a 'straight' answer to the error
im trying to track down.
I am logged in as administrator.

I just wanted to play with 2 servers on my machine - one that was 2005 dev
edition that came with my vs2008, and the other being 2008 express that I
downloaded.

Thanks,

Miro

 

[Mr. Arnold]

I just wanted to play with 2 servers on my machine - one that was 2005 dev
edition that came with my vs2008, and the other being 2008 express that I
downloaded.

Well Apprentenly, it's either one or the other not both on the same machine.
You can do it with SQL Server 2005 and SQL Server 2005 Express, as I have
done that and used them with no problems on the same machine. There are to
many common things like DLL(s) that are being used by both 2005 and 2008 to
have them both running on the same machine and not have any problems, IMO.

You might want to post to a SQL Server forum at msnew.microsoft.com.

 

[Miro]

Thank you for the reply.

I will find a dummy machine to install the 2008 express.

I just wanted to play with 2008 a bit to see what really has changed and
stuff.

I am happy with 2005 for now.

At least it saves me some hard drive room

M.

 

[Miro]

To add to this thread - incase anyone else is thinking of doing the same...

to uninstall all 2008 sql progs - it wants to uninstall all 2005 progs... so
you cannot clean it off as a simple unisntall of 2008...
It ALL must go - and then 2005 must be re-intalled.

Miro