TechSpot

installing sql server 2000 standard edition in windows xp professional

By cmrhema
May 24, 2007
Topic Status:
Not open for further replies.
  1. Hello
    This is my first thread

    When i install sql server 2000 standard edition i have a message
    " Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation"

    Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist.

    What to do now?

    I found out that if one has sql server 2000 standard editon the prerequisties are
    Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server.


    I have windows xp professional version on which i am installing sql server.

    But i have seen many persons who have installed sql server standard edition in windows xp pro.
    They downloaded something(probably a service pack) and went into regedit


    Kindly let me know what do download and what to do after going inside regedit.

    Thanks
    cmrhema
  2. Nodsu

    Nodsu TS Rookie Posts: 9,431

    Do these "many persons" actually run the SQL Server engine on their computers or did they just install the client tools to be able to connect to another SQL Server machine?
  3. cmrhema

    cmrhema TS Rookie Topic Starter

    Yes with server
  4. Nodsu

    Nodsu TS Rookie Posts: 9,431

    And it was SQL Server 2000 Standard, and not something like SQL Server 2005 Express or SQL Server 2000 developer version?
  5. cmrhema

    cmrhema TS Rookie Topic Starter

    I got SQL Server 2000 Standard version installed

    I formatted my drive initially. Before doing so I copied my database file stud.mdf and its corresponding log file.
    Now I have installed sql server 2000. How do I copy these files back to enterprise manager.

    Thanks
  6. Nodsu

    Nodsu TS Rookie Posts: 9,431

    How did you get it installed? It would be very helpful if you told us how to do it..

    You use Attach Database to import mdf+ldf files.
  7. cmrhema

    cmrhema TS Rookie Topic Starter

  8. Nodsu

    Nodsu TS Rookie Posts: 9,431

    So, you actually didn't install SQL Server 2000, but MSDE..
  9. cmrhema

    cmrhema TS Rookie Topic Starter

    I should have replied this long ago.
    Yes I did install MSDE. Is there a vast difference between MSDE and SQL SERVER 2000?
    I am learning vb tutorials with backend as sql server 2000. All the commands and connections works well
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.