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

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

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
ariva
SysAider

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

SQL Server should be using Mixed Authentication mode instead of Windows authentication mode.
MX-KD
SysAider

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

Hello,

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

CarlH
Elite SysAider

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

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
MX-KD
SysAider

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

Hi,

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

Bethesdaadk
SysAider

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

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:  6 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
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   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.
   2002-2011
   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