Win7 need Admin Rights

[beckynet]

Hello World,

I've try ADA on Win7 Pro 32 Bits.

This is a fresh install not in domain.

If I launch ADA in Admin session it run fine.

If I launch it on user session (no local admin rights) ADA fail when I indentify the ADA users .

Someone experiment the self ?

Thanks Olivier

Here is the ADA.Log

ADADataSet: Loading SqlScript.sql
Name: Shared.Resources.x-over.png
Name: Shared.Resources.Close.png
Name: Shared.Resources.ADA.ico
Name: Shared.Resources.ServiceSqlScript.sql
Name: Shared.Resources.MinimizeOver.png
Name: Shared.Resources.Dial.jpg
Name: Shared.Resources.DialDown.jpg
Name: Shared.Resources.Skin.jpg
Name: Shared.Resources.SqlScript.sql
Name: Shared.Resources.CloseDown.png
Name: Shared.Resources.x-up.png
Name: Shared.Resources.DialDisabled.jpg
Name: Shared.Resources.Minimize.jpg
Name: Shared.Resources.x-down.png
Name: Shared.Resources.ADAIcon.png
Name: Shared.Resources.MinimizeDown.png
Name: Shared.Resources.SearchLogo.bmp
Name: Shared.Properties.Resources.resources
Name: Shared.Resources.popup.bmp
Name: Shared.Resources.close.bmp
Name: Shared.Resources.CloseOver.png
Looking for SqlScript.sql in System.String[]
Looking for SqlScript.sql: Shared.Resources.x-over.png
Looking for SqlScript.sql: Shared.Resources.Close.png
Looking for SqlScript.sql: Shared.Resources.ADA.ico
Looking for SqlScript.sql: Shared.Resources.ServiceSqlScript.sql
Looking for SqlScript.sql: Shared.Resources.MinimizeOver.png
Looking for SqlScript.sql: Shared.Resources.Dial.jpg
Looking for SqlScript.sql: Shared.Resources.DialDown.jpg
Looking for SqlScript.sql: Shared.Resources.Skin.jpg
Looking for SqlScript.sql: Shared.Resources.SqlScript.sql
Data read for Shared.Resources.SqlScript.sql is --/----------------------------------------------------------------
--/ ADA Database Schema v. 0.1
--/----------------------------------------------------------------
create table settings
(
[name] varchar(75) unique collate nocase,
value varchar(512) not null
);
--/----------------------------------------------------------------
create table connections
(
connectionid integer not null primary key,
[name] varchar (75) unique collate nocase,
type varchar (75) not null
);
--/----------------------------------------------------------------
create table connectionsettings
(
connectionsettingid integer not null primary key,
connectionid integer not null,
[name] varchar (75) not null collate nocase,
value text not null
);
--/----------------------------------------------------------------
insert into settings([name], value) values('DatabaseVersion', '0.1');

ADADataSet: SqlScript.sql loaded
Looking for Spider at C:\Program Files\Digium\ADA\Spider.exe
Spinning off Spider at location C:\Program Files\Digium\ADA\Spider.exe...
Mono.Data.SqliteClient.SqliteExecutionException: SQL logic error or missing database
à Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement(IntPtr pStmt, Int32& cols, IntPtr& pazValue, IntPtr& pazColName)
à Mono.Data.SqliteClient.SqliteCommand.ExecuteReader(CommandBehavior behavior, Boolean want_results, Int32& rows_affected)
à Mono.Data.SqliteClient.SqliteCommand.ExecuteNonQuery()
à ADAShared.ServiceDataSet.ContactsClear(String source)
à Spider.Program.Main(String[] args)

[sds]

Hi,

I have encountered the same issue under a Microsoft Team Server installation and obviously enough, giving administrative control on all users was not a solution for us.

Reading the documentation carefully, we realized that there is one database stored inside the user's %APPDATA% folder and another one inside the global ProgramData folder called Service.db.

The one problematic is the one found inside the global ProgramData folder. By giving Read+Write access to that single file (C:\ProgramData\Digium\ADA\Service.db) to all users that wished to use ADA was enough to make it work.

Hope this helps others.

Regards.

#sds