aspose file tools*
The moose likes JDBC and the fly likes sql2008 windows authentication throwing invalid user  error in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql2008 windows authentication throwing invalid user  error in java" Watch "sql2008 windows authentication throwing invalid user  error in java" New topic
Author

sql2008 windows authentication throwing invalid user error in java

sam mat
Greenhorn

Joined: Feb 01, 2012
Posts: 4
Hi,

I have an web application in jsf trying to connect to a remote sql server2008 using windows authentication.
My connection string has the below signature



I have added the sqljdbc_auth.dll in the system path and well as in the system32 folder. But when i try to login it throws an invalid user error.
The user has been added in the server already. Any suggestions on this would greatly be appreciated.

thanks
sam
Ashwini Kashyap
Ranch Hand

Joined: Aug 30, 2012
Posts: 90
Hi,

Try using following signature instead of which is mentioned by you:

jdbc:jtds:sqlserver://serverName;instance=instanceName;databaseName=DBName;user=userName;password=password

Hope this helps.


Thanks and Regards,
---------------------------------------------------------------------------------------
Ashwini Kashyap | akashyap@infocepts.com | www.infocepts.com
---------------------------------------------------------------------------------------
sam mat
Greenhorn

Joined: Feb 01, 2012
Posts: 4
Hi Ashwini,

Thanks for replying.
But like i mentioned i am trying to enable a windows authentication for login.
Also w.r.t the string given by you what does jdbc:jtds imply. Do i have add any library file for this.
I am sorry i am pretty new to this.

regards
sam
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql2008 windows authentication throwing invalid user error in java