Installing SQL 2014 on Windows Server 2012 R2 ( i need Server collation to SQL_Latin1_General_CP1_CI_AS) but is missing.

Installing SQL 2014 on Windows Server 2012 R2 ( i need Server collation to SQL_Latin1_General_CP1_CI_AS) but is missing.
How can I select SQL_Latin1_General_CP1_CI_AS at install screen
Collation-Missing.jpg
LioElectronicAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Megan BrooksConnect With a Mentor SQL Server ConsultantCommented:
The SQL_xxx collations are "SQL collations" as opposed to "Windows collations." In your screen shot you have the "Windows collation" radio button selected. Switch to "SQL collation and search for SQL_Latin1_General_CP1_CI_AS in the list.
1
 
LioElectronicAuthor Commented:
You mean select the "second option SQL collation used for backwards "
Then the problem is I need to install Analysis services engine for analysis services also I need to use this collation SQL_Latin1_General_CP1_CI_AS.How can I select for analysis service ?
0
 
Megan BrooksSQL Server ConsultantCommented:
I am going from memory from several years back for SSAS (and installing for SQL Server 2012 at that), but as I recall when you reach the SSAS configuration section there is a "Collation" tab that you can select before advancing to the next section (you can go back, if necessary, to reach it again). The tab doesn't stand out and is easy to miss, but it is somewhere in the installer sequence, and it is separate from the collation selection for the database engine.

I may be able to locate an old set of installation notes that contains the details, if the above is not enough to go on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.