64 bit installation of SQL server on 64 bit Windows requires 64 bit version of ASP.NET

32 bit installation of Reporting services will require 32 bit version of ASP.

There are two...

Did you run any 32 bit applications on this server prior to installing SQL server 2005?

Verify that your are not running your IIS in 32 bit compatability mode:

http://support.microsoft.com/kb/894435

HotFix:

http://support.microsoft.com/kb/929376

You do have SMTP service configured on your Exchange server.

Otherwise database mail wouldn't work.

1. telnet 25

2. set local_echo

3. helo (response OK 250)

4. mail from: (response 250 OK)

5. rcpt to:

6. data

7. To:

From:...

From MS page: "A status of unsent indicates that the Database Mail external program has not yet processed the e-mail message."

If database mail configuration would be wrong - you would...

On SMTP configuration you are using a fully qualified domain name.

That is exactly why personally I always prefer to have a local SMTP running on the SQL server. Besides everything...

Final question before calling guys in blue 🙂

What is the Agent account? Is it domain account? Local System Account?

It is in IIS. You can take a look by starting IIS and then right click on Default SMTP Virtual Server, then Properties.

Go to Access Tab and click on Authentication.

It might happen if your SMTP virual server authentication is set to Integrated Windows instead of Anonymous.

The "unsent" status is ALWAYS linked to SMTP configuration.

It is not a limitation of a local variable. It is a limitation of ORDER BY clause.

(And in this case scenario it is "granted by design").

select * from #tmp order by

case @Cola

when 'eno' then eno

else ename

end

Excerpt from code published on SQLServerCentral:

ORDER BY

CASE @sort

WHEN 1 THEN

(CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.user_seeks)+CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.unique_compiles))*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_total_user_cost)*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_user_impact/100.0)*-1

WHEN 2 THEN

(CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.user_seeks)+CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.unique_compiles))*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_total_user_cost)*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_user_impact/100.0)

ELSE NULL

END

# - specifies an optional placeholder

0 - specifies required placeholder

Format(Table!Field.Value,"#0.00000")

will always return 5 digits after comma.

You forgot to mention which version of SQL server you are using? (Based on credential error message it should be 2005).

xp_cmdshell execution requires windows security rights and can't be executed...