Mr.Serge.M, i installed msde2000a successfully in my system by using dos promt , my OS is xp proffesional with service pack2,and i also have sp1,sp3a and sp4 for sql2000 are in my hand. after installing msde there is an sql server service manager is running in system and its icon is on the task bar Server name as PRAYATH-89DA82\LALS , Services given as sql server.Still there is a message that this OS does not spport sql server2000 and you can install accessory tools, whenever i try to install sql. i hered that installing sql server 2000 is possible in xp having sp2.
2007-02-23 19:36:01 · 5 answers · asked by sanusajan 1 in Computers & Internet ➔ Programming & Design
SQL Server 2000 comes in various editions. Some require a real server OS, the non-production editions should work just fine in XP.
http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx
2007-02-23 19:43:23 · answer #1 · answered by Raymond 3 · 0⤊ 0⤋
Yes installing MS Sql Server 2000 is possible under windows XP.
You might want to install the Personal Edition. The developer and enterprise editions are technically the same. However keep in mind the the Windows XP OS itself limits users to a number of connections (I believe its 10).
Hence the Personal Edition will end up to be equivalent to installing an enterprise edition on your win XP machine.
The installation procedure is very easy and self documenting. There is nothing special about installing this server on your XP. It's as easy as installing your favourite messenger. Just follow the wizard steps.
2007-02-24 03:20:14 · answer #2 · answered by Smutty 6 · 0⤊ 0⤋
If you see Service manager's icon in the task bar with green triangle, then all ok.
Try to connect to server. Type
isql
in the command prompt.
If you do not see green triangle, but the red one,
select in the service manager local server ("." - dot) and press start button.
2007-02-23 20:39:08 · answer #3 · answered by Serge M 6 · 0⤊ 0⤋
Perhaps you need to convert your harddrive that will have sql 2000 on in into NTFS file system
2007-02-23 19:41:10 · answer #4 · answered by Corvin 2 · 0⤊ 0⤋
See, you are able to deploy sq. on it, however the concern would be u cant instal server on it. you need to deploy laptop version for it. it is going to instal some dependcy record then you certainly would be waiting to instal it.
2016-10-16 09:16:37 · answer #5 · answered by ? 4 · 0⤊ 0⤋