How come I cannot view my SQL Server database in Management Studio 2008?

Until we upgrade to SQL Server 2008, you can refer to this link in the event you are using Management Studio 2008

If you are seeing issues viewing your SQL Server 2005 database in Management Studio 2008 and the database is provisioned correctly in our system, you can refer to this link

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

You are going to have to connect to a SQL 2008 Database engine, click on the Databases folder, right click in the column headers and uncheck collation. Then you can connect to a SQL server 2005 database engine.

How can I set custom 404's for ASP/.NET?

Custom 404's can be set for ASP and .NET sites by adding the below code to the bottom of the web.config file before the final </configuration>. You will need both options to redirect all 404's.

Classic ASP and Static Content

<configuration>
  <system.webServer>
         <httpErrors errorMode="DetailedLocalOnly" defaultPath="/404.asp" defaultResponseMode="ExecuteURL">
            <remove statusCode="404" subStatusCode="-1" />
            <error statusCode="404" prefixLanguageFilePath="" path="/404.html" responseMode="ExecuteURL" />
         </httpErrors>
  </system.webServer>
</configuration>

.NET

<configuration>
  <system.web>
    <customErrors defaultRedirect="404.aspx" mode="DetailedLocalOnly">
      <error statusCode="404" redirect="404.aspx"/>
    </customErrors>
  </system.web>
</configuration>

This exampled shows 404's for all content redirecting to index.html:

<configuration>
  <system.webServer>
         <httpErrors errorMode="DetailedLocalOnly" defaultPath="/index.html" defaultResponseMode="ExecuteURL">
            <remove statusCode="404" subStatusCode="-1" />
            <error statusCode="404" prefixLanguageFilePath="" path="/index.html" responseMode="ExecuteURL" />
         </httpErrors>
  </system.webServer>
     <system.web>
                 <customErrors mode="On">
                     <error statusCode="404" redirect="/index.html" />
                </customErrors>
     </system.web>
</configuration>

Uploading content to a website using FTP

Pre-reqs

• A primary or secondary ftp account for the website. Reference -
• Access to a ftp client such as :
  • A command line Linux ftp client
  • An open source tool like WinSCP (used in this article) or FileZilla
  • Windows and Mac users can also use ExpanDrive to map FTP storage location as a local drive.

Procedure

• Get the ftp server address by logging to the Services Control Panel. Navigate to Hosting->Cloud Sites. Click on General Settings tab. The address for the ftp server and alternate ftp server is available in the "Edit your Site" section.

NOTE: The primary server is available only if the domain is an active registered domain.

• Get the IP address of the ftp server by logging on to the Services Control Panel. Navigate ...