Registring Local SQL server (SQL 2000)

  • Hi

    I'm having  problems creating  a simple Local Sql server on my machine (.

    I got this message

    " local - SQL Server does not exist or access denied [ConnectionOpen  Connect][] "

    When I installed  SQL 2000 at the second window I got this message " Microsoft SQL Server 2000 Standard Edition server component is not supported on tis operating system. Only client component will be available for installation"

    I have a DS(distributed System) of Windows 2000 and Windows XP - it is provided by the company I work for

    Thanks for your help

     

  • I think the installation message regarding your OS is telling you all you need to know.  SQL Server will not install on your OS.  It appears that the OS version that your company has provided has been stripped down (probably to meet some security standard for your company) to the point to where SQL Server is recognizing that certain dependencies are missing. 

    Put your installation CD back in, select SQL Server 2000 Components, SQL Server 2000 Prerequisites, and then try to install the Common Controls Library Update. 

    Then try the installation again.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Thanks John for you answer. I tried it but it did not work. I know that our OS version has benn stripped down I thought I can find some patchs or fixes  to overcome this problem.

    Thanks

  • Standard Edition is only supported on SERVER platforms Windows XP is a DESKTOP platform. If you want to install SQL Server locally on Windows XP use the DEVELOPER EDITION .

    Cheers,

     

     


    * Noel

  • As noeld said... or you might have a PERSONAL EDITION disk with your Standard version. Our CD set has 2 disks -- standard and Personal. Use Personal on your non-servers.

  • Thanks Milzs. I use SQL 2000 Personal edition and it worked

    Thanks again

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply