View your SQL Server database in Management Studio 2008

  • Last updated on: 2015-06-12
  • Authored by: Rackspace Support

If you are having issues viewing your SQL Server 2005 database in Management Studio 2008 and the database is provisioned correctly in the Rackspace system, refer to the following blog post for troubleshooting information:

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/07/07/a-little-management-studio-oops.aspx

To fix the problem, you must connect to a SQL Server 2008 database engine, click the Databases folder, right-click in the column headers and uncheck collation. Then you can connect to a SQL Server 2005 database engine.

Continue the conversation in the Rackspace Community.