Can I install SQL Server on Windows 98?

By Bill Graziano on 29 July 2000 | 5 Comments | Tags: Installation


Chris writes "Hi, Thank for this helpful site but I can't understand anything on here. This is not your crime :P Just I don't know anything else about SQL Server. How can I install SQL Server and Oracle on my machine? My machine (at home) 's operating system is Windows 98. Is this enough? More..I'm developing ASP pages. Has advantage for my ASP pages? Thank you."

Well Chris, I can certainly cover the SQL Server side of your question. As far as Oracle, I'm not going to be much help. Sorry :( Maybe one of our sharp-eyed readers can post a comment with a link to a good Oracle site.

SQL Server does run on Windows 98. In the installation program you can install the Desktop edition. It is almost identical of the Standard edition which is installed on servers. The desktop edition also includes special code to minimize the amount of memory it uses. It does not support OLAP Services or full text indexing. I also would not use SQL Server on Windows 98 for any type of high throughput database. It does work just fine as a development workstation though.

Concerning your second question, SQL Server can provide a number of advantages for ASP developers. Those advantages come with added complexity though. It is much easier to learn Access and deploy a solution using Access than with SQL Server. That is the main benefit of Access: ease of use. SQL Server gives you better scalability and reliability. While Access might support tens of users at a time, SQL Server is capable of supporting hundreds or thousands. It is also less likely to have data corruption errors. You can perform backups while the database is running with almost no loss in performance.

In most hosted environments, the SQL Server machine is separate from the web server. That means that database queries are passed to a separate computer that is only handling database queries and is optimized for them. This leaves your web server free to focus on web serving. I hope this helps.

Discuss this article: 5 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Notes from an Upgrade to SQL Server 2005 (26 February 2007)

Migrating from Oracle to SQL Server (29 September 2002)

Upgrading from SQL Server 7 to 2000 (Part 2) (29 May 2002)

Upgrading from SQL 7 to SQL 2000 (Part 1) (5 May 2002)

Service Pack 2 for SQL Server 7.0 (9 September 2000)

Other Recent Forum Posts

Help with small problem (2 Replies)

SQL query blocking (3 Replies)

Insert with Incremental Increase (9 Replies)

Overlapping Date Ranges - Remove dup Permutations (9 Replies)

Update Query Help (4 Replies)

Msg 4104 (56 Replies)

Finding last day date code (2 Replies)

creating log in page with session variable (0 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -