Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,
Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:

>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installting SQL Server 2k5

I have SQL Server 2000 on Windows XP professional OS.
I want to install SQLServer 2K5?
Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
What steps should be taken before and after SQL Server 2K5 installation?
Thanks,Hi,
You should be able to install SQL Server 2005 and SQL Server 2000 side
by side.
I think you may need SP2 of XP Pro.
One important thing to watch out for is any old components left behind
by past builds of SQL Server 2005 or Visual Studio 2005. If they are
present you need to uninstall CAREFULLY and in the right order or you
can expect to hit problems.
Andrew Watt
MVP - InfoPath
On Wed, 12 Oct 2005 12:01:02 -0700, "UA" <usha.anumolu@.eds.com> wrote:
>I have SQL Server 2000 on Windows XP professional OS.
>I want to install SQLServer 2K5?
>Do I need to to uninstall SQLServer2K before installing SQLServer 2k5 ?
>What steps should be taken before and after SQL Server 2K5 installation?
>
>Thanks,

Installing with MSDE on XP

I would like to install MSDE in Windows XP Professional. When I tried
to install it gave me an error A strong SA password is required for
security reasons. Please use SAPWD switch
I do not know how it handle this error if you can please let me how to
install in XP.
Step by Step process.
Thanking You
Your's Truly
Raj
hi Raj,
Raj wrote:
> I would like to install MSDE in Windows XP Professional. When I tried
> to install it gave me an error A strong SA password is required for
> security reasons. Please use SAPWD switch
> I do not know how it handle this error if you can please let me how to
> install in XP.
> Step by Step process.
Setup.exe is a boostrap intaller for MSDE and accepts parameters you can
provide at the command line as long as in a companion .Ini file..
at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
you can find the list of all supported parameters...
please open a DOS command window and navigate to the folder hosting the
setup.exe file...
there you can run setup.exe with all the parameters of your choice..
- usually you have to provide the SAPWD parameter to specify a strong
password for the "sa" builtin login in order to protect it from both
internal and external attacks..
specify then
SAPWD=your_strong_password
- additional parameters let you specify if you want a named instance or a
default instance... specify
INSTANCENAME=your_instance_name
if you want a named instance...
- another parameter let you specify if you want to allow remote connections
from other PCs in your lan to your MSDE instance.. specify
DISABLENETWORKPROTOCOLS=0
if you need this feature...
- by default, MSDE is installed allowing only WindowsNT authenticated
connections and preventing standard SQL Server authenticated ones.. more on
this at http://support.microsoft.com/default...b;en-us;325022
you can specify
SECURITYMODE=SQL
to allow mixed mode security, thus allowing both WInNT integrated security
and standard SQL Server authenticated connections..
- the final important parameter is
/L*v "c:\msdelog.txt"
where you will allow verbose logging of the installation process, resulting
in a text file of about 2mb for a successfull installation you can inspect,
in case of problems, for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problwm will be reported..
so, if you like to install a "named instace" named "Raj" with mixed security
and enabled network protocols for remote connections you can run setup.exe
boostrap installer providing all parameters as
c:\..\>setup.exe /qb INSTANCENAME=Raj SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 SAPWD=your_strong_password /L*v "c:\msdelog.txt"
you can later manage your installed instance via the native character tool
oSql.exe as described at
http://support.microsoft.com/default...;EN-US;q325003 or use a
third party tool, both commercial or free, like the ones listed at
http://www.microsoft.com/sql/msde/partners/ or
http://www.aspfaq.com/show.asp?id=2442... google for further..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing SQL server 2000 on xp machine

Is it possible to install sql server enterprise edition on an xp machine (home or professional)? I tried both (w/sp2) and it said it can only be run as a client.You can install Personal, Developer, and MSDE only.|||You can install Personal, Developer, and MSDE only.
You can install ent on a client but you wont get the rdbms only the tools.
this is so you wont have to buy another copy of the media to administer your sql servers.
you will install the client process on your xp pc and then register your production servers with your client tools.

as rdjabarov said so cryptically. you can however if you want to practice with a rdbms locally, you can load the professional edition or the developer edition. and sql cute (MSDE)
i preferr the dev. edition because it is much cheaper.

I prefer the developer edition because it's cheaper (http://www.microsoft.com/sql/howtobuy/development.asp)

Installing SQL reporting service with sql 2000 server professional

Installing SQL reporting service with sql 2000 server professional edition. Is there any patch.. When I install I am getting the error " this edition of the report server database is not supported on the edition of sql server 2000 you have choosen. Please
choose another SQL server that matches the requirements."
Hi,
Report Server is not support on the personal edition of SQL server. You can
use the Enterprise, Standard or Developer edition.
Please look
http://www.microsoft.com/sql/reporti...fo/sysreqs.asp
Thanks
Hari
MCDBA
"Murugha Charan" <MurughaCharan@.discussions.microsoft.com> wrote in message
news:FFFEEF0D-5C3A-47CF-AFD4-E2D976DD5023@.microsoft.com...
> Installing SQL reporting service with sql 2000 server professional
edition. Is there any patch.. When I install I am getting the error " this
edition of the report server database is not supported on the edition of sql
server 2000 you have choosen. Please choose another SQL server that matches
the requirements."
>

Installing SQL reporting service with sql 2000 server professional

Installing SQL reporting service with sql 2000 server professional edition. Is there any patch.. When I install I am getting the error " this edition of the report server database is not supported on the edition of sql server 2000 you have choosen. Please choose another SQL server that matches the requirements."Hi,
Report Server is not support on the personal edition of SQL server. You can
use the Enterprise, Standard or Developer edition.
Please look
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
--
Thanks
Hari
MCDBA
"Murugha Charan" <MurughaCharan@.discussions.microsoft.com> wrote in message
news:FFFEEF0D-5C3A-47CF-AFD4-E2D976DD5023@.microsoft.com...
> Installing SQL reporting service with sql 2000 server professional
edition. Is there any patch.. When I install I am getting the error " this
edition of the report server database is not supported on the edition of sql
server 2000 you have choosen. Please choose another SQL server that matches
the requirements."
>

Installing SQL reporting service with sql 2000 server professional

Installing SQL reporting service with sql 2000 server professional edition.
Is there any patch.. When I install I am getting the error " this edition of
the report server database is not supported on the edition of sql server 20
00 you have choosen. Please
choose another SQL server that matches the requirements."Hi,
Report Server is not support on the personal edition of SQL server. You can
use the Enterprise, Standard or Developer edition.
Please look
http://www.microsoft.com/sql/report...nfo/sysreqs.asp
Thanks
Hari
MCDBA
"Murugha Charan" <MurughaCharan@.discussions.microsoft.com> wrote in message
news:FFFEEF0D-5C3A-47CF-AFD4-E2D976DD5023@.microsoft.com...
> Installing SQL reporting service with sql 2000 server professional
edition. Is there any patch.. When I install I am getting the error " this
edition of the report server database is not supported on the edition of sql
server 2000 you have choosen. Please choose another SQL server that matches
the requirements."
>

Installing SQL 2000 Client Tools

Hi,

I'm attempting to install SQL 2000 Client Tools on my Win2k Professional workstation. However, it will not install because it claims that there is not enough disc space. The amount of space which it detects is the measly 60Mb left on my 2Gb C: drive, and apparently does not see the rather more capacious, and more than adequate 2.6Gb left of my 3.5Gb D: drive. I see no option during the install for changing this.

Any tips? Thanks in advance...Andrew.This is by design. Client tool is hardcoded to installed to the program files directory. You could overcome this by one of these two methods:
1. modify registry key - HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Curr entVersion\ProgramFilesDir

2. use SetPF program by Gert - http://www.sqldev.net/misc/setpf.htm|||Thanks OJ,
This has partially worked as now the install sees my spacious D: drive as the Program Files drive. However, SQL Client Tools is looking to my 'System Drive' for its space, which it sees as my C: drive. Is there another Key I can change?
thanks, Andrew|||There are DLLs that must be installed to system folder. You might want to clear out tmp to ensure proper disk requirement. If your system drive is that low in space, you would have more than just installation problem, your OS+many other apps would require disk space for cache.