PI JDBC adapter - Connecting to SQL Server 2005 using NT Domain account

[former_member670219]

Dear experts,

Is it possible to connect to a SQL Server 2005 database using the JDBC sender adapter by using a domain user name and password?

The data base team has provided me the domain, username and password.

We have installed the JDBC drivers from Microsoft in PI 7.1. and added the property integratedSecurity=true; to the connection string in the channel configuration.

But where do you specify the domain account? Or is it even possible to do it this way?

Thank you.

[stefan_grube]

> The data base team has provided me the domain, username and password.

Technical users usually are not part of a domain. Ask basis team to provide user without domain for PI access.

[madhusudana_reddy2]

Dear Param,

use below pattern while connecting to your sql db

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://IPaddress or Hostname;DatabaseName=Yordbname

you ignore all remainings,

thanks,

madhu

[Former Member]

Hi Param,

In the communication channel configuration have you given the database connection parameters as

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://host:1433;DatabaseName=name

User Name:

Password:

Please have a look at this [blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14635] [original link is broken] [original link is broken] [original link is broken]; at some point it may help.

Regards,

Srinivas