Re: [Flexwiki-users] How to setup Flexwiki for external Sql Server

Thu, 16 Aug 2007 08:55:00 -0700

Hi, what is happening is that the database that comes with Flexwiki is used for SQLExpress. SQLExpress will auto-attach the database to its self to the SQL Service that is running. The full version of SQL Server does not auto-attach databases.

I have this same problem on my local computer because I don't have SQLExpress but the Full SQL Server version.
So what you have to do is basically this:

1. Have WebHost4Life setup a database for you.

2. Once the database is setup you need to run the aspnet_regsql.exe to setup all the membership stuff. It's in the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\  folder.
It does have a gui interface but you will have to do this from the command line because your going to an external SQL Server.  You will need to tell it the address of the server the database name and the login information.
I think running aspnet_regsql.exe -h  will give you the help information.

3. Now you will need to modify the Web.config file.

Create a ConnectionStrings Section for the Database Connection:

    <connectionStrings>
        <add name="SqlConnection" connectionString="Data Source=myserveraddress;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=myuserid;Password=mypassword" providerName="System.Data.SqlClient"/>
    </connectionStrings>

You will need to enter your Data Source, Initial Catalog, User ID, and Password for your system.

You will then need to change the connectionStringName to "SqlConnection" in the Membership providers section of the Web.config if you used the configuration above.

Next you will need to change authentication mode to Forms.

4. With this done and if all the settings are correct, you should be able to run Flexwiki without errors.
 
5. The only hard part left is to add users to the membership database.

I say hard because I don't believe that Flexwiki has an user management system in place yet.
So there are a couple options. (I'm not sure all of them will work though.)

A. You could get the Flexwiki source and pull it in to Visual Studio 2005 and use the ASP.NET Configuration to create users. Make sure to copy the updated web.config to that code other wise it won't be able to find the SQL server to manage.

B. Create a new web project in VS 2005 and add the Flexwiki web config to it and use the ASP.NET Configuration interface.

C. You could use something that will run stored procedures on the server and find an run the Add user stored procedure.

6. As far as Flexwiki security goes, I haven't played with it so I can't help you on that, but hopefully you will be able to run Flexwiki and check it out.

I hope this helps and if anyone sees that I missed anything or said anything incorrectly please let everyone know.

Thanks,

JefferyS

Qasper Tech Support wrote:
Has anyone successfully deployed FlexWiki to a public host and has used the user registration feature? Even though App_Data is RWXD, WebHost4Life tech support claims that creating a database on-the-fly and writing to it like App_Data (ASPNETDB.MDF) in FlexWiki does is not secure and they can't support it (I can sort of understand that. They run all databases on separate, secure servers).
 
We have to open a proper database on their separate servers (which is no particular problem for us).
 
What is the alternative in FlexWiki to creating and writing to the on-the-fly database? Is there a connection string somewhere we can tap into and direct all db action to another database?

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

_______________________________________________
Flexwiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/flexwiki-users
  




-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Flexwiki-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/flexwiki-users

Reply via email to