Skip to content

Wrong Collation on a used SQL Server

Featured Replies

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

 

 

Your SCCM DB is hosted on a named instance on the SQL Server?

  • Author

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.

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...

  • Author

my hope was in an other advice :D 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?

I think so. A new SQL Server or a new instance on an existing SQL Server...

my hope was in an other advice :D 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.

  • Author

Thank you very much for your quick Help ;-)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.