Error when creating new database user

When I try to create a new database user (on any database) I get this error
message: Cannot resolve
collation conflict for equal to operation.
I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
database has another collation: Danish_Norwegian_CI_AI and the tempdb
database. I don't know why the tempdb has this collation, and if that is the
problem?
I'd start checking the collation for below databases:
master
model
tempdb
msdb
If they aren't the same, you have a problem. It isn't supported to have different collations for the
system databases. Somebody made a "hack" to get you there. You would need to sort it out. Suitable
actions depend on what collation each system database has.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
> When I try to create a new database user (on any database) I get this error
> message: Cannot resolve
> collation conflict for equal to operation.
> I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
> database has another collation: Danish_Norwegian_CI_AI and the tempdb
> database. I don't know why the tempdb has this collation, and if that is the
> problem?
|||The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_AI
It is not possible to change collation in tempdb with alter
database...because it is a system database. What can I do?
"Tibor Karaszi" wrote:

> I'd start checking the collation for below databases:
> master
> model
> tempdb
> msdb
> If they aren't the same, you have a problem. It isn't supported to have different collations for the
> system databases. Somebody made a "hack" to get you there. You would need to sort it out. Suitable
> actions depend on what collation each system database has.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "blaairis" <blaairis@.discussions.microsoft.com> wrote in message
> news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
>
|||Probably somebody moved files for the model database from another installation. Tempdb is created
based on model on each startup. Hunt down database files from an installation that matches system
and msdb for your model database. You can try to just stop SQL Server and replace the files (backup
first, and save a copy of original model database files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...[vbcol=seagreen]
> The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_AI
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
|||Also, you could try bringing up the instance in master recovery only and
then attempt to modify the collation using the ALTER DATABASE command.
-T3608
ALTER DATABASE model
COLLATE <collation name>
This may only be a pseudo fix, if it works at all. You will probably need
to do as Tibor suggest, but it is worth a shot if you have trouble finding
such a database.
Another way to acquire a model database with the collation you want would be
to install SQL Server Developer Edition on your workstation and specifying
the collation of the system databases during the installation. You would
then need to patch you workstation installation to the same level as your
production database before you tried to copy the files from your workstation
to the server.
Hope this helps.
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%239R%23RH3ZFHA.1040@.TK2MSFTNGP10.phx.gbl...
Probably somebody moved files for the model database from another
installation. Tempdb is created
based on model on each startup. Hunt down database files from an
installation that matches system
and msdb for your model database. You can try to just stop SQL Server and
replace the files (backup
first, and save a copy of original model database files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...
> The master and msdb is ok, but tempdb and model have
Danish_Norwegian_CI_AI[vbcol=seagreen]
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
different collations for[vbcol=seagreen]
to sort it out.[vbcol=seagreen]
error[vbcol=seagreen]
is the[vbcol=seagreen]

Error when creating new database user

When I try to create a new database user (on any database) I get this error
message: Cannot resolve
collation conflict for equal to operation.
I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
database has another collation: Danish_Norwegian_CI_AI and the tempdb
database. I don't know why the tempdb has this collation, and if that is the
problem?I'd start checking the collation for below databases:
master
model
tempdb
msdb
If they aren't the same, you have a problem. It isn't supported to have diff
erent collations for the
system databases. Somebody made a "hack" to get you there. You would need to
sort it out. Suitable
actions depend on what collation each system database has.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
> When I try to create a new database user (on any database) I get this erro
r
> message: Cannot resolve
> collation conflict for equal to operation.
> I Use SQL_Danish_Pref_CP1_CI_AS as the default collation. Only one user
> database has another collation: Danish_Norwegian_CI_AI and the tempdb
> database. I don't know why the tempdb has this collation, and if that is t
he
> problem?|||The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_AI
It is not possible to change collation in tempdb with alter
database...because it is a system database. What can I do?
"Tibor Karaszi" wrote:

> I'd start checking the collation for below databases:
> master
> model
> tempdb
> msdb
> If they aren't the same, you have a problem. It isn't supported to have di
fferent collations for the
> system databases. Somebody made a "hack" to get you there. You would need
to sort it out. Suitable
> actions depend on what collation each system database has.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "blaairis" <blaairis@.discussions.microsoft.com> wrote in message
> news:EC58D0F5-4199-4353-8576-81B6F6BAF41F@.microsoft.com...
>|||Probably somebody moved files for the model database from another installati
on. Tempdb is created
based on model on each startup. Hunt down database files from an installatio
n that matches system
and msdb for your model database. You can try to just stop SQL Server and re
place the files (backup
first, and save a copy of original model database files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...[vbcol=seagreen]
> The master and msdb is ok, but tempdb and model have Danish_Norwegian_CI_A
I
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
>|||Also, you could try bringing up the instance in master recovery only and
then attempt to modify the collation using the ALTER DATABASE command.
-T3608
ALTER DATABASE model
COLLATE <collation name>
This may only be a pseudo fix, if it works at all. You will probably need
to do as Tibor suggest, but it is worth a shot if you have trouble finding
such a database.
Another way to acquire a model database with the collation you want would be
to install SQL Server Developer Edition on your workstation and specifying
the collation of the system databases during the installation. You would
then need to patch you workstation installation to the same level as your
production database before you tried to copy the files from your workstation
to the server.
Hope this helps.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%239R%23RH3ZFHA.1040@.TK2MSFTNGP10.phx.gbl...
Probably somebody moved files for the model database from another
installation. Tempdb is created
based on model on each startup. Hunt down database files from an
installation that matches system
and msdb for your model database. You can try to just stop SQL Server and
replace the files (backup
first, and save a copy of original model database files).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"blaairis" <blaairis@.discussions.microsoft.com> wrote in message
news:2155EF0D-3115-4B69-854B-1DD0C7A02EDC@.microsoft.com...
> The master and msdb is ok, but tempdb and model have
Danish_Norwegian_CI_AI[vbcol=seagreen]
> It is not possible to change collation in tempdb with alter
> database...because it is a system database. What can I do?
> "Tibor Karaszi" wrote:
>
different collations for[vbcol=seagreen]
to sort it out.[vbcol=seagreen]
error[vbcol=seagreen]
is the[vbcol=seagreen]