SysAid Reports

 
Author
Message
LJ
SysAider
3
 
How can I get my SysAid tables into an Access Front End? I am much more familiar with access so I can create custom reports on the fly as needed.

Thanks.
LJ
Ori
SysAid Customer Success Manager
298
 
Dear LJ,

Can you please let us know what database are you using in your implantation? You can only use databases that has ODBC connection (MySQL / MS-SQL / Oracle) so if you are using the embedded one (Derby), you will not able to perform this.

Best Regards.
Ori Sharon.
LJ
SysAider
3
 
Is there anyway to change the database from derby to MySQL?
Ori
SysAid Customer Success Manager
298
 
Dear LJ,

To migrate the database from the embedded database to an external type (Microsoft SQL, MySQL or Oracle) you need to send us the database and our support team will perform the migration. We usually schedule this to be done over the weekend, to minimize downtime on your end. If you send us your database on Friday/Saturday evening, we could have it ready by Monday morning.
If you are interested, please send us an email to helpdesk@sysaid.com and attach your ...\SysAidServer\root\WEB-INF\conf\serverConf.xml file and tell us which database type you are interested in migrating to. Also, please tell us which version of SysAid are you currently using + when you wish to schedule this for.

Best Regards.
Ori Sharon.
SysAider
25
 
Hi,

I also would like to migrate from Derby to MS Sql 2005 database. Can anyone guide me on how to do it?
I already install Ms SQL and SysAid.. but did not managed to connect them together..
Thanks in advance..
SysAider
25
 
I'm having this error:

Exception while checking configuration: Logon failed: Login failed for user 'administrator'. The user is not associated with a trusted SQL Server connection.

Anyone can help me out? Need it urgently..
Anyway thanks in advance..
SysAid Wiz
583
 
Your Administrator account is probably not the one you use to access the SQL Server.

In Active Directory create a user for SysAid Access, and then give it full permissions via groups for SQL then use this username and password in SysAid for access to the SQL Database.

Let me know if this resloves the issue!

M
When the going gets tough, the tough get SysAid
SysAider
25
 
ok, thanks BJINS..
i'll try on that later..
by the way, do i have to set a connection between ms sql to derby using firebird odbc?
thanks..
SysAid Wiz
583
 
I don't quite understand your question, Newbie.

Are you currently on a SQL database or are you on Derby and looking to migrate onto a MS-SQL database.

With any work regarding working directly with the database structure you are best contacting the Helpdesk at SysAis Support directly and have them deal with it.

Either email helpdesk@sysaid.com or submit a ticket at https://helpdesk.sysaid.com
When the going gets tough, the tough get SysAid
SysAider
25
 
hi BJINS,

i still got the same error.. have tried to use all available username and password related to ms sql.. but still in vain..
is there any possible method to encounter this?
need to install the software asap..

anyway, are u using ms sql 2005 db as your db?
would u mind to share your steps in installing sysaid and connecting it with ms sql?

thanks..
SysAid Wiz
583
 
I am not using MS SQL presently (purely due to the lack of foresight from the up-aboves) however I have experienced this error before.

I would suggest taking a zipped copy of your logs and sending them to Ilient and opening a Service Request. That will most likely get the problem solved quicker than on here.

Sorry I can't be of more use!

M
When the going gets tough, the tough get SysAid
SysAider
25
 
I see.. then, you're using what type of database?
Is there any charges is I ask for Ilient to help set up my database? :-s
Anyway thanks BJINS for answering my questions.
SysAid Wiz
583
 
I am using a Derby Database.

If you have already purchased SysAid full version then i believe a service like that would be free of charge. Also, if you are using the free version for evaluation I believe the free service may also be available.

I will PM a member of the service desk and sales to ask them to help you.
When the going gets tough, the tough get SysAid
SysAider
25
 
Oo.. you're using Derby. I thought you're using external database.
Currently I'm using trial version. Will purchase once managed to run on production environment successfully.
Anyway, thanks a lot BJINS for helping out and will help me again. Sorry to keep troubling you.
SysAid Wiz
583
 
Not at all! That's what everyone is here for!

I have PM'd Ilient, so you should hear from someone in the next couple of days! =)

M
When the going gets tough, the tough get SysAid