Using Sql Server for Azure Appfabric cache velocity ClusterConfiguration

Start Velocity installation. when it asking for Configuration use below Settings.



1. Select SQL Server Database from Storage Location type.
2.enter appropriate connection string,Ex:- Data Source=xxx;Initial Catalog=xxxx;User ID=xxx;Password=xxxx;"
3.In above connection string Data Source is the name of host where you install Sql Server,Initial Catalog is name of the database you want use for velocity clusterconfiguration storage,User ID username for login to Sql server Password for Login to Sql server.

if you are installing velocity in second host then clusterName is selected from First velocity host configuration if you database is connected properly.

See My Previous post for prepare Sql server for Velocity Prepare Sql server for Velocity for Preparation of SQL server.