That is a security error. My guess is something had issues when you restored.

That script doesn't restore, so I'm not sure what you did there. That gets meta data for the backup file. If you've restored it and things look OK in SSMS, try adding a new login and user and seeing if that lets you connect.