Restore SQL server, Login failure

I restored a DB to another server and then i used the stored procedures

exec sp_addlogin on the master DB and the exec sp_change_users_login on the DB that I have restored. When i try to run a sproc I am getting

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I have used windows authentication to login to connect to the server using sql management studio

Am i missing something. Thankyou for the help

How do you call the stored procedure and what does the stored procedure do?

Thanks
Laurentiu

Restore objects from backup.

Hi experts,

Is there any way to restore the table structure or stored procedures alone from a database backup ?

Thanks & Regards,

DBLearner

There are no direct ways to that. Anyway, you could restore database with another name on the server and copy whatever you want from it.
|||When restoring a SQL Server backup you have to restore all the data. After restoring you can trucnate the tables which will give you the schema and procedures only.|||

No there is no way to restore a table structure from a database backup without restoring the entire database.

regarDs,

Jacx