SQL Express 2008 SP1 upgrade

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Neil <Neil@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 12 May 2009 06:16:01 -0700

Hi,
Not sure if I'm in the right place here.
I'm running SBS 2003 with the embedded SQL5.
A developer has deisgned me a custom app that he could not install with
SQL5, he therefore installed SQLExpress 2008 on my server he could then
install his app.

My problem is that me Server PC has recently picked up the SQL2008 SP1
upgrade and now I can not connecct to the SQL2008 express.

If I try and connect with the SQL management studio I get an error stating
that the Serveris in script upgrade mode and only Administrator can log in -
but it will not let me log in as administrator, or it tells me that the SQL
server is not set to accept remote connections.
I have unistalled the Service pack and still no change, I have tried to
repair install the SQL Express 2008again with no success.

Any further suggestions ?

Thankyou

.

Follow-Ups:
- RE: SQL Express 2008 SP1 upgrade
  - From: Neil

Prev by Date: RE: Full Text Indexing Performance?
Next by Date: Re: Where is Sql Server Configuration Manager
Previous by thread: Where is the SQL Reporting Services?
Next by thread: RE: SQL Express 2008 SP1 upgrade
Index(es):
- Date
- Thread

Relevant Pages

Re: Is it possable to move a 2003 install to a new server ?
... Just trying to prep for a newserver that will be coming in about ... I would like to move this install over ... Imaging can be fabulous, but the server products aren't cheap, imaging isn't ... If you were to ignore the custom app stuff & just deal with a reinstall ...
(microsoft.public.windows.server.general)
Re: New Event Log Errors!
... Somehow along those lines I'd also installed the Certificate Authority ... Did you apply the last Server Pack for SBS Server? ... Please install Windows Support Tools on the win2k3 sp1 problematic ... Microsoft is providing this information only as a convenience to you: ...
(microsoft.public.windows.server.sbs)
Re: Cannot activate SBS 2003 SP2
... everywhere and sitting on the case of the server is the old board - balanced ... slip stream SBS you would have had it ages ago. ... My main reason for slipstreaming the install is because I cannot get ... updates that need to be applied if one is to have a succesful outcome ...
(microsoft.public.windows.server.sbs)
Re: Cannot activate SBS 2003 SP2
... everywhere and sitting on the case of the server is the old board - balanced ... slip stream SBS you would have had it ages ago. ... My main reason for slipstreaming the install is because I cannot get ... updates that need to be applied if one is to have a succesful outcome ...
(microsoft.public.windows.server.sbs)
Re: Cannot activate SBS 2003 SP2
... the old array was a raid 5 that should not have become so rooted but the twit who built the server did not actually enable the spare drive to act as a spare!! ... The problem is SBS is unique and I've rarely if ever seen it work. ... The server has been chugging away in a small business environment for several years and I have administered it for them for about a year making sure that the updates were installed and their mailboxes were managed etc etc. ... My main reason for slipstreaming the install is because I cannot get the original 2003 server install to cope with the new hardware and it falls over part way into the install - BSOD bit. ...
(microsoft.public.windows.server.sbs)