Re: Upgrade from MSDE to SQL

Hard to say whether the database is of any use to you now you are partway
through the procedure. Although I've never had any problems doing this
upgrade I still always say when asked to take a backup before doing the
upgrade just in case.

If you have one from before, then presumably you can put your system back to
what it was and try again.
If you only have from now then you have little choice but to try to use it.

But FIRST (before doing either) I would in any case see if adding SQL Server
2K SP3A has any effect at all (and throw in a re-boot for good measure after
it).

Sorry to be sitting on the fence on this one.

Mike Walsh, Helsinki, Finland
WSS FAQ http://wss.collutions.com
please reply to the newsgroup only
private questions are not answered
"Kim59" <Kim59@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF58C498-33C9-4785-9758-723441965103@xxxxxxxxxxxxxxxx
> Thanks Mike - Obviously something is not right. Would it be wise for me
> to
> try and uninstall SQL then reinstall again to see if this works. I would
> backup my databases first. Your thoughts are appreciated.
>
> "Mike Walsh" wrote:
>
>> If the documentation says SP2 is required it is wrong.
>>
>> The usual way to upgrade a single server installation is to insert a
>> standard SQL Server 2K CDROM and do upgrade. It will say that you are
>> upgrading with a lower SP level but you ignore that and carry on. Once
>> the
>> upgrade is done you immediately run SQL Server SP3A. (these days maybe
>> SP4).
>>
>> I've done this several times with no problems although if installing a
>> new
>> WSS installation I don't these days go via WMSDE.
>>
>> Mike Walsh, Helsinki, Finland
>> WSS FAQ at http://wss.collutions.com
>> Please reply to the newsgroup
>>
>> "Kim59" <Kim59@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:0A061118-5729-4EC6-813D-D499D43E9DCF@xxxxxxxxxxxxxxxx
>> >I have performed the upgrade as outlined in the documentation on
>> >Microsoft's
>> > site. The site works fine however when I go into Enterprise Manager it
>> > shows
>> > that there is not connection to the SQL database. The service manager
>> > is
>> > not
>> > connected either. When I try to connect it tells me that the server
>> > does
>> > not
>> > exits or access is denied. When I did the upgrade I installed sp3, and
>> > then
>> > realized that the documentation on called for sp2. I am not sure if
>> > this
>> > is
>> > part of the problem. I need to be able to get into my database so I
>> > may
>> > create stored proceedure.
>> > Also this is a single server install, so I have WSS and SQL running on
>> > the
>> > same server. Any help would be appreciated.
>>
>>
>>


.

Relevant Pages