Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support    Do It Yourself
Hello Guest,  Login   
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Installation Problems (SQL)  XML
Forum Index » SysAid Installation & Beyond
Author Message

SysAider from release 7.5 Germany
Joined: 13/03/2012
Messages: 3

Hello everybody,

I hope you can help me i have a little Problem to install SysAid with the MS SQL Server.

When I check the connection there comes a message like:

Exception while checking configuration: Network error IOException: Connection refused: connect

The Configuration is:
JDBC Driver: net.sourceforge.jtds.jdbc.Driver
JDBC URL: jdbc:jtds:sqlserver://localhost:1433/sysaid;useCursorsAlways=true
User Name: sa
Password: ***** <- the right one

Thank you for your Help.

Best wishes

SysAider from release 7.5 Fiji
Joined: 11/01/2012
Messages: 10

SQL Server should be using Mixed Authentication mode instead of Windows authentication mode.

SysAider from release 7.5 Germany
Joined: 13/03/2012
Messages: 3


thank you for your Answer.

Mixed Authentication is enabled but it doesn´t work...

I have a Microsoft SQL Express 2008R2 Server, is the "express" the problem?

Do you have any other ideas for me?

Thank you for your help

Best wishes

Elite SysAider

SysAider from release 4.5 United States Pathfinder
Joined: 30/01/2009
Messages: 222

I don't think express is the issue.

Are you able to connect to the SQL server by other methods? I just want to make sure SQL is actually accepting connections

SysAider from release 7.5 Germany
Joined: 13/03/2012
Messages: 3


I can connect to the database with the "Microsoft SQL Server Management Studio" without problems.

My MS:SQL experience aren´t so good...
If you want please say me how I can test it right.

And is it possible to import our old sysaid Datas?
We used SysAid before with a sql db to and if it´s possible we will use our old datas in the new System
(We habe a new server but a full backup of the old)

Best wishes & thanks for your help

This message was edited 1 time. Last update was at 20/03/2012 07:53:23


SysAider from release 6 United States
Joined: 23/07/2009
Messages: 21

SqlExpress 2008 R2 Issues. Could not get SysAid to connect to a new blank DB.

My SQL DB person finally figured out to go into the "Sql Server Configuration Manager" as opposed to the studio.

"Protocols for SQLEXPRESS" (or whatever you named your instance.

TCP/IP properties need to be enabled

IPALL Section of IP Addresses tab

Set TCP Port to 1433

Then we were able to connect SysAid to SQLExpress on the same machine.

[Thumb - sqlexpress setup.JPG]
 Filename sqlexpress setup.JPG Download
 Description SqlExpress setup
 Filesize 84 Kbytes
 Downloaded:  8 time(s)

Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use