Restore SQL Server 2008 db without affecting users

Since this is a Windows 2008 server, most likely, the User Access Control is causing the issue.

When you want to connect the instance, right click on SSMS and Run as Administrator. And give the above name pipe, you should be able to get in.

If your goal here is to recreate the the logins with the same password then you are SOL, this is only stored in the tables/views in the master database. Brian's recommendation will work if the old instance is still around but if not then you will need to do one of the options below.

• Recreate the logins
• Use sp_change_users_login to map the database user to the new login

or

• Create new logins
• Assign rights to that login in the restored database

Note that this is only the case with SQL logins, if you are using Active Directory logins then all you need to do is add them back to the server and they will automatically have rights in the restored databases because the password and SID are stored in AD and not in the master database for the instance.