I have backuped sql database from my server and tried restore on my machine. Restoring window disappeared by saying successfully restored. In the database list my database is not accessible.
This is how it looks like. When I try to access it gives this window. username/passwords were different on each machine. From googling I found from microsoft msdn: sp_change_users_login (Transact-SQL) What I tried is:
USE myDatabase; GO EXEC sp_change_users_login 'Auto_Fix', 'user', NULL, '12'; GO
In the messages panel:
Msg 927, Level 14, State 2, Line 2
Database 'myDatabase' cannot be opened. It is in the middle of a restore.
The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.
How can I fix it? UPDATE I restored the database on another machine it worked properly.