need help while installing SQL Server on .net 2003.

Well, we can all learn, so please don't apologise for
posting something.

Since you are copying the msde folder, does this mean that
you are
installing msde rather than SQL Server?  According to:

http://www.teratrax.com/articles/msde_vs_sql_server.html
 

these are the limitations of msde (which may or may not be
important to
the OP):

MSDE Database Limitations

<quote>
MSDE is intended for single user or small workgroup
environments. The
following are some of the MSDE limitations in comparison
with SQL
Server:

    * No Enterprise Manager
    * No Query Analyzer
    * No Index Tuning Wizard
    * Only 2GB RAM
    * Only 2GB database size limit
    * Only 2 CPUs
    * Only five concurrent batch workloads or 25 concurrent
connections
for websites
    * No Database Server Failover Support
    * No Full-text search
    * No SQL Server Profiler
    * No Import and Export Wizards
    * No OLAP
    * No English Query
    * No SQL Books Online
    * No Full or Bulk-Logged recovery model support (only
simple)

(This list covers most of the MSDE limitations. There may be
a few
omitted.)
</quote>

I also learn from that site that the "DE" in
"MSDE" stands for "Desktop
Engine" and not "Developer Edition" as I
had thought.


Peter

-----Original Message-----
From: CSDevelopersgooglegroups.com
[mailto:CSDevelopersgooglegroups.com] On Behalf Of Mohit
Bhardwaj
Sent: 21 July 2006 12:30
To: C# Developers
Subject: Re: need help while installing SQL Server on .net
2003.


Hello to all above,

I hate to say but all of you are wrong. You see a Sql Server
Architecture is comnposed of two things
1) Sql Server 2000 software
2) Sql Server 2000 Desktop Engine.

To Install the sql server 2000 do these things:

1) Insert the CD. Let it be autorun.
2) Click on "SQL Server 2000 components"
3) Click on "Install Database Server"
4) A warning will come which is listed in the first topic
above. CLick
OK.
5) Go through the iinstallation process.
6) After Installation. In your CD search for folder
"msde". Although
you will find it on the front window, like
"E:\msde", where E:\ is the
CD Rom.
7) Copy this msde folder on your harddisk, Open it. Look for
Setup.ini.
It is the configuration file. Open it with notepad.
8) Add this line at the end."SECURITYMODE=SQL" 
without quotes. If this
line is already their then do not modify this file.
9) save the file.
10) run setup from this folder. Restart your system. SQL
Server
Installed and working. Try to again install MDAC components
from VS
2003 update CD or dvd. Not necessary but useful.


Thanks.


Regards.
Mohit





--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "C# Developers" group.
To post to this group, send email to CSDevelopersgooglegroups.com
To unsubscribe from this group, send email to
CSDevelopers-unsubscribegooglegroups.com
For more options, visit this group at http://gr
oups.google.com/group/CSDevelopers
-~----------~----~----~----~------~----~------~--~---