206
edits
Changes
From SME Server
Jump to navigationJump to search
mLine 88:
Line 88: − + + + + + + + + + + +
→Test with tsql: added tsql response
unixodbc: yes
unixodbc: yes
Test connection to a foreign database, overriding settings in freetds.conf (modify to suit your conditions):
Test connection to a foreign database, overriding settings in freetds.conf (modify to suit your conditions, ip could be replaced with FQDN):
tsql -S 192.168.0.112 -U username -P password
tsql -S 192.168.0.112 -U username -P password
A response something like this would indicate that connection was successful but login failed (wich is normal at this stage):
locale is "sv_SE"
locale charset is "ISO-8859-1"
Msg 18456, Level 14, State 1, Server XP3B\SQLEXPRESS, Line 1
Login failed for user 'testuser'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
===Configuration===
===Configuration===
