Jump to content
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically. 



Sign in to follow this  
moonshadow88

help about SQL-Server 2000 VERY URGENT!

Recommended Posts

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

MooNShadoW

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×