Getting Error: Login failed for user domain\username

Questions and answers for all installation-related topics for Servoy products

Getting Error: Login failed for user domain\username

Postby ygovind » Tue Oct 06, 2015 9:37 pm

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.
ygovind
 
Posts: 4
Joined: Tue Oct 06, 2015 9:32 pm

Re: Getting Error: Login failed for user domain\username

Postby Ruben79 » Tue Oct 06, 2015 11:38 pm

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.
Ruben de Jong
Stb Software Development
SAN Partner

Stb Software Development - http://www.stb.nl
User avatar
Ruben79
 
Posts: 72
Joined: Wed Apr 18, 2007 12:43 pm

Re: Getting Error: Login failed for user domain\username

Postby ygovind » Thu Oct 08, 2015 8:11 pm

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
ygovind
 
Posts: 4
Joined: Tue Oct 06, 2015 9:32 pm

Re: Getting Error: Login failed for user domain\username

Postby goldcougar » Sun Oct 11, 2015 4:10 am

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
Scott Butler
iTech Professionals, Inc.
SAN Partner

Servoy Consulting & Development
Servoy University- Free Training Videos
Servoy Guy- Free Plugins, Tips & Resources
ServoyForge- Open Source Servoy Components
User avatar
goldcougar
Servoy Expert
 
Posts: 657
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH


Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests