SQL SERVER 2008-Error 916

SQL SERVER 2008- Error 916: The server principal "username" is not able to access the database "EmployeesDB" under the current security context.

This error happens when you want to connect remotely with database in SQL Server 2008 Management Studio which is following by error message



Notice: if you connect with SQL Server 2005 Management Studio, it will connect with database(no error message)

To fix this problem

Following next steps:

1. In Object Explorer, click on Databases.

2. View Object Explorer Details
(F7) or View >> Object Explorer Details.

3.Right click on the column headers and deselect
collation


4.Refresh Databases

Open Table in SQL Server 2008 Management Studio

SQL Server 2008 Management Studio replaced open table by Edit Top 200 Rows.
Right click on a table >>Edit Top 200 Rows



You can change Edit Top 200 Rows by following next steps:
Tools >> Options >> SQL Server Object Explorer >> Commands

First notice about SQL Server 2008 Management Studio

When I was started using SQL Server 2008 Management Studio, the first things I noticed are Select Top 1000 Rows and Edit Top 200 Rows replaced by Open Table in SQL Server 2005 Management Studio