Re: Version of SQL Ce
From: Jennyfer J Barco (pdwhitt_at_nospam.wdsinc.com)
Date: 09/09/04
- Next message: Jennyfer J Barco: "RDA Pull authentication failed error"
- Previous message: pat: "Re: Replication problems"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Version of SQL Ce"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 11:38:44 -0400
I solved the problem. I had to bring off all the databases before updating
the service pack. When I got to run the service pack correctly I was able to
install the file sqlce20sql2ksp3a.exe. One thing for people who does this:
copy always this file and run it from a directory you have never runned any
other installer, it's the only way to work otherwise it will confuse the
installation. I had this problem and it fixed instaling from a new
directory.
Thanks
"Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote in
message news:OHEUL4clEHA.3520@tk2msftngp13.phx.gbl...
> I don't know why you are getting the error when running the SP3A upgrade.
> However, I would try rebooting your machine and then trying the SQL Server
> CE server side setup again.
>
> If that doesn't solve the problem, then something must have happened in
the
> SP3A upgrade that I am unfamiliar with. The only suggestion that I can
> offer on that is to take that error message and post on the SQL Server
> newsgroup, specificaly targetting the merge replication section as that
> seems to be where the upgrade failed.
>
> Sorry that the upgrade did not function properly. I will also ping some
> people to see if they know about the error that you are getting on the
SP3A
> upgrade.
>
> "Jennyfer J Barco" <pdwhitt@nospam.wdsinc.com> wrote in message
> news:edtbq$QlEHA.3496@TK2MSFTNGP12.phx.gbl...
> > Thanks so much. I was in a big mistake. I'm running the service pack 3a
> > that you referred and I get this error almost at the end "Error running
> > script: sp_vupgrade_replication (1)". After this I try to install the
SQL
> > Server CE the server options and when I run the file
sqlce20sql2ksp3a.exe
> > it
> > says that it's not the correct file version. Does this happen because of
> > the
> > error instaling the service pack? How can I solve this?
> >
> > After the error I mentioned when I select @@version says:
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> > Windows
> > NT 5.0 (Build 2195: Service Pack 4)
> >
> >
> > Thanks so much
> > Jennyfer
> >
> > "Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote
in
> > message news:uY5TPpPlEHA.3816@TK2MSFTNGP14.phx.gbl...
> >> You have service pack 4 for Windows 2000, not for SQL Server 2000.
There
> > is
> >> no service pack for SQL Server 2000 out at this time. Service Pack 3
is
> > the
> >> latest release for SQL Server 2000. Below you will see the SELECT
> > @@VERSION
> >> from my machine, which is XP with SP2. The part that you need to look
at
> > is
> >> the build number right after SQL Server.
> >>
> >> "Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05
> >> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> > Windows
> >> NT 5.1 (Build 2600: Service Pack 2) "
> >>
> >> You can download SP3 of SQL Server 2000 from here
> >> http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> >>
> >>
> >> "Jennyfer J Barco" <pdwhitt@nospam.wdsinc.com> wrote in message
> >> news:Ongs0kPlEHA.2764@TK2MSFTNGP11.phx.gbl...
> >> > when I execute select @@version I get this:
> >> >
> >> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000
> >> > 00:57:48
> >> > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
> >> > Windows
> >> > NT 5.0 (Build 2195: Service Pack 4)
> >> >
> >> > "Jennyfer J Barco" <pdwhitt@nospam.wdsinc.com> wrote in message
> >> > news:e4q5hSPlEHA.1376@TK2MSFTNGP12.phx.gbl...
> >> >> Hello
> >> >> I have SQL Server 2000, Service Pack 4. Where can I load the drive
for
> >> >> SQL
> >> >> Server 2000 Windows® CE Edition. I can only install the development
> > tool
> >> > but
> >> >> not the Server tool. I try with sqlce20sql2ksp3a.exe but it's not
the
> >> >> correct file.
> >> >>
> >> >> Thanks for your help
> >> >>
> >> >> Jennyfer
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>
- Next message: Jennyfer J Barco: "RDA Pull authentication failed error"
- Previous message: pat: "Re: Replication problems"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Version of SQL Ce"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
