Sql-server – Cannot read property Collation.This property is not available on SQL Server 7.0

You are connected to a SQL Server 2008 instance. The error message clearly indicates that. See How to determine the version and edition of SQL Server and its components, the section on SQL Server Database Engine version lists no less than 4 methods:

• Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.
• Method 2: Look at the first few lines of the Errorlog file for that instance.

• Method 3: Connect to the instance of SQL Server, and then run the following query:

  Select @@version;

• Method 4: Connect to the instance of SQL Server, and then run the following query:

  SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition');

Unless you're referring to contained databases (which are new in SQL Server 2012), you can't use the second approach. Whenever a person authenticates to SQL Server, they are authenticating against a particular server login (or possibly multiple logins if you're creating logins for domain groups). This server login can then be mapped to one or more database users to allow access to different databases.

Unless you're doing some tricks with EXECUTE AS or using application roles, there's no way for somebody to authenticate directly as a database user without a server login being mapped to it.