Re: New User causes 'Cannot resolve collation conflict error'

From: Mark Walsh (MarkWalsh_at_discussions.microsoft.com)
Date: 12/09/04 

Date: Wed, 8 Dec 2004 19:05:01 -0800

I have used build 8.00.818. I've just looked on the MS site, and this is
still listed as the latest build available for MS03-031. I can't find
8.00.819 that you mention below. Where can I get this from? Also, where can
I get the .878 builds you mention? A search on MS site didn't turn it up
either.

"AnthonyThomas" wrote:

> Make sure you are not using the original MS03-031 hot fix build 8.00.817; it had issues with the DTSGUI.dll and then the fix for this, build 8.00.818, had issues with SQLEM logins. The latest fix for these issues is build 8.00.819.
>
> Also, there have been a few other post SP3(a) hot fixes. The latest public available one is build 8.00.878.
>
> Sincerely,
>
>
> Anthony Thomas
>
>
> --
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in message news:urGgk340EHA.2540@TK2MSFTNGP09.phx.gbl...
> I would also check whether the system databases has different collations (not supported).
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "Mike Hodgson" <mwh_junk@hotmail.com> wrote in message news:uzzHSQ10EHA.208@TK2MSFTNGP12.phx.gbl...
> > Is this just through the GUI (SQLEM) or does it happen when you use
> > sp_addlogin as well? Is it when you're adding a user to a DB (master DB in
> > this case) or when you're adding a new login to the server?
> >
> > "Mark Walsh" <MarkWalsh@discussions.microsoft.com> wrote in message
> > news:C4F77B74-9006-4D54-95A7-6FE3E1FEB961@microsoft.com...
> > > When I try to add a new user to the Master database, I get the error:
> > >
> > > Error 446: Cannot resolve collation conflict for equal to operation.
> > >
> > > The server has been running for months, and I've added new users before
> > > without any problems. Since last adding users, I have installed the Post
> > > SP3
> > > Security updates package and this is the first time since then I have
> > > tried
> > > to add a new user.
> > >
> > > Everything else is working fine and has been for months. And I havn't
> > > changed the collation for the server or the databases since it was
> > > installed
> > > over 12 months ago.
> > >
> > > Any suggestions?
> > >
> > >
> >
> >
>
>

Relevant Pages