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
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
 
Similar Threads
Expected to be challenged at this url, but was not
LDAP authentication in a web application.
Trouble Connectiing
how to display errors in servlet
JNDI Properties for Oracle 10g AS(904)