To isolate SQL IS running

- connect from localhost ON the SQL machine if you can

Since you have enabled Remote Connection in SAC

Check the Configuration Manager -> Network Protocols -> see...

I normally use SSMS as well

Came across this free DBFriend tool on CodePlex yesterday

It generates a VS2008 project, containing all Tables/SP/Views etc... for a DB

http://dbfriend.codeplex.com/

Yes, either have a copy of SSMS 2005 handy

or do it via the Report Manager web interface

Only 2 ways I know how

Jeffrey Williams (3/25/2009)

---

Find and edit the file rsreportserver.config. Locate the section for the Report Server Email extension. Modify the default host name and permitted host name sections and...

higgins.jerry (3/24/2009)

---

I found the answer to my problem:

https://www.blogger.com/comment.g?blogID=6855339694180792214&postID=3752127317600592384&page=1

SS2008 installation requires you to create a Report Server DB or access an existing one. In 2005 I'm pretty sure...

My SSRS port says 80 (default), but that MAY conflict with your IIS if it's on port 80 already

Try giving it a different port (81, 8080), and re-start the SSRS...

Thanks for the info

can you connect successfully to the MachineName in SSRS Config Manager? did the status say "Started" or "Stopped"?

It's also possible you need a different port between default...

What OS are you running? XP?

SSRS 2008 does not need IIS like SSRS 2005 do, it will have its own web host process

Your URL is clearly not complete

Did you use...

shouldn't be, it's a normal correlated query

update stats and indexes to make sure those are not the causes

and of course, get an Execution Plan in 2000 and 2005 to compare

klnsuddu (3/24/2009)

---

You want me schedule the log backup every hr starting from 2:01AM(1 min past 2:00AM)

Then diff backup will occur at 5:00AM and log backup will occur every hr like...

Jeffrey Williams (3/23/2009)

---

John (3/23/2009)

---

Sorry for not being clearer, I want to open the sql scripts after I have already connected and I want to newly opened files to use the...

I still think it really is suited for Web application (such as backend for high volume websites, especially if hosted externally)

http://www.microsoft.com/sqlserver/2008/en/us/web.aspx

Licensing

SQL Server 2008 Web may be used only to support...

Can't post too much for reasons, but I think I have found the cause for you

NEW COMPONENT OUTPUT

Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042

Report was generated on "-------------".

Maintenance Plan: Backup

Duration:...

Mnn, did your Maint. Plan consist of multiple subplans? or it's one big task?

Mine are 1 Backup plan with 4 Subplans

FULL weekly

DIFF nightly

TLOG hourly

Cleanup

I get 4 text files (1 per...

You can go into the Maint. Plan

Note on the top toolbar (the one that says "Add Subplan" ..... ) there is a small icon right of "Manage Connections ..."

Click that...