Core prerequisite Sql Server 2005

[NewsArchive]

Hi,
I´ve add a Sql Server core prerequisite to my project and I have some Qs.

The machine in which I´ve tried to install had Sql Server 2000 and Sql
Express 2005 installed.

When the installs begin it sais there are a Sql allready installed
I unnistalled Sql 2005, and it stills saying that!
I had to unistall the Sql 2000 server for the installations to begin.
When it finished...
Without any message it restart de computer.
When the computer restart I realized that the Sql server 2005 installed in a
folder named:
Microsoft Sql Server
This is the name with which Sql 2000 installs, may be this was the reason
why I had to unistalled Sql 2000
If you Intall SqlServer Express 2005 it installs in
Microsoft Sql Express 2005 dir

Is there any example of how to do an Sql Express installation, cretae a
database and restore a backup?
And if not...

1- How can I inform I will install Sql 2005 before it began?
2- Is there any way to install 2005 when Sql 2000 is installed?
3- How to inform the user I will restart de computer?
4- How to create a database and restore a backup? I think it is with
osql.exe but how to know the server name, etc to run the query?

Thanks a lot...

--


Saludos / Regards,
Alberto Michelis
www.armi.com.ar

[NewsArchive]

Is my post too obvious or too stupid or too large...

--

Saludos / Regards,

Alberto Michelis
ARMi software & technology solutions
www.armi.com.ar

[NewsArchive]

Actually, it's not a problem related to Clarion...

Yes, you can install SQL Server 2005 and SQL Server 2000 on the same
computer...
Install SQL 2000 ... the installation program will tell you if there is
anything missing from your computer. If so, go to the Microsoft web site and
download the missing components.

After SQL 2000 is installed properly, you can then install SQL 2005... again
the installer will tell you if you are missing any of the pre-requisites and
you can go to the MS web site and download them as well. and then do your
installation for SQL 2005.

One issue about running both 2000 and 2005 is you will have to use ports
other than the default settings if you are using TCP/IP protocols to talk to
the servers. Both default to port 1433 so you will have to choose new ports
for both of them (using port 1433 for either server leaves you a bit
vulnerable to worms and trojans, so change both servers to use different
port numbers). For example, use 1300 for SQL 2000 and 1500 for SQL 2005.

--

Ben E. Brady
Want MASSIVELY OUTRAGEOUS web disk space and bandwidth?
500 GB disk space and 5000 GB transfer per month,
http://www.servage.net/?coupon=CUST13495

www.clariondeveloper.com
www.singularvisionsoftware.com

The information contained in the message above, as expressed by the author,
is copyright 2008 by Ben E. Brady, All rights strictly reserved worldwide.
The information contained in the message above may not be posted on any
other information forum or web site without the express written permission
of the author. All opinions expressed in the message are those of the author
and are not necessarily shared by other members of the newsgroup and may or
may not be in agreement with SoftVelocity, the host of this newsgroup.