Forgot to mention....

I am running SQL 7 sp3 on win2k advanced server sp4

I have a similar problem as I changed the pw for the user running the sqlagent service (our network admin left the organization so we had to change the...

check out MS knowledge base article #303411..

Check out MS KB article 311231. FAQ's on SQL Mail config.

No, I haven't. Will try this next.

Thanks Chris!

Hi Lee,

Here is a vb script that I got from this site to verify your version of mdac. I have used it often and it works great! Just paste...

Build 8.0.534 would be SP2.

SP3 readme doc states Analysis Services SP3 or SP3a would be build number 8.0.760.

MS Knowledge Base article #322353 will help you.

Per MS "Features by Edition" white paper - Enterprise Edition has the following additional features over Std. Edition.

Advanced Analysis Features for OLAP

Comprhensive Analysis Services

Distributed Partitioned Views

High availability

Indexed Views

VI SAN

Web...

Thanks. Now, how do I get from Standard to Enterprise edition? Will the enterprise edition install just give me the missing functionality?

Thanks Brian!

No, I have no trace or audit of login attempts.