Database Restore Security Issue

We are doing a restore of a SQL database to a stand alone test server. We
were able to restore the database successfully to SQL Server 2000 sp3a. We
restored the data into a database that has the same name as the production
database. We installed the application that will be accessing the database
also without issue.
The problem we are running into is with the security. When the application
tries to access the data it says the user does not have permission. It
appears that the restore pulled in the security data from the production
server and when I try to add a new user (from the test server) under security
and give them access to the database I get an error saying "Errir 15401:
Windows NT useror roup 'Test\Administrator' not found. Check the name
again." Even if I go into the database itsel and go to users and try to add
one there. Same error message. How do I allow users from the test
environment to access the database?
Thanks for your help.You need to link the existing user in the restored database to the login on
the server. Look up sp_change_users_login in BOL for details.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Ken Ostrowski" <KenOstrowski@.discussions.microsoft.com> wrote in message
news:BDBC45C6-1186-4D41-8057-9EAC21C42DE7@.microsoft.com...
> We are doing a restore of a SQL database to a stand alone test server. We
> were able to restore the database successfully to SQL Server 2000 sp3a.
> We
> restored the data into a database that has the same name as the production
> database. We installed the application that will be accessing the
> database
> also without issue.
> The problem we are running into is with the security. When the
> application
> tries to access the data it says the user does not have permission. It
> appears that the restore pulled in the security data from the production
> server and when I try to add a new user (from the test server) under
> security
> and give them access to the database I get an error saying "Errir 15401:
> Windows NT useror roup 'Test\Administrator' not found. Check the name
> again." Even if I go into the database itsel and go to users and try to
> add
> one there. Same error message. How do I allow users from the test
> environment to access the database?
> Thanks for your help.