Server alias with SQLOLEDB.1 provider?

• Jason Coleman

  SSC Enthusiast

  Points: 175

  More actions

  January 28, 2016 at 8:25 am

  #308100

  I'm can't see how it would, but will a server alias affect a connection being made with the SQLOLEDB.1 provider?

  Edit:

  So I just found some other info which might hint at my issue. In a connection string, if the provider is SQLOLEDB.1 and the data source is just specified as a server name(but not an FQDN, assuming you even can), will the default network library used be named pipes?

  Thank you

• Jason Coleman

  SSC Enthusiast

  Points: 175

  More actions

  January 28, 2016 at 10:00 am

  #1855014

  Nevermind! I found a typo in my alias target name. Works much better when the name is right. :pinch: