What is the proper syntax for the connection string?

This page http://www.microsoft.com/web/post/how-to-publish-a-web-application-using-webmatrix

suggests

<add name="CohoWineryConnectionString" connectionString="Data Source=Server01;Initial Catalog=CohoWinery; Trusted_Connection=True" /> 

OR 

<add name="SmallBakeryConnectionString" connectionString="Data Source=Server01;Initial Catalog=SmallBakery; User Id=username; Password=password" /> 

this thread http://forum.arvixe.com/smf/dotnetnuke-software/problems-getting-dnn-going/

suggests

server=PARSLEY.arvixe.com;database=\App_Data\Database.mdf;user id=myuserId;password=correct password

So, is it database or Initial Catalog?

Is it case sensitive (password vs Password)?

Do I have to include and set "User Instance" in the string?

 

Also, do I have to worry about the key?

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />

I f I am connecting to a database with user/password.

there are a number of different options depending on what type of security you're using and whether or not you're using sql express user instances - http://www.connectionstrings.com/sql-server-2008 covers all the various permutations. BTW it's easiest to kick off an install and enter the values into the wizard as it will correctly update both connectionstrings.

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US