I have created few databases using sqlserver studio 2012 and I am able to get into the database using my domain\username in sql server 2012 studio. But when I am trying to connect repository_server with these details - it gives me the error “Login failed for user domain\username”.
Server name: repository_server
User name: domain\username
Password: xxxxxxx
URL: jdbc:jtds:sqlserver://localhost:1433/database_name
Driver: net.sourceforge.jtds.jdbc.Driver
I am new to this platform and will need help here. Please let me know if I am missing any steps.
Although it seems to be possible by specifying the domain name as shown in the jTDS FAQ, you still have to provide the username and password in the connection. So, if your domain password changes, the connection can’t be made anymore.
I’ve only used SQL Server’s mixed mode authentication and use a dedicated user/password combination to be used from Servoy.
This is what my connection string looks like in Servoy
jdbc:jtds:sqlserver://localhost:1433/TEST_REPOSITORY;instance=MSSQLSERVER;user=domain\ygovind;password=xxxx
I have TCP/IP services enabled, all SQL services are also running. Not sure what I am missing here but I am still getting failure message: Login failed for user domain\username
Also, just to check the basics, by default SQL Server has JDBC disabled. You’ll need to enable it. Instructions here: http://stackoverflow.com/questions/1086 … onnections