Official Content

Warning: Sharing a KB the way it is described in this document may lead to performance issues and is not recommended. It was a valid option when GeneXus Server was not invented. For Team development, the recommended solution is GeneXus Server.

Since GeneXus has multiuser support, you may want to share your Knowledge Base among different users.

Scenario 1

If you already have a KB in your local drive and server and want to share it, do the following steps:

1. Copy the whole directory to a network folder.

2. Edit with notepad the 'knowledgebase.connection'  (filed under the KB directory) and:

a) set a ServerInstance that is accessible from you and your peers

b) set CreateDbInKbFolder to False

The knowledgebase.connection will then be something like this:

<ConnectionInformation>
    <DBName>GX_KB_Test</DBName>
    <IntegratedSecurity>True</IntegratedSecurity>
    <ServerInstance>ARMIN-D620\SQLEXPRESS</ServerInstance>
    <CreateDbInKbFolder>False</CreateDbInKbFolder>
</ConnectionInformation>

3.  Go to the SQL Server Management Studio, log in to SERVERNAME\SQLEXPRESS with integrated security (trusted connection) and Attach the MDF.

4.  Still being in the SQL Server Management Studio, give your peers dbowner rights on GX_KB_Test.
if they connect without that right, they will get something like this:

<fck:meta content="text&#47;html&#59; charset&#61;utf&#45;8" http&#45;equiv="Content&#45;Type"><fck:meta content="Word&#46;Document" name="ProgId"><fck:meta content="Microsoft Word 12" name="Generator"><fck:meta content="Microsoft Word 12" name="Originator">

</fck:meta></fck:meta></fck:meta></fck:meta>

The SELECT permission was denied on the object 'EntityType', database 'GX_KB_Test', schema 'dbo'. (Microsoft SQL Server, Error: 229)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476

5. Go, using the command prompt, to the .net framework installation folder and execute "caspol –m –cg LocalIntranet_Zone FullTrust" in order to give .net execution rights to the intranet or take a look at SAC 19259 for further details. If you don't do this step, you may get an error when trying to build your application. Do this in each user's machine.

6.  Share the folder to the others and give them also NTFS rights to create and update files in that folder.

7. You and your peers are ready, open the KB!

Note: Stop Indexer when you are not alone, since indexing isn't supported in this scenario. More Information

Scenario 2

If you have just the backup  (.MDF of your KB), do the steps described in HowTo: Create a KB From an .MDF and then do the steps 4, 5, 6 and 7 described above.

Have troubles? Take a look at this page Basic tips about Managing KBs using SQL Server

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant