You may receive a Transact-SQL error message or an operational error message when you use SQL Server 2008 Management Studio to connect to an instance of SQL Server 2008

Symptoms

Consider the following scenario:
  • You use Microsoft SQL Server 2008 Management Studio to connect to an instance of SQL Server 2008.
  • The instance to which you connect was created in a prerelease version of SQL Server 2008.
  • The version of SQL Server 2008 Management Studio that you have installed is also a prerelease version.
  • The prerelease version of SQL Server that was used to create the instance differs from the prerelease version of SQL Server Management Studio.
In this scenario, you may receive a Transact-SQL error message or an operational error message.

Transact-SQL error messages may be generated because of missing functions, tables, or stored procedures or because of column-type incompatibilities.


For example, you may receive an error message when you take one of the following actions:
  • You try to connect to an instance of SQL Server. In this case, you receive the following error message:
    'sid_binary' is not a recognized built-in function name.
  • You expand the Management node in Object Explorer. In this case, you receive the following error message:
    Invalid object name 'msdb.dbo.syspolicy_configuration'.

Resolution

To resolve this problem, upgrade one of the following to the same version:
  • The SQL Server tools that include SQL Server Management Studio
  • The instances of SQL Server to which you want to connect
For information about how to install SQL Server 2008, visit the following Microsoft TechNet Web site:

More Information

The client object model for SQL Server Management Objects (SMO) does not support "in-cycle" backward compatibility when you connect to or use an instance of SQL Server 2008 from a different prerelease version. You may experience connection or operational error messages in SQL Server 2008 Management Studio (SSMS) or in other programs that use SMO.

The level of compatibility and the exact error messages that you receive may depend on the following:
  • The specific version of SQL Server 2008 client tools that you have installed
  • The specific instance version of SQL Server 2008 to which you are trying to connect
This problem does not occur when you use prerelease versions of SQL Server 2008 Management Studio to connect to instances of SQL Server 2000 or of SQL Server 2005 that include their released service packs.

References

For information about SQL Server 2008 Management Studio, visit the following Microsoft Web site:
Properties

Article ID: 955642 - Last Review: May 11, 2010 - Revision: 1

Feedback