LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Brad Brezinski

We have recentely installed SQL Server drivers and we are tyring to connect to a SQL DB that only accepts window authentication. Is there a way to use windows authentication with Lavastorm BRE? Thanks in advance. Brad

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Brad are you using BRE Client or Enterprise?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Brad Brezinski

Hi, we are using enterprise. Thanks

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: xathras

Brad I am assuming your Enterprise is not running with the new windows support correct?

Ordinarly you would pass in the following example JDBC connection string. The URL is http://technet.microsoft.com/en-us/l...=sql.110).aspx
jdbc:sqlserver://localhost;user=username;password=*****;

If you're running on Enterprise from a windows server you could you pass in the following:
jdbc:sqlserver://localhost;databaseName=dbname;integratedSecurity=t rue

If not I don't believe it will work as a trusted connection. You would need an SQL server account. the below link will help: http://msdn.microsoft.com/en-us/library/aa337562.aspx


Wayne

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sudarshan

Could you please let me know the best possible way to connect SQL server with windows authentication.
Many Thanks.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: prasmussen

Updating forum post with a resolution. To use windows authentication with SQL server, it is possible using the method above using authenticatedSecurity=true which passes in the credentials of the account that starts the LAE service, or you can pass in domain credentials using the JDBC driver JTDS. The JTDS driver will authenticate the username/pwd on the domain and pass the authentication to SQL Server.
DbURL=jdbc:jtds:sqlserver://localhost;databaseName=yourDBName;instance=yourIns tance;domain=yourDomainName;useNTLMv2=true
Driver=net.sourceforge.jtds.jdbc.Driver
Driver Name=jtds-1.3.1.jar
Driver Website=http://jtds.sourceforge.net/faq.html