• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
moonshadow88

help about SQL-Server 2000 VERY URGENT!

3 posts in this topic

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

0

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

0

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.

0

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  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.