1&1 VPS FAQ

http://www.faq.1and1.com/dedicated_servers/virtual_private_servers/windows_vps/general_information/index.html

1. install .Net 3.5, SQL Express 2005, MSSMSE

2. Modify the registry table to remove "mscorlib.tlb could not be loaded" http://kbalertz.com/918685/Error-message-install-Server-could.aspx

3. Open IIS to create the new web site.

4. Change the permission from "no script" to "script only"

5 Open MSSMSE to add "Network Service" login account and customized user login account.

6 Add a new user for the target db (better use the same name with the customized user login created in step 5)

7. Don't forget the grand the permission.

8. connection string for .Net 2.0 and above is like this:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;

http://www.connectionstrings.com/default.aspx?carrier=sqlserver2005

9. Have to activate the Plesk to create a backup of VPS image manually, which will consume lots of resource though for the $29.99 plan.