I believe BIG TIME in doing nothing more than recording how I solved problems when fooling around, both as a log for myself, as well as a log for search engines.
Here's my story:
I just did an install of SQL Server 2005 and ran into a weird problem. Actually, I first started doing an install of Visual Studio Team Foundation Server Beta 3 (VSTF) and ran into a weirdo dialog box saying that the reporting server that couldn't be started. THANKFULLY, the dialog could be copied and restarted, and so I copied the text and tried to run it from the command line. So when I ran it, here's what I saw:
C:\>"d:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Tools\createds.exe" /setup /install "
http://Localhost/ReportServer/ReportService.asmx" TfsReportDS "Data source=COMPUTERNAME;initial catalog=TFSWarehouse" "DOMAIN\SERVICEACCOUNT" "VERYLONGSTRING"
Unable to connect to the Yukon Reporting Server. Please check that the Yukon Reporting Web and NT services are running and you have sufficient privileges on the data tier: The request failed with HTTP status 404: Not Found.Data source creation failed.
Upon trying to open the Sql Configuration Manager and tried to connect to the Reporting Server, I got hit with this.
TITLE: Connect to Server
------------------------------
Cannot connect to Localhost.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
The request failed with HTTP status 404: Not Found. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Turns out that I had previously done an install (SUS) and it turns out that it was installed on port 80. When SQL Server did the Reporting Server install, it did it in the default webserver which was also on port 80, and stopped. Changing the SUS port to 85 and starting up the default web server solved the problem.
No big insight here, just wanted to log it for the search engines.
D