Tuesday, May 19, 2009

How to share a GENEXUS KB

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

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:

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 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!

3 comments:

Э. Баярсайхан said...

Хаана, юу л хийгээд яваад байна даа?

Э.Буянт-Оргил said...

сайн уу? найз нь япондоо л ITгаараа л ажиллаад л байгаа чамаа р юу байна ажил төрөл сайн биздээ? сонин сайхан юутай байна

Э. Баярсайхан said...

Зөвхөн Монголдоо л байдгаараа байж л байна даа, хө.