Configuring Your Machine for Windows Authentication
This authentication is only supported on Microsoft Windows operating systems. In order for TIBCO BusinessEvents to support Windows authentication when accessing SQL Server database, follow these steps:
Procedure
Download and install the Microsoft JDBC 4 Driver distribution on the machines BusinessEvents runs on.
The distribution contains the
sqljdbc_auth.dll used by the client to support Windows authentication.
Edit the be-engine.tra file and update the
tibco.env.PATH
variable so that it points to the folder where
sqljdbc_auth.dll resides. For instance:
Replace the script in
<tibco_be_home>/bin/initialize_database_sqlserver.sql with the following script that creates a user associated to Windows login:
use master
go
drop database be_user
go
create database be_user
go
drop login [domain\user]
go
create login [domain\user] from windows with default_database = be_user
go
use be_user
create user [domain\user] for login [domain\user]
go
grant control, alter, connect to [domain\user]
go
alter role [db_owner] add member [domain\user]
go