| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 15/08/2008 05:38:04
|
rtx
SysAider
Joined: 15/08/2008
Messages: 4
Offline
|
We are trying to install sysaid with SQL 2005 DB, but we cannot get a connection to the DB-server. We have changes the localhost.... etc to the correct names. But the Check connections fails.
Exception while checking configuration: logon failed: Login failed for user 'domain\user'
This is the setup
Microsoft SQL Server
net.sourceforge.jtds.jdbc.Driver
JDBC URL: jdbc:jtds:sqlserver://srv-db-nsb2:1433/sysaid
UserName: Domain\user
Pass: xxxxxxx
any help appreciated
|
|
|
17/08/2008 13:12:36
|
Joseph Zargari
SysAid Customer Relations
Joined: 26/03/2006
Messages: 441
Offline
|
rtx,
When connecting SysAid to a Microsoft SQL database, the username field cannot hold the domain prefix. If you need to login with a Windows account (rather than SQL account), you can add ';domain=DOMAIN-NAME' to the JDBC URL.
For example:
Driver: net.sourceforge.jtds.jdbc.Driver
JDBC URL: jdbc:jtds:sqlserver://srv-db-nsb2:1433/sysaid;domain=ACME
Username: johndoe
Password: *******
If this doesn't help, you should make sure that your SQL server allows Windows authentication.
|
|
|
18/08/2008 20:39:48
|
Harold.Ballinger
Elite SysAider
Joined: 16/06/2008
Messages: 134
Offline
|
I just had to do the exact same thing today and SysAid support helped me find out that MS SQL 2005 has TCP/IP connectivity disabled by default. SysAid tech support helped with this and had me up and running in no time!
|
|
|
19/08/2008 04:54:46
|
Joseph Zargari
SysAid Customer Relations
Joined: 26/03/2006
Messages: 441
Offline
|
Harold,
The TCP/IP thing is different. Your error message probably stated something about the connection failing.
In rtx's scenario, the connection succeeded, but it failed on authentication.
rtx, did my advice helped you?
|
|
|
05/12/2008 12:59:53
|
boisronds@yahoo.com
SysAider
Joined: 27/10/2008
Messages: 1
Offline
|
I am getting an error stating: "Exception while checking configuration: Connection Refused: Connect".
Please help!
|
|
|
07/12/2008 10:09:39
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello boisronds
Are you using SQL 2000 or 2005?
By default, Microsoft SQL 2005 has the TCP/IP protocol not enabled. Please make sure that TCP/IP communication is enabled. You can do this with the following steps:
1) Go to Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager.
2) Navigate to SQL Server 2005 Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP -> Protocol tab and make sure that the Enabled field is set to Yes.
3) In addition, switch to the IP Addresses tab and make sure that all Active fields are set to yes and that all TCP port fields are set to 1433.
Best regards.
Haim
|
Pushing IT forward |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
