limit of number of columns

I have a table of 6MB with 50 values in the pivot-values leading to 50 columns in the pivoted table. That one works nicely.

I have another much larger table with 170MB and 121 columns. When creating the pivoted table I get an error:

SQL Fehler (1939): Engine CONNECT failed to discover table `abc`.`def` with 'CREATE TABLE whatever ...

The server runs on Win7 64Bit version 10.0.13

How can I create the pivoted table of the large table?