Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


help about SQL-Server 2000 VERY URGENT!

- - - - -

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic


  • Member
  • 1 posts
  • Joined 14-October 04
I have to install a SQL-Server 2000 Enterprise instance on a windows 2000 workstation sp4. When i put the cd, install wizard starts but it says that i can't install a server instance on a workstation, it must be installed on a server.
Is there any solution¿?

In addition of this, IIS of windows 2000 workstation only lets me to configure 1 virtual site. There is any way of disable that restriction?

Thanks for advance


How to remove advertisement from MSFN




  • Member
  • 49 posts
  • Joined 23-April 03
the only version of sql 2000 that can be installed on a windows 2000 pro machine is sql 2000 personal edition. IIS in windows 2000 pro is limited to 1 site and 5 concurrent connections, there is no way round this other than installing server unfortunatly



    Coffee Aficionado

  • Patrons
  • 4,973 posts
  • Joined 14-July 04
That isn't true. There ARE solutions other than moving to server directly - although server ed is a better option in many cases.

You can also install the developper edition (works on xp pro too). If that's not an option for you, then there's always sql expres/msde, mysql and such...

About the limitations of IIS on 2k pro (same as XP Pro / IIS 5.1), you can edit your metabase (with metaedit 2.2, free from microsoft) to a number less than 40 and it'll work. There is also a utility (vbscript) to do it. (the thing is, most web browsers will open more than one socket... so it's still not quite 29 users, more like 10-20 simultaneously - enough for low traffic or a testing server)

As for the virtual sites, some (free) 3rd party control panels/utilities will let you add more.
Coffee: \ˈkȯ-fē, ˈkä-\. noun. Heaven in a cup. Life's only treasure. The meaning of life. Kaffee ist wunderbar. C8H10N4O2 FTW.