Prepare Sql Server to Store Azure Appfabric cache Velocity Cluster configuration

we have to create login in Sql Server.so we can access cluster configuration database through out that Username and Password and also we have to enable remote access in Sql Server.

if you have Sql server install,Open Sql server Surface Area Configuration tools From Start Menu -> All Programs -> SQL Server ... -> Configuration Tools -> Sql Server Surface Area Configuration. and Click Surface Area Configuration for Services and Connections.You will see below dialog box.

Select Local and Remote Connection From Right Pane and in sub option select Using TCP/IP Only or Using TCP/IP and named pipes and click apply and ok.

and also you have to set the FireWall exception for Sqlservr.exe and Sqlbrowser.exe,so firewall allow this executable to accept remote connection requests. path of this executable is,SQL server installation Folder\90\Shared\Sqlbrowser.exe and SQL server installation Folder\MSSQL.1\MSSQL\Binn\sqlservr.exe.

Follow this step:- Go to Control panel -> Window Firewall.Click Add Program Button and Browse for Above executable and add it.after this, you will see something like below.

if Antivirus personal firewall is used,then please configure the above settings for that also because it also block the remote connection,refer antivirus provider manual for more information.

Now Sqlserver is ready for accepting remote connections.and after this we have to create Login account and Blank ClusterConfiguration Database.
First Login with default SQlserver Account and Create new user for Velocity access.see the below Screenshots.




you have to set Login Name,and password which is used for login when we install Velocity configuration.



ClusterConfiguration Database is created.and you can now access it by login that you created above.now it is ready for velocity configuration storage.