Can I install SQL Server on Windows 98?

By Bill Graziano on 29 July 2000 | 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.

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

Checkmark for guaranteed SR = WR (12h)

How to connect to git in SQL Server 2016/2017 without using any third party tool (12h)

Sql restart (17h)

Excel column wise data save in rows (1d)

Date timzone conversion (2d)

Object cannot be cast from DBNULL to other types coming randomly in SSIS Package-Migrated from VS 2008 to 2015,SQL 2008R2 to SQL2016 on 1st run only (2d)

Error in sp procedure- Msg 50000, Level 16, State 1, Procedure spCheckDBInfo, Line 193 [Batch Start Line 0 (2d)

Two records into a single record? (2d)

- Advertisement -