Search

Setup fails to change server collation by DNETFX

Active

1
0
Sign in
 to vote
Type: Bug
ID: 774123
Opened: 12/12/2012 6:44:22 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
I am trying to change my SQL Server's collation using the instructions from this MSDN article:

http://msdn.microsoft.com/en-us/library/ms179254(v=sql.110).aspx

On SQL Server 2008 R2 Express the process works (collation is changed), however, on SQL Server 2012 SP1 Express the process does not work (collation stays the same).
Details (expand)

Product Language

English

Version

SQL Server 2012 - Express Edition

Category

Setup

Operating System

Windows 7 Enterprise (SP1)

Operating System Language

English

Steps to Reproduce

Install SQL Server 2012 SP1 Express + Management Studio, use default instance name.
Choose Hebrew_CI_AS as the Server Collation.

Restart.

Stop all SQL services.

Open command line.

Change directory to:
c:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

Run:
setup /quiet /action=REBUILDDATABASE /instancename=MSSQLSERVER /SQLCOLLATION=Latin1_General_100_CI_AS_KS_WS /sqlsysadminaccounts=administrators

Start SQL services.

Open SQL Management studio and connect to server ".".

Check collation in properties.

Actual Results

Collation is Hebrew_CI_AS

Expected Results

Collation is Latin1_General_100_CI_AS_KS_WS

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement