Sql Store Manager Gui

* Set the SqlServerInstanceName to the name of the computer that hosts your SQL Server or MSDE instance (if the database server is hosted locally, you can use "localhost" or leave as the default provided).

* Set the DatabasePhysicalFileLocation to the folder you would like your SQL database stored (by default, C:\Program Files\Microsoft SQL Server\MSSQL).

* Set the SqlServerUserName to the ASPNET instance of your computer (such as "MyComputer\ASPNET").

* Click the "Create Database" button.

Note

If you are trying to create the database against a remote SQL Server and are having problems with the DatabasePhysicalFileLocation setting, try creating the database in c:\ then in Enterprise manager, detach the database - move to the proper location for your data file - then re-attach.

Nearby

SqlStoreManagerConsole

SQLServer2005

Currently, this tool does not work with SQL Server 2005, because the creation script creates a 1MB sized data file. SQL Server 2005 expects a minimum of 2MB. By extracting the scripts from the tool using Reflector, I was able to create the database and database objects, and now I'm running FlexWiki with SQL Server 2005 as storage. Works perfectly! --Eric, 2006-04-04 Or, if you have the source code, Edit file C:\projects\flexwiki\FlexWikiCore\SqlStoreManagerLib\Scripts\CreateFlexWikiDatabase.sql

 and change "SIZE = 1" to "SIZE = 2" in the "CREATE DATABASE" line, line 15.  Recompile the application.  Now the application will work for both SQL Server 2000 and 2005.  --BruceHaley

Not logged in.

Welcome to the home of FlexWiki, a collaboration tool, based on WikiWiki, implemented using Microsoft .NET technologies

This is FlexWiki, an open source wiki engine.

This site supports the new NoFollow anti-spam initiative.

Change Style

Recent Topics

SqlStoreManagerGui