Connect to SQL Server 2005 Db using SSMS 2008

Is there a way to connect to a SQL 2005 db using SQL Server Management Studio 2008 on this hosted account?

I do it all the time on our internal servers, but when attempting to connect to discountasp 2005 hosted db I get the following permissions error
(Error 916, severity 14, state 1):

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server principal "SQL2005_xxxxx" is not able to access the database "SQL2005_609570_shiplocator" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?Prod...226&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

 

Thanks - just tested, got the same error & opened a ticket.

 

Response to ticket

FYI followup to correct:
reviewed kb article per ticket response:
http://support.discountasp.net/KB/a472/sql-2008-management-studio-error-server-principal-is.aspx

However an 'out-of-the-box' install doesn't include any of the columns you are advised to uncheck; however, it does includes 'Collation' in the column headers for the 'Object Explorer Details' pane.

If you uncheck the 'Collation' column it'll work.

 

Thanks for following up with your findings.