Re: Error 18456, State 28000

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@xxxxxxxxxxxxx> wrote in message
news:u1nxZaSUGHA.4952@xxxxxxxxxxxxxxxxxxxxxxx
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.




.

Relevant Pages

  • push replication failing - firewall
    ... local admin user and made the SQL Server agent run with it. ... sa and gave it database owner on the replication database. ... I am able to register server2's sql server in EM, although I had to up the ... Server2 has a hosts file with the ip address of server1, ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem With Replication On Port 2433
    ... Is the distribution agent using the alias you configured for server2 in its ... Looking for a SQL Server replication book? ... why- I cannot switch it to port 1433. ... Connections through a server alias, ...
    (microsoft.public.sqlserver.replication)
  • Re: tcp/ip vs named pipes
    ... I have never had contact with sql server before. ... I can ping, but can't telnet on port 1433. ... test is can it ping Server2 by name. ...
    (microsoft.public.sqlserver.clients)
  • Re: How update publisher db in case it fails ???
    ... TNX, Paul, i have something strange, while i configured replication from ... server1 to server2, i server2 all key were dissapeared, why it's happen. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Error 18456, State 28000
    ... Running SQL Server 2000... ... On server2, i have the exact same group set up... ... users in this group doesn't get recognized by my new sql installation. ... get the error above (SQL Error 18456, ...
    (microsoft.public.sqlserver.security)