User rights on moving database

Hi

I recently moved SQL database from server1 to server2 using detach/attach
database files.
I made the following steps:

1. Install SQL Server 2005 on server2
2. Create login "Asig" (user with limited rights for conecting to
application)
3. Detach files (database and transaction log) on server1
4. Copy files to server2
5. Attach files on server2

After this steps I can login with Asig user in SQL Server Management Studio,
but I can't acces the database. The message is "The database X is not
accesible"

Please tell me what should I do to solve this problem.

Thanks.

Nick



__________ Information from ESET NOD32 Antivirus, version of virus signature database 5400 (20100826) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




.

Relevant Pages

  • Re: Error on database restore using Enterprise Manager
    ... "goodofficesnew" on Server2 with the following file locations: ... I have been using the backup file generated by "goodofficesnew" from Server2 ... to restore latest database to "NewArchitecture" on Server1 without problem. ... RESTORE DATABASE is terminating abnormally. ...
    (microsoft.public.sqlserver.programming)
  • Security is invalid when restoring a DB to another Server
    ... I made a backup of a database (DB1) from Server1. ... I created a DB on Server2 with the name "DB1", then did a restore from the ... I created a Security Login on Server2 with the same name as what is expected ...
    (microsoft.public.sqlserver.security)
  • Re: Slow database update question
    ... The database has a few clients and each clients can request many data ... Select sequencenumber, openprice,highprice,lowprice,closeprice,volume ... Many users connects to Server2 to retrieve data from the database. ...
    (microsoft.public.sqlserver.programming)
  • push replication failing - firewall
    ... local admin user and made the SQL Server agent run with it. ... sa and gave it database owner on the replication database. ... I am able to register server2's sql server in EM, although I had to up the ... Server2 has a hosts file with the ip address of server1, ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_attach_db (encounted problems after having Oracle installed)...
    ... the SQL Server Backup command before you do anything. ... to a New Location with Detach/Attach ... Issues When a Database Is Moved Between SQL Servers ... > I installed Oracle on my server a week ago, ...
    (microsoft.public.sqlserver.connect)