1
  • SSAS 2014 cube accessing SQL Server 2016 database

    We are trying to process a cube on SSAS 2014 by connecting to SQL Server 2016 database(both are set up on different machines). Though the connection is successful, the process fails saying - "OLE DB or ODBC error". We are using SQL Server Native client provider for the connection string. As per...

    SreejaRadhakrishnan5 pointsBadges:
  • No remote connection on SQL Server 2016

    I just installed SQL Server 2016 on Windows Server 2016 Core. On the local side, it's working. But on the remote side, I'm not able to connect. Here's what I'm getting as an error message: sqlcmd -S boldiq_db3 Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Named Pipes Provider: Could not...

    ITKE1,005,485 pointsBadges:
  • MS SQL Server 2016 backup encryption

    SQL Server 2016 uses AES-256 symmetric encryption algorithm for backups. However, it uses an asymmetric key in conjunction with AES-256. As we know, asymmetric keys are not designed for large data encryption. Does the system, under the hood, generates a sort of symmetric session key and encrypts...

    radudba20165 pointsBadges:
  • How to migrate DTS packages to SQL Server 2016

    I'm looking to migrate several DTS packages over to SQL Server 2016. How can I go about this process? Is my best bet to migrate them over to SSIS first, and then to 2016?

    ITKE1,005,485 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following