ravinutalasblog

When I was trying to configure TIBCO BW ADB Adapter with SQL server 2012 as the back end database, I got a some issues which am going to post in a series of blog posts. Here I am going to post the steps to configure them as well. First the user should be created to access the DB from TIBCO BW. Administrator users like 'sa' should not be used. If the administration users are used in the configuration then the ADB adapter may not start properly.  To create the user following are the steps: - In 'Microsoft SQL Server Management Studio' go to the   databases -> <your database> -> Security -> Users -> New User  - It opens a pop-up - In the pop-up on the General tab select the User Type as 'SQL user with login' - Give the User name and Login name and then select the Default schema as dbo. - On the Membership tab select the Role Members as db_owner - Then click on OK to complete

When we run the adapter tester in TIBCO BW, we may get the following error: java.io.IOException: Cannot run program "C:\tibco\adapter\adadb\6.3\bin\adbagent.exe" (in directory "C:\tibco\designer\5.8\workingDirAdapter"): CreateProcess error=740, The requested operation requires elevation at java.lang.ProcessBuilder.start(Unknown Source) at java.lang.Runtime.exec(Unknown Source) at com.tibco.ae.tools.adaptertester.AdapterProcess.run(AdapterProcess.java:606) -- and few more lines -------------- To resolve this, we may need to start the TIBCO BW engine as administrator using ' Run as Administrator '

Whenever we want to print only the pop-up in windows just use Alt+Print Scrn together.