SQL 7.0 database restore

We have SQL7 installed on an NT4 Server. We have 3 databases all set up the same but with 3 different names.

We have carried out a restore from one database and restored over another database from a backup device (dump file). The backup operation was successful, ie. the databases were the same size.

The problem now is that we are unable to connect to the restored database. What do I need to change so that I can connect to the restored database – (note, we can connect to the other two databases without any problem).

NB We are Rookie users! So any feedback would be greatly appreciated!

NOS: NT4 SERVER
DB Software: SQL SERVER7

Regards

IT GURU