This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql2008 windows authentication throwing invalid user error in java

 
sam mat
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic