Wednesday, March 28, 2012

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
>

No comments:

Post a Comment