4

I'm not able to add administrator role in SQL Server 2008 R2.

When I try to add new user it throws me the following error:

Cannot read property Collation.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo).

Colin 't Hart
  • 9,455
  • 15
  • 36
  • 44

1 Answers1

5

I ran into this today. I tried to connect to a SQL Server 2014 instance while using SQL Server Management Studio 2008 R2. This is exactly the same error I got:

Cannot read property Collation.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo).

Installing SSMS 2014 did the trick; I can connect and add users fine.

ashes999
  • 153
  • 1
  • 5