This particular server is SQL 2000 and we have Reports on the secondary database, but the end-users do not want reports.  These users are analysts and a couple of them want...

You may also need to check with the vendor to see if the 'sa' login & password are held in a table, .ini file, configuration file, etc.  If it is hard-coded and...

Thanks.  I'll keep it nearby.

Sorry, I wasn't very clear--I was getting just a bit frustrated.  The application uses SQL Server 2000, but there is an Access front-end that users can download to "administer" certain functions. ...

Thanks, but that's my problem.  I wouldn't be building the data warehouse becuase I don't have the time (being the only DBA), and the 'developers' are not familiar with DTS...

We haven't decided on the type of datawarehouse yet because we also need data from Oracle and AS/400 and the developers from those systems are unfamiliar with SQL Server Analysis...

We are also looking at different products but before building a data warehouse (which, for us, would take a long time) we are considering using Crystal Business Intelligence which is similar...

It seems to me that log shipping got out of synch once and the user account didn't work on the secondary because the password hadn't been changed back.  Can't recall the exact...

We're doing the same thing, but I'm restoring logs only once a day.  I created a job on the primary server to change the password of the report username to an...

Few more questions.  Have permissions changed anywhere (in SQL Server or on the servers themselves)?  When you go into the Monitor do you get any errors when you click "view...

How often does Log Shipping run?  Out-of-synch alerts can be a sign that it's just behind somewhere.  Can you manually run the Log backup job, the copy job, and the restore...

Did you check the log shipping jobs on the primary and secondary servers?  Are any of them failing?  (Transaction log backups, file copies, restores, or alert jobs.)  The job histories...

Are you installing from a 2-CD set?  If so, the client application is on the second CD.  When I tried installing "everything" using the first CD I got an error...

The copying of files is done by a scheduled job on the secondary server.  What is the error there?  (Either in the NT log or job history)  Does the secondary server...

I revoked Create Database permission to the SharePoint account because databases were popping up unexpectedly and not being backed up.  Removing the permission doesn't hurt a thing.  Whenever they really...