Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 16, 2010 at 02:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2010 at 06:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2010 at 07:01 AM

    > 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.

    Add comment
    10|10000 characters needed characters exceeded