File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql2008 windows authentication throwing invalid user error in java

 
sam mat
Greenhorn
Posts: 4
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic