2 this to check.. if the database and all its objects like tables & stored procedures were restored correctly and if they restored your database users & permissions too.
Check your database user in your connection string.
User or password issues would result in a different error about connection. How do i verify the stored procedures required using SQL Server Management Studio?
I am connected and attempting to diagnose, but what should I be seeing?