Thursday, March 29, 2012

Error 18456, State 28000

Hello,
Running SQL Server 2000... I've installed a new instance of this on a new
server (to migrate from server1 to server2).
On server1, i have a group set up (domain/SQLGroup)...
On server2, i have the exact same group set up... unfortunately all the
users in this group doesn't get recognized by my new sql installation. I
get the error above (SQL Error 18456, State '28000')..
I can change permissions for all the users in this group to have "Domain
Admins", but obviously i don't want to do that... by doing this though, all
access works as before...
SP4 is installed on server2, but not on server1...
Does anyone have any suggestions on how to proceed with this?
Thanks.One thing i should add about this...
Server1 is the Domain Controller...running sbs2000 (windows 2000 server).
Server2 is just windows 2003, and is dedicated to sql server 2000...
Thanks,
...Robin
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:u1nxZaSUGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello,
> Running SQL Server 2000... I've installed a new instance of this on a new
> server (to migrate from server1 to server2).
> On server1, i have a group set up (domain/SQLGroup)...
> On server2, i have the exact same group set up... unfortunately all the
> users in this group doesn't get recognized by my new sql installation. I
> get the error above (SQL Error 18456, State '28000')..
> I can change permissions for all the users in this group to have "Domain
> Admins", but obviously i don't want to do that... by doing this though,
all
> access works as before...
> SP4 is installed on server2, but not on server1...
> Does anyone have any suggestions on how to proceed with this?
> Thanks.
>

No comments:

Post a Comment