Skip to main content
Planview Customer Success Center

Issue with login to the System Manager v2012

Symptoms

When trying to login to system manager, the following message appears:

Error/warning messages
"Ambiguous column name: Feature code"
 

Reason

Configuration, incorrect SQL compatibility level set on the database.
It was set to 80 -SQL Server 2000.


 

Resolution

Changed the value from 80-SQL Server 2000 to 100- SQL Server 2008 and SQL Server 2008 R2.

To view or change the compatibility level of a database using SQL Server Management Studio

1. After connecting to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name.
2. Expand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database.
3. Right-click the database, and then click Properties.

The Database Properties dialog box opens.
4. In the Select a page pane, click Options.
The current compatibility level is displayed in the Compatibility level list box.
5. To change the compatibility level, select a different option from the list.

The choices are SQL Server 2008 (100), SQL Server 2012 (110), or SQL Server 2014 (120).