Thanks, it worked for me too!!! Oh what a relief 😀

Hi dmusson17,

I'm sorry, this is not a recommendation wrt your issue, rather this is a request for help regarding using excel in SSRS.

I've created the datasource but the ReportBuilder is...

Thanks GP 🙂

Now, I've decided to use the good old SSRS 2005! So, I've created the excel datasource and then I click on ReportBuilder.

Here, on the right handside the...

Hi egpotus,

Could you please let me know how to use Xls as a datasource for SSRS. I've been trying hard to implement this. I'm stuck at a stage where the...

Thanks Luke.

http://support.microsoft.com/kb/971049 talks about the hotfix for SQL 2008. Is there a similar fix for SQL 2005 as well? Has anyone come across such a situation?

Thanks...

Hey Guys, sorry for posting a late reply. I was held up with some other task.

We reinstalled SP3 and that fixed the problem!! I'm not sure if that is the...

There you go,

Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2...

We are using SQL Server 2005 Enterprise Edition 64-Bit Build 3790: SP2

Thanks

Thanks for the updates guys!!

Well, it just says "Mail queued" but it doesn't get delivered though!!

Just a passing thought, is this in any way related to the SQL Server...

No luck! It just shows "Mail queued"

Please do let me know is you guys have an update.

Thanks a lot for your time!:-)

SQL Error Log is not showing any related error.

I'm executing this statement

exec msdb.dbo.sp_send_dbmail @recipients='my email address', @body = 'TestMail'

Is DBMail enabled on the server?

DBMail is enabled on the server, checked in Surface Area Configuration.

If so, does it have a profile set up?

Yes, I have set up a profile.

If...

Thanks for the reply. Yes, service broker is enabled. The output of the query is 1

Thanks for the reply. Well, I did connect to the server but the only instance name that is present is that of the cluster. There is one more server which...