title: informatica powercenter sql server connection issue
body: <p>Background: I am really new. Informatica Developer for PowerCenter Express Version: 9.6.1 HotFix 2</p>
  
  <p>I am trying to connect to a sql server 2012 database. I created this connection 
  , basically just changed the server, database in connection string of meatadata access and data access. I have tested I can use the user name password to access the sql server in sql server management studio. And when I click test it reports successful.
  <a href="https://i.stack.imgur.com/EDTu7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EDTu7.png" alt="enter image description here"></a></p>
  
  <p>But when I create a mapping and a physical object (read) based on that connection, when I try data view on that object, it reports this error:</p>
  
  <pre><code>    [LDTMCMN_0029] message [com.informatica.sdk.dtm.ExecutionException: [LDTM_0072] RR_4036 Error connecting to database [
      Microsoft SQL Server Native Client 11.0:    Login timeout expired
      SQL State: HYT00    Native Error: 0
  
      Microsoft SQL Server Native Client 11.0:    A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
      SQL State: 08001    Native Error: 87
  
      Microsoft SQL Server Native Client 11.0:    SQL Server Network Interfaces: Connection string is not valid [87]. 
      SQL State: 08001    Native Error: 87
      State: 1    Severity: 16
      SQL Server Message: SQL Server Network Interfaces: Connection string is not valid [87]. 
  
  
      Database driver error...
      Function Name : Connect
      Database Error: Failed to connect to database using user [bcsgetl] and connection string [192.168.100.88:1433].].]
  </code></pre>
  
  <p>One thing to note, when I created that physical object, I used that connection and I was able to select a table, which proves the connection is successful. </p>