It's fixed. I had him go through his permissions on C: drive and compare it to E: drive. Once he finished his adjustments, SQL Server recognized the E:...

no i cannot create a drive on the E: drive.

Here is my error.

TITLE: Microsoft SQL Server Management Studio Express

------------------------------

Create failed for Database 'test'. (Microsoft.SqlServer.Express.Smo)

For help, click:

no, it is not a clustered server.

both drives are on the same machine.

No apologies neccessary.

To answer the question, no the owner is different. I am the owner of the job and there is a different service account I setup that runs...

The test job step was successful, but the job overall failed because it could not sent out the email. The Operator column is blank.

NOTE: Failed to notify 'Jobs Failure'...

I right clicked on the Jobs Failure operator and went to properties and copied the email address from there and went back to Database Mail and pasted that email address...

When I send a test message, I fill in the TO: field with my email, which is also the SMTP email that I set up. It's just not automatically...

The profile has the profile I set up, SQLAlerts, but the TO: is blank.

So I go the the profile and check the configuration and there is an SMTP...

The last two messages in the Database Mail Log are:

9/19 8:51

Message

DatabaseMail process is started

9/19 9:01

Message

DatabaseMail process is shutting down

I'm having a problem with this. I have my Database Mail setup and I can send test messages. I have made sure that SQL Agent Database Mail is...

Thanks for the input. I'll check it out.

ASquared

i figured it out. i do not need to use dynamic sql when using the matrix table in Report Services.

The user was on IE6.0. I have him updating now to IE7. Everyone else that we tried this on was on IE7 as well. I'll try it...

You guys are awesome. Thanks