Re: MSSQL on XP-Pro

I don't know whether to horrified or impressed that everything has worked so
well. <g>
And I'm not entirely sure I understand your situation, but here is a start.
- SQL Server has different CD's than Windows.
- Sorry, I don't know anything about Solomon IV
- These old versions of SQL Server should run on XP. It's not clear to me
if 6.5 or 7.0 is properly installed. If you don't see either of them in the
services applet, then probably not. And you should run setup from the CD to
install them. You might look in Add and remove programs to see if Windows
thinks one of them is installed.
- If you need CD's of SQL Server, the fastest way would probably to go to a
used bookstore/software store and see if they have some disks. 6.5 and 7.0
are now 4 and 5 versions behind so my guess is they might sell them for 5
bucks. If you upgrade to SQL Server 2000, 2005, or 2008 you will have to be
careful about which old version can be upgraded to your new version. I won't
go into that, since I'm guessing you probably don't want to spend any
significant money for the upgrade.
- There are two ways to upgrade. One is to have a working 6.5 and select
upgrade when you run the 7.0 install. The other is to install 7.0, and then
attach the 6.5 database files.
- Do you have recent backups stored on another computer, preferably at
another location? It sounds like this info is important to you so I sure
hope so.

I hope this helps.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Dobermann" <Dobermann@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B7A69DB7-813D-4EBA-A97A-3D11C28B6CD9@xxxxxxxxxxxxxxxx
I'm in a bit of a wacky situation. I have not shut the server off (it
runs
in my garage 24X7) in the nearly 9 years that it has been there. I am
actually afraid to shut it off, for fear that it will not start up again.
I
have not upgraded it in that time, and as far as I know, it is just a
Windows
NT Server circa 1998/1999 (pre 2003 version).

It is fully licensed, but today I went to the storage facility to look for
the Server CD and could not find it, nor could I find a CD or diskettes
for
MS SQL (is it separate from the server CD?). I think I may have brought
home
the server CD and mislaid it 9 years ago, but I do not remember ever
seeing
the MS SQL CD (I am not the former IT person).

My problem is this. Because it has been running like this all these years
in the garage with the 115 degree summer heat and dust, I am terribly
afraid
that it will just up and die pretty soon. I have almost everything I need
off of it backed up on another hard drive, with the exception of the
accounting software.

It has Solomon IV (formerly MS product) running on the server. I still
have
to do monthly accounting and do not know what I would do if the server
died,
as Solomon only runs on the server. The data alone will not be much good
to
me in the event of the server's death.

Trying to be a good girl scout here, I thought of putting MS SQL 6.5 (7.0
upgrade) on a fresh XP Pro install. I know I cannot just copy the 6.5 and
7.0
upgrade across to the XP box and expect it to work. But I did copy it
over
nonetheless. Within the 6.5 directory was a file called Setup.exe.

Running this file aborted with a message saying that I could not install
6.5
as I already have 7.0 installed. This is weird, as yes, I had tried via a
DOS prompt to do an install of 7.0 (I forget what commands I did), but
when
that did not work, I restored an Acronis image that I made just prior to
trying to install. It cannot possibly know it was there, as Acronis does
a
complete HD wipe before it reloads the image. (It took nearly 5 hours to
do
the restore, as this box is USB 1.1 pushing 10G of data - yuck!)

So what is the secret with XP and SQL? I do not see it as a service, yet
XP
thinks it is there. How can I get SQL working? I am pretty sure I can get
the Solomon IV part working once I get SQL going.

I'm pretty certain that our former IT guy registered the SQL with MS if it
required separate registration. How or who do I contact at MS to see if
he
indeed did and what our S/N is along with getting another copy of 6.5 if
need
be?

I really need help here guys. I am sorry this is so long winded, but
there
are many variables involved. If I could get it working on my XP-P
notebook, I
could finally turn off the server and rest easy knowing I won't be up the
proverbial creek.

Thanks for reading all this and any help,
Dobermann



.

Relevant Pages

  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: Side by Side upgrade to CM2007
    ... As with any upgrade it is best to perform the upgrade within a lab thereby allow you to work through all the issues before you upgrade production. ... Created new Windows 2008 server, installed another instance of SQL on new ... > locally install SQL for SMS/CM ...
    (microsoft.public.sms.setup)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
Loading