Getting Error: Login failed for user domain\username

Q&A regarding installation and issues getting started with Servoy

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: 97
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 sbutler » 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- Training Videos
Servoy Components- Plugins, Beans, and Web Components
Servoy Guy- Tips & Resources
ServoyForge- Open Source Components
User avatar
sbutler
Servoy Expert
 
Posts: 759
Joined: Sun Jan 08, 2006 7:15 am
Location: Cincinnati, OH


Return to I'm just getting started

Who is online

Users browsing this forum: No registered users and 2 guests

cron