I have a test database created by the colleagues from IT department and I can also access / see it using MS SQL Server Management Studio 2016. However, I cannot establish a connection to it from within Mathematica notebook... I read the documentation but I'm not confident with databases in general, so maybe I make a basic mistake somewhere. What I do is:
Needs["DatabaseLink`"] conn = OpenSQLConnection
That opens the Connection Tool GUI, where I define the new connection:
- define the name and description of database (test / test database);
- visibility (user level);
- type of database (Microsoft SQL Server jTDS);
- Connection: Hostname (wwe***pe..*.ds\MSSQL***); Port (1433); Database (empty); Attributes (empty); Username (****); Password (*******).
The hostname, username and password are the ones which I use (and worked) for connecting to database via MS SQL Server Management Studio. At this stage, when I push the "Test" button, I get after a few seconds the error message
On the next page, "Connection properties", I leave everything unchanged, than I click "Finish". Now, when I try
conn = OpenSQLConnection["test"]
I get (almost obviously) the error
JDBC::error: Unknown server host name 'wwe**pe.**.***.ds\MSSQL***'. $Failed
It would be nice if somebody could guide me to solve this connection issue. Thanks in advance!