[C#] Visual Studio Database woes...

Site is on one domain and I need to remotely connect to an SQL Database.
- In the Server Explorer, connecting to the SQL Database uses Windows Authentication.
- With Windows Authentication on, produces untrusted zone error.
- With it off, produces failed login error.

The fix?
- Connection string format:
"Data Source=<source>;Persist Security Info=False;Initial Catalog=<initial_catalog>;Trusted_Connection=Yes"

- In Web.Config, add
<configuration>
   <system.web>
       <identity impersonate="true"/>

---------------------------------------------------------------------------------------------

Sql Db Type is numeric, but how to express it in C#?
- Use Decimal

----------------------------------------------------------------------------------------------

How to express VarChar(MAX) in C#?
- SqlDbType.VarChar, -1

----------------------------------------------------------------------------------------------

[.NET] IIS - Failed to access IIS metabase

In command line, go to the folder of your .NET Framework version that is specified in the error page. It should be the small text at the bottom. Now type aspnet_regiis -i and you should be good to go. If not, try aspnet_regiis -u and aspnet_regiis -i afterwards. If that doesn't work, then keep trying aspnet_regiis -i. It'll eventually work I guess.

This is for a WinXP SP3 system running IIS 5.1.