leusa Posted October 7, 2013 Report post Posted October 7, 2013 Hello everybody I'm bussy installing sccm 2012 Configuration Manager in our enviroment. Now i got the following Problem: we are using an SQL Server 2012 with the default Collation and some DBs on it. new the SCCM 2012 DB should be on this SQL Server. But unfortunately this DB needs an other Collation. Is it not possible to change the Collation only on the SCCM DB? I Really dont want to run a new SQL Server to use SCCM. Someone solved this problem allready? many thanks for your help Quote Share this post Link to post Share on other sites More sharing options...
Bendes Posted October 7, 2013 Report post Posted October 7, 2013 Your SCCM DB is hosted on a named instance on the SQL Server? Quote Share this post Link to post Share on other sites More sharing options...
leusa Posted October 7, 2013 Report post Posted October 7, 2013 Not yet... i tryed to install the SCCM Server to create a DB. but it Failed. And i tryed to create a DB manualy and set the right Collation and started after the installation. but it dosn't worked. Quote Share this post Link to post Share on other sites More sharing options...
Bendes Posted October 7, 2013 Report post Posted October 7, 2013 Maybe not the best advice but in your place I would add a new named instance to your SQL Server with the right Collation configured... Quote Share this post Link to post Share on other sites More sharing options...
leusa Posted October 7, 2013 Report post Posted October 7, 2013 my hope was in an other advice so it is definitly not possible to use an SQL with an other Collation? I just have the Option to get a new SQL Server with the right collation or a other named instance? Quote Share this post Link to post Share on other sites More sharing options...
Bendes Posted October 7, 2013 Report post Posted October 7, 2013 I think so. A new SQL Server or a new instance on an existing SQL Server... Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted October 7, 2013 Report post Posted October 7, 2013 my hope was in an other advice so it is definitly not possible to use an SQL with an other Collation? I just have the Option to get a new SQL Server with the right collation or a other named instance? It is not possible to run CM12 with any other collation and you want you temp db to be the same collation too. As an aside I NEVER recommend that SQL be remote from CM12. Quote Share this post Link to post Share on other sites More sharing options...
leusa Posted October 8, 2013 Report post Posted October 8, 2013 Thank you very much for your quick Help ;-) Quote Share this post Link to post Share on other sites More sharing options...
