question

According to the message in picture "test.png", you are attempting to restore a database backup made on SQL Server 2008 R2 SP2 (v10.50.4000) to a server running SQL Server 2008 SP1 (v10.00.2531). This can't be done - you can't restore a database backup from one version of SQL Server to a server running an earlier version. For SQL Server release / build information, see the [SQL Server Builds blog][1]. According to picture test2.png, this is showing you running an instance of SQL Server Management Studio, a client application, that was released with the original release (or RTM) version of SQL Server 2008 R2 (v10.50.1600). That SSMS dialog box does *not* show the version of SQL Server running on your server. The item you highlighted in the SSMS Object Explorer is the version of SQL running on that particular server. [1]: http://sqlserverbuilds.blogspot.co.uk

There could be missing database username in db_users table or deprecated symbols in username or may be something else.