need help while installing SQL Server on .net 2003.

Visual Basic .NET » Database Programming

need help while installing SQL Server on .net 2003. -- sandeepahuja --

Hi every one i installed .net2003 successfully(on my system..WINDOWS XP)..after that while going for installation for sql server2000
(database for ADO.net)..i recieved a meesage like:

"Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system.Only client components will be available for intallation."

i know that installing further in that manner will useless for me..
can any one suggest me how to overcome this problem..
thanks in advance

-- BradleyPeter --

I don't wan to encourage cross-posting, but here's what I said in a reply to the CSDevelopers forum:

Yet another way MS tries to take you for all you've got. This is something about MS that really annoys me. You can't install their server products on any of their operating systems except for the ones annointed by them as "server" operating systems.

Unless someone knows a workaround, of course.

So, and assuming I'm correct, you have the following options

- Install a "server" OS (e.g. Windows 2003 Server (if you are rich enough)

- Install MSDE, the "Developer Edition" of SQL Server. Of course you only get a command line interface to it, but you can define it as a server in VSS which gives you some GUI access, though not anything like the stuff you get with the real SQL Server + client tools.

- Install MySQL, MySQL Administrator, MySQL Query Browser and MySQL Workbench, along with connetor/.net (all from

http://dev.mysql.com/downloads

). Once you've installed all those,
you'll probably want to add the MySql assemblies to your Visual Studio Toolbox, if you're using Visual Studio. From then on you can connect to MySQL in exactly the same way as you connect to SQL Server, except that you use the MySql assemblies in place of the SQL Server assemblies -
e.g. use MySqlConnection instead of SqlConnection. Easy, and completely free of charge, unless you want to pay for support.

I know the choice I'd make.

HTH

Peter

-- ank --

it would install on Windows XP Professional or Windows 2000 Server OS

-- BradleyPeter --

Here's what I quoted on CSDevelopers (this x-posting is getting to be a nuisance):

Microsoft themselves say:

http://www.microsoft.com/sql/prodinfo/previousversions/system-requiremen

ts.mspx

<quote>
SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:
* Windows Server 2003 R2
* Windows Server 2003, Standard Edition1
* Windows Server 2003, Enterprise Edition2
* Windows Server 2003, Datacenter Edition3
* Windows(r) 2000 Server
* Windows 2000 Advanced Server
* Windows 2000 Datacenter Server

SQL Server 2000 Evaluation Edition and Developer Edition and Workgroup Edition can run on the following operating systems:
* Operating systems listed above for Enterprise and Standard Editions
* Windows XP Professional
* Windows XP Home Edition
* Windows 2000 Professional
* SQL Server 2000 Personal Edition4 and SQL Server 2000 Desktop Engine
(MSDE) can run on the following operating systems:
* Operating systems listed above for Enterprise, Standard, Evaluation,
and Developer Editions
* Windows Server 2003, Web Edition5 (MSDE only)
* Windows 98
* Windows Millennium Edition (Windows Me) </quote>

So I guess that should just about round this discussion off - and I hope that the OP has the required answer.
Peter

-----Original Message-----
From: DotNetDevelopment

Re: need help while installing SQL Server on .net 2003.
it would install on Windows XP Professional or Windows 2000 Server OS

-- Cerebrus --

;-)

Good one, Peter. No argument, just hard cold fact. I'm learning from you, by observation... :-)

-- SumitSengupta --

As far as I know, you need XP Professional edition to install the enterprise edition of SQL Server.
It doesn't work if you have got the Home edition.

cheers,
On 7/20/06, sandeep ahuja <ahuja.bangalore> wrote:

Hi every one
i installed .net2003 successfully(on my system..WINDOWS XP)..after
that while going for installation for sql server2000
(database for ADO.net)..i recieved a meesage like:

"Microsoft SQL Server 2000 Enterprise Edition server component
is not supported on this operating system.Only client components
will be available for intallation."

i know that installing further in that manner will useless for me..
can any one suggest me how to overcome this problem..
thanks in advance
>

-- Cerebrus --

Peter is basically correct that SQL Server 2000 Enterprise or Standard will only install on a Server OS.

But I have heard mention of certain workarounds that I have not had the opportunity to try. Maybe you can try them and let me know if they work
:

1. There is a "setup.ins" file in the setup directory of the installation CD. This file needs to be replaced by the "setup.ins" file present in the Developer edition or Evaluation version of SQL Server 2000. Once replaced, try installing it and it should proceed as normal.

2. Install SQL Server 7.0 on Windows XP first. After this, install SQL Server 2000. It should proceed.

Note that the viability of these "tricks" is unconfirmed.

One note however... If you installing SQL Server for a production environment, it would be much more advisable to use a Server OS, as expected by SQL Server, instead of using XP.

-- amit007 --

Hi
You can easyly install SQL server 2005 Express Edition on your system.I have done it .I use it without any problem. So, try it .

-- Blueboy --

Hi

You cannot install Microsoft SQL Server 2000 Enterprise Edition on Windows XP Pro. Get the Developer Version of the MS SQL Server 2000. It run's like a road runner!!!!

-- sandeepahuja --

thanks to all guys it workes!!
its great to recieve so many suggestions and solutions..
finally i got able to install SQL SERVER 2000 on my pc..
AGAIN "THANKS TO ALL OF YOU"
regards sandeep

On 7/20/06, sandeep ahuja <ahuja.bangalore> wrote:

Home