Usage

fwsqlmgr create <instance> <database> <datadir>
  Creates a new SqlStore database at the specified location.

fwsqlmgr grant <instance> <database> <user>
  Grants access to the database for the specified user.

fwsqlmgr help
fwsqlmgr /help
fwsqlmgr /?
fwsqlmgr 
  Displays this message.

<instance> - Name of a SQL Server instance to use. E.g. ".".
<database> - Name of the SQL Server database to use. E.g. FlexWikiSqlStore.
<datadir>  - Directory in which to create the data files. E.g. C:\temp.
<user>     - Fully qualified NT user to grant access to. E.g. ISENGARD\ASPNET.

Note that the name of the executable is the abbreviated fwsqlmgr, even though the name of the project is SqlStoreDatabaseCreationTool.

What happened when I tried to use this tool to create a datastore

• The tool has to be downloaded in the tools package FlexWikiCore-1.8.0.1677-tools-Release.zip
• c:\temp is an unusual place to store mdf files
• the tool has to be run on the machine running sql server
• the tool drops the database first, so make sure there are no connections to it if it already exists
• if the datadir has spaces in its name, then wrap it in double quotes
• the tool must be run by a user with database creator rights
• it then fails:

System.Security.SecurityException: Request for the permission of type System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
   at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet grantedSet, PermissionSet deniedSet, CodeAccessPermission demand, PermissionToken permToken)
   at System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames, Int32
 unrestrictedOverride)
   at System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark)
   at System.Security.CodeAccessPermission.Demand()
   at System.Data.SqlClient.SqlConnectionString.Demand(SqlConnectionString constr)
   at System.Data.SqlClient.SqlConnection.Open()
   at FlexWiki.SqlStoreManagerLib.DatabaseHelper.CreateDatabase(String instance,
 String database, String dataFileDirectory)
   at FlexWiki.SqlStoreManagerConsole.App.Main(String[] args)

Has anybody had any 'luck' with this?

• Geoffrey