debugMinor
Cannot read property Collation.This property is not available on SQL Server 7.0
Viewed 0 times
cannotthisavailablereadsqlpropertycollationservernot
Problem
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).
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).
Solution
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.
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.
Context
StackExchange Database Administrators Q#57466, answer score: 5
Revisions (0)
No revisions yet.