3

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).

  • 2
    Something a bit odd is happening here. You say you're using SQL Server 2008 R2. That's version 10, I think. Version 7 is the version prior to SQL Server 2000. What version have you got? Can you post the complete error message? – simon at rcl Jan 24 '14 at 9:29
  • 1
    As suprising as it might be, but I think I found a duplicate: stackoverflow.com/questions/11635539/… – Edward Dortland Jan 24 '14 at 13:09
4

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy