yes its all on a test pc..... win2000 SP4 workstation

Hi Doug,

Thanks for the reply.

I haven't got any further with this unfortunately.

How about yourself?

in addition if it's of any use......

ASP.NET State Service logged on as .\ASPNET

SQL Server Reporting Services (MSSQLSERVER) logged on as LocalSystem

SQL Server (MSSQLSERVER) logged on as LocalSystem

in...

this time around:

removed all of SQL Server

removed .NET 2.0 framework

removed IIS 5.0

installed IIS 5.0 - checked it worked

installed .NET 2.0 framework - no errors I'm aware of

installed SQL Server.........still cannot...

Thanks for the reply,

i'm now getting the error in the log:

ReportingServicesService!dbpolling!c!10/11/2008-14:13:32:: e ERROR: Polling caught an exception, restarting polling. Error Message System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the...

Hello,

Thanks for the response, I've done what I think is a complete uninstall, but not looked for any residual traces.

After reinstallation, I've applies SP2 too.

I'm at a loss!

I'll uninstall again...

Many thanks for the response but it hasn't really helped matters!

I've compared my setup with that on another laptop and attempted to duplicate it, still to no avail.

One thing that...

Yet again,

I've done a new install, accepting all the defaults. No errors occurred during installation and all install logs appear fine.

When attempting to access http://localhost/reports IE hangs......what is...

Thanks Matt,

I'll give it a go...

Thanks Steve,

I just think I need to 'buckle-down'!

I've also been looking around for free/trial RSS feed apps that I can use to populate a DB, thus enabling me to work...

Well done!

I'm only scoring around 55% in the Training Kit Exam at the mo', so still some way to go!

I think i've figured it out........

SET DATEFORMAT dmy

Select CASE

WHEN columnname IS NULL THEN NULL

ELSE convert(datetime, columnname)

END

from tablename

I've figured out that I was using a lower case 's' as opposed to capital 'S' in my command:

sqlcmd -s localhost\sqlexpress -e

should be

sqlcmd -S localhost\sqlexpress -e

....need to pay more attention...

H, i've restarted sql server using the config man. but to no avail.

MCTS Self-Paced Training Kit (Exam 70-431) Microsoft SQL Server 2005—Implementation and Maintenance (available mid 2006)

http://www.microsoft.com/learning/exams/70-431.asp