sql2008 windows authentication throwing invalid user error in java

[sam mat]

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

jdbc:sqlserver://host:1433;databasename=LicenseManager;integratedSecurity=true;

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]

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 | [e-mail] | www.infocepts.com
---------------------------------------------------------------------------------------

[sam mat]

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