TechTutorials - Free Computer Tutorials  

Running SQL 7.0 on Windows 95/98 

Added: 05/20/2001, Hits: 2,830, Rating: 0, Comments: 0, Votes: 0
Add To Favorites | Comment on this article
By Brian Talbert

Suprisingly, the exam had a good bit of concentration on compatability details when running SQL 7.0 on Windows 95 or Windows 98. I would strongly recommend reading an article in Books Online titled "SQL Server 7.0 on Windows 95/98". It contains very good information on this topic. The following, however, is a brief summary.

If you purchase SQL Server 7.0 Standard Edition, and you opt for per seat licensing, you have the ability to install the Desktop edition of the product as well. The Desktop Edition has some limitations, regardless of if it is running on NT Server, or NT Workstation. However, some of the limitations are specific to when the product is running on Windows 95 or Windows 98.

Apple Talk, Named Pipes and Banyan Vines server Net-Libraries are not supported. Apple Talk is not supported as a client net-library either.

Windows NT Authentication. This may seem obvious but it is important to understand. While a Windows 95/98 client can connect to a SQL server running under NT Authentication mode, when Windows95/98 is the server it does not support this capability.

Encryption using the Multiprotocol net-library is not supported.

The database engine and the agent run as user applications since Windows 95/98 does not support the notion of services.

Alerts are supported, however, they don't integrate with the Event Viewer (since 95/98 doesn't have this). Instead a trace is done with the Profiler in order to detect alert situations.

Performance Monitor counters are not supported since 95/98 doesn't have this functionality.

There are a few other differences as well in the area of memory management and performance tuning. These bulleted items should be sufficient, but again, I recommend reading the section in Books Online for full details.

Comments (0)

Be the first to comment on this article

Related Items

7 Seconds Resources, Inc.

IT Showcase