Help for SQL 2000 connection!

Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to
use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up a
error msg:
connection failed
SQL state '28000'
SQL server Error: 18452
Login fail for user 'XXX', reason : Not associated with a trusted SQL server
connection.
Can you tell mm how should I do to fix this problem'
Thanks!
DannyYou may be able to resolve your problem through one of the workarounds
provided in this KB article: http://support.microsoft.com/kb/889615/en-us
Nathan H. Omukwenyi
"Danny" <dannyf@.deny.com> wrote in message
news:uOo%23XR3fGHA.1320@.TK2MSFTNGP04.phx.gbl...
> Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to
> use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up
> a
> error msg:
> connection failed
> SQL state '28000'
> SQL server Error: 18452
> Login fail for user 'XXX', reason : Not associated with a trusted SQL
> server
> connection.
> Can you tell mm how should I do to fix this problem'
> Thanks!
> Danny
>|||It's helpful!
Thanks much!
Danny
"Nathan H. Omukwenyi" <nathan@.e-tools.com> wrote in message
news:OwA4S$4fGHA.3996@.TK2MSFTNGP03.phx.gbl...
> You may be able to resolve your problem through one of the workarounds
> provided in this KB article: http://support.microsoft.com/kb/889615/en-us
> Nathan H. Omukwenyi
> "Danny" <dannyf@.deny.com> wrote in message
> news:uOo%23XR3fGHA.1320@.TK2MSFTNGP04.phx.gbl...
>

Help for setting up SQL 2000!

I got sbs 2003 server with sql 2000, and using backup data function to move
the database to another 2k server w/sql2k, after I restore on the 2k server,
I from workstation try to login by using that data, but there is no account
appear on the screen.
What is wrong with it or I did something wrong in SQL setting?
Thanks!
Danny
The new server may not have the login accounts.
See these articles for more information:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/colu...rdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872 Resolve Permission
Issues -Database Is Moved Between SQL Servers
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Danny" <dannyf@.deny.com> wrote in message
news:%23%23TSFV49GHA.4464@.TK2MSFTNGP02.phx.gbl...
>I got sbs 2003 server with sql 2000, and using backup data function to move
>the database to another 2k server w/sql2k, after I restore on the 2k
>server, I from workstation try to login by using that data, but there is no
>account appear on the screen.
> What is wrong with it or I did something wrong in SQL setting?
> Thanks!
> Danny
>

Help for setting up SQL 2000!

I got sbs 2003 server with sql 2000, and using backup data function to move
the database to another 2k server w/sql2k, after I restore on the 2k server,
I from workstation try to login by using that data, but there is no account
appear on the screen.
What is wrong with it or I did something wrong in SQL setting'
Thanks!
DannyThe new server may not have the login accounts.
See these articles for more information:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases to a
New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/col...se
s.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872 Resolve Permission
Issues -Database Is Moved Between SQL Servers
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Danny" <dannyf@.deny.com> wrote in message
news:%23%23TSFV49GHA.4464@.TK2MSFTNGP02.phx.gbl...
>I got sbs 2003 server with sql 2000, and using backup data function to move
>the database to another 2k server w/sql2k, after I restore on the 2k
>server, I from workstation try to login by using that data, but there is no
>account appear on the screen.
> What is wrong with it or I did something wrong in SQL setting'
> Thanks!
> Danny
>