Problem with connection to MS SQL Server database using SSMS

Question

I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log in using SSMS with success (after giving my hostname and access data).

However: Now from in SSMS, when attempting to expand the "Databases" folder tree, I get the following error:

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 "cmitchell" is not able to access the database "3pointdb" under the current security context. (Microsoft SQL Server, Error: 916)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4262&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

Answer 1

You don't appear to have permissions to view that database. I would suggest GODaddy tech support would be the place to resolve the issue.

Answer 2

I been having the same problem but finally fix the issue.

http://clayburt.com/2009/12/28/godaddy-windows-hosting-ms-sql-2005-database-with-sql-management-studio-ssms-2008/

Read the direction carefully

1. Open SSMS
2. Connect to the Database with Godaddy
3. Open "Object Explorer Details"
4. Click on Database
5. Right-Click on any column name heading
6. Un-check collation column

I do know why this happen but it happen to fix the problem for me. Hope that helps!