Very much so, especially since the DSN works and installing a relatively new version of MDAC does not. This one of those weird sorts of cases where you may want...

Is the MSDE using the TCP/IP net-lib? It should be, but check to see if it's listening on port 1433 on the PC running MSDE.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

What errors does it usually generate?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

So you aren't seeing Performance objects for MSSQL$<Instance Name>? Typically they should be there, though Books Online I think misnames the objects.

If they aren't there, take a look at the...

Have you tried just installing MDAC 2.5 or higher on these Windows 98 clients? You can grab MDAC at http://www.microsoft.com/data/

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

There is not an interface to administer MDAC. MDAC is a collection of components which are packaged together.

The SQL Network Client Utility is used to set the precedence of Network...

If you don't have the ability to bring up the User Manager for Domains (NT 4.0) or Computer Management (Win2K) for that server, run the following command from a command...

MDAC 2.5, the version which ships with Windows 2000, has the OLEDB connection libraries. So a client running Windows 2000 can connect to a SQL Server without any additional software...

The Server versions of the Windows OSes give you the ability to install Microsoft's Network Monitor. If you are using Windows 2000:

Start | Settings | Control Panel | Add/Remove Windows...

Go with single triggers. When I was testing for an article I wrote, it showed that Microsoft's words of "you can't depend on order except first and last" are 100%...

Good catch. Teach me to try and copy and paste without first checking while doing something else.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Who owns the jobs? sa or another user? If another user, does that user have sysadmin rights?

What context is the SQL Server Agent service running under? localsystem, a local...

Try downloading and installing MDAC before the SQL Server install. This has been known to resolve some of the install issues. MDAC site:

http://www.microsoft.com/data/

For whatever reason, MDAC seems the most flaky...

It looks like Microsoft's support site are having some problems, but here are the relevant Q articles, titles, and links.

PRB: SQL Server 2000 Cluster May Not Bind to Port If...

It depends. A Common case for only one permissions table is where you might have a table for employee (contains the employee login id and the division the employee belongs...