db restore doesn't work

[mbs611]

I restored a SQL db to another server (not the server where backup was performed).

Now my application fails to connect to target server since 2 SQL accounts that application looks for have inappropriate permissions after the restore.

How can I reinstate SQL users and roles on the restored db? I am only using SQL authenticated accounts.

 

[Jamfool]

Easiest way would be to open enterprise manager.

Right Click your db.
All tasks
Generate SQL Script
Select Options tab and click in 'Script SQL Server Logins(Windows and SQL Server logins'


you can then either ok that to create a sql file which you can run on your other db,
or you could click general tab and use preview button to show you the script so you can copy it.

 

[yelworcm]

Look up sp_change_users_login in BOL.