Hi,
Can MSDE SP3a be installed on top of SP2 without first uninstalling the
latter?
Cheers,
Adrian
hi Adrian,
Adrian wrote:
> Hi,
> Can MSDE SP3a be installed on top of SP2 without first uninstalling
> the latter?
> Cheers,
> Adrian
MSDE Rel A, updated at sp3a level, from the
http://www.microsoft.com/sql/msde/do...s/download.asp package, can not
upgrad existing instances at this service pack level, but only install new
instances..
but you can use the package from
http://www.microsoft.com/sql/downloads/2000/sp3.mspx , or better
http://www.microsoft.com/sql/downloads/2000/sp4.mspx for service pack 4, to
upgrade existing instances to the current/desired sp level without removing
them...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks!
Adrian
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3j25l7Fnt9l6U1@.individual.net...
> hi Adrian,
> Adrian wrote:
> MSDE Rel A, updated at sp3a level, from the
> http://www.microsoft.com/sql/msde/do...s/download.asp package, can not
> upgrad existing instances at this service pack level, but only install new
> instances..
> but you can use the package from
> http://www.microsoft.com/sql/downloads/2000/sp3.mspx , or better
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx for service pack 4,
> to upgrade existing instances to the current/desired sp level without
> removing them...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Showing posts with label directly. Show all posts
Showing posts with label directly. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
MSDE running from a CD!
I think I am trying to do the impossible.
We have a customer who would like to run an application and the MSDE
directly from a CD. Does anyone know how to get the tempdb to work as CD's
are read only?
Any advice would be appreciated."John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> I think I am trying to do the impossible.
> We have a customer who would like to run an application and the MSDE
> directly from a CD. Does anyone know how to get the tempdb to work as CD's
> are read only?
Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
physical drive or worse a RAM drive.
I can pretty much guarantee MS won't support this though if you call in with
problems.
What's their real goal?
> Any advice would be appreciated.|||The aim is to be able to inset a CD into a machine and run an application
accessing data in the database. They do not want to have any installation
done. The data is read only but can be cut and diced in many ways and there
is a large quantity of it.
We are trying to see if they will let us run an install. The problem is not
all machines allow access to the C drive for writing with normal user
permissions and not all machines have a D drive. It all depends on how people
inmplement XP and user profiles.
Some machines will be still running older operating systems as old as
Windows 95.
Trying to make this universal is a bit of a headache.
In the past where I have known the target coinfiguration the install writes
the tempdb to to a known location on the hard drive configured into the
database.
This worked because we had control of the image ont the target machines.
"Greg D. Moore (Strider)" wrote:
> "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > I think I am trying to do the impossible.
> > We have a customer who would like to run an application and the MSDE
> > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > are read only?
> Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> physical drive or worse a RAM drive.
> I can pretty much guarantee MS won't support this though if you call in with
> problems.
> What's their real goal?
>
> >
> > Any advice would be appreciated.
>
>|||SQL Server cannot just be "executed", you need to install, get registry keys, errorlog files, tempdb
files and all that jazz. You might want to look at some other storage and retrieval product for
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Kaye" <helpneeded@.mailinator.com> wrote in message
news:510D5C9C-187E-4E9B-A28F-094FD5AC14AD@.microsoft.com...
> The aim is to be able to inset a CD into a machine and run an application
> accessing data in the database. They do not want to have any installation
> done. The data is read only but can be cut and diced in many ways and there
> is a large quantity of it.
> We are trying to see if they will let us run an install. The problem is not
> all machines allow access to the C drive for writing with normal user
> permissions and not all machines have a D drive. It all depends on how people
> inmplement XP and user profiles.
> Some machines will be still running older operating systems as old as
> Windows 95.
> Trying to make this universal is a bit of a headache.
> In the past where I have known the target coinfiguration the install writes
> the tempdb to to a known location on the hard drive configured into the
> database.
> This worked because we had control of the image ont the target machines.
>
>
> "Greg D. Moore (Strider)" wrote:
> >
> > "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> > news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > > I think I am trying to do the impossible.
> > > We have a customer who would like to run an application and the MSDE
> > > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > > are read only?
> >
> > Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> > physical drive or worse a RAM drive.
> >
> > I can pretty much guarantee MS won't support this though if you call in with
> > problems.
> >
> > What's their real goal?
> >
> >
> > >
> > > Any advice would be appreciated.
> >
> >
> >
We have a customer who would like to run an application and the MSDE
directly from a CD. Does anyone know how to get the tempdb to work as CD's
are read only?
Any advice would be appreciated."John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> I think I am trying to do the impossible.
> We have a customer who would like to run an application and the MSDE
> directly from a CD. Does anyone know how to get the tempdb to work as CD's
> are read only?
Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
physical drive or worse a RAM drive.
I can pretty much guarantee MS won't support this though if you call in with
problems.
What's their real goal?
> Any advice would be appreciated.|||The aim is to be able to inset a CD into a machine and run an application
accessing data in the database. They do not want to have any installation
done. The data is read only but can be cut and diced in many ways and there
is a large quantity of it.
We are trying to see if they will let us run an install. The problem is not
all machines allow access to the C drive for writing with normal user
permissions and not all machines have a D drive. It all depends on how people
inmplement XP and user profiles.
Some machines will be still running older operating systems as old as
Windows 95.
Trying to make this universal is a bit of a headache.
In the past where I have known the target coinfiguration the install writes
the tempdb to to a known location on the hard drive configured into the
database.
This worked because we had control of the image ont the target machines.
"Greg D. Moore (Strider)" wrote:
> "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > I think I am trying to do the impossible.
> > We have a customer who would like to run an application and the MSDE
> > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > are read only?
> Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> physical drive or worse a RAM drive.
> I can pretty much guarantee MS won't support this though if you call in with
> problems.
> What's their real goal?
>
> >
> > Any advice would be appreciated.
>
>|||SQL Server cannot just be "executed", you need to install, get registry keys, errorlog files, tempdb
files and all that jazz. You might want to look at some other storage and retrieval product for
this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Kaye" <helpneeded@.mailinator.com> wrote in message
news:510D5C9C-187E-4E9B-A28F-094FD5AC14AD@.microsoft.com...
> The aim is to be able to inset a CD into a machine and run an application
> accessing data in the database. They do not want to have any installation
> done. The data is read only but can be cut and diced in many ways and there
> is a large quantity of it.
> We are trying to see if they will let us run an install. The problem is not
> all machines allow access to the C drive for writing with normal user
> permissions and not all machines have a D drive. It all depends on how people
> inmplement XP and user profiles.
> Some machines will be still running older operating systems as old as
> Windows 95.
> Trying to make this universal is a bit of a headache.
> In the past where I have known the target coinfiguration the install writes
> the tempdb to to a known location on the hard drive configured into the
> database.
> This worked because we had control of the image ont the target machines.
>
>
> "Greg D. Moore (Strider)" wrote:
> >
> > "John Kaye" <John Kaye@.discussions.microsoft.com> wrote in message
> > news:A5B872EF-B2E1-4C29-9016-5B952E3990F3@.microsoft.com...
> > > I think I am trying to do the impossible.
> > > We have a customer who would like to run an application and the MSDE
> > > directly from a CD. Does anyone know how to get the tempdb to work as CD's
> > > are read only?
> >
> > Really not sure HOW or WHY yuo'd do this.. but hack it so the tempdb is on a
> > physical drive or worse a RAM drive.
> >
> > I can pretty much guarantee MS won't support this though if you call in with
> > problems.
> >
> > What's their real goal?
> >
> >
> > >
> > > Any advice would be appreciated.
> >
> >
> >
Subscribe to:
Posts (Atom)