Installation Problems (SQL)
 
Author
Message
SysAider
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
10
 
SQL Server should be using Mixed Authentication mode instead of Windows authentication mode.
SysAider
3
 
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

Elite SysAider
241
 
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
3
 
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 Mar. 20, 2012 07:53 AM

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