Wednesday, March 7, 2012

Error with Logins into SQL 2K

Hello,
I need some advice...
I am 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') when they try and
login. (Access, VB progs, etc)...
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...
Server1 is the Domain Controller...running sbs2000 (windows 2000 server).
Server2 is just windows 2003, and is dedicated to sql server 2000...
Does anyone have any suggestions on how to proceed with this?
Thanks.Hi
In my opinion the real problem seems to be with an ODBC connection
Does itt succeeds with NT authentication if and only if the user is an
administrator ?
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:%23b1DfodUGHA.1688@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I need some advice...
> I am 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') when they try and
> login. (Access, VB progs, etc)...
> 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...
> Server1 is the Domain Controller...running sbs2000 (windows 2000 server).
> Server2 is just windows 2003, and is dedicated to sql server 2000...
> Does anyone have any suggestions on how to proceed with this?
> Thanks.
>
>|||This would help.
http://support.microsoft.com/kb/298897
-oj
"RL Tech" <tech_support@.nospamuls.com> wrote in message
news:%23b1DfodUGHA.1688@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I need some advice...
> I am 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') when they try and
> login. (Access, VB progs, etc)...
> 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...
> Server1 is the Domain Controller...running sbs2000 (windows 2000 server).
> Server2 is just windows 2003, and is dedicated to sql server 2000...
> Does anyone have any suggestions on how to proceed with this?
> Thanks.
>
>|||On server1, NT (windows) authentication works with the group SQLGroup
(whether they are admin or not)... as long as they are part of SQLGroup,
they will be fine.
On server2, NT (windows) authentication only works with Admin users (thus by
adding all the users in SQLGroup to Domain Admins, they would work)... Which
i obviously don't want to do.
Both are mixed mode authentication...
ODBC has worked from the moment i set up that connection with that group...
In fact, it still works fine when i authenticate non-windows usernames...
Do i need to make server2 a Domain controller?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eeAlh4jUGHA.5884@.TK2MSFTNGP14.phx.gbl...
> Hi
> In my opinion the real problem seems to be with an ODBC connection
>
> Does itt succeeds with NT authentication if and only if the user is an
> administrator ?
>
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:%23b1DfodUGHA.1688@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
I[vbcol=seagreen]
server).[vbcol=seagreen]
>|||Hi,
I did look at it yesterday, but i wasn't sure if that was the problem...
I'll give it a try and see if it works out..
Thanks!
...Robin
"oj" <nospam_ojngo@.home.com> wrote in message
news:u1vHDDlUGHA.5004@.TK2MSFTNGP11.phx.gbl...
> This would help.
> http://support.microsoft.com/kb/298897
>
> --
> -oj
>
> "RL Tech" <tech_support@.nospamuls.com> wrote in message
> news:%23b1DfodUGHA.1688@.TK2MSFTNGP11.phx.gbl...
a[vbcol=seagreen]
I[vbcol=seagreen]
server).[vbcol=seagreen]
>

No comments:

Post a Comment