Microsoft SQL Server and Management Studio Troubleshooting


Here is a list of common problems and errors that we have encountered on occasion with Microsoft SQL Server and/or Microsoft SQL Server Management Studio. We are listing these solutions as a courtesy for Microsoft developers working with Webvault servers and hosted SQL server databases on our network. If you would like further assistance while using a Microsoft SQL Server database hosted by Webvault please contact our support team.

ERROR: Saving changes is not permitted (While Editing a Table)

This is a new safety feature added in SQL Management Studio 2008. To allow changes to a table, that requires a table to be recreated, you must alter the following option.

1. Click on the Tools menu in Management Studio (SSMS), and choose Options.
2. In the navigation pane on the Options window, click Designers.
3. Untick the option on the right which says Prevent saving changes that require table re-creation.
4. Click OK to save changes to SSMS options.

ERROR: The server principal XXX is not able to access the database XXX under the current security context.

This error sometimes occurs while loading the list of databases available on the SQL server while using Microsoft SQL Server Management Studio. The problem appears to relate to a bug with Management Studio. Here is one possible work around.

Please try using the following workaround and let us know if that helps:
1) Bring Object Explorer Details window by selecting View --> Object Explorer Details in menu (or hitting F7)
2) In Object Explorer window click at Databases folder
3) In Object Explorer Details window right-click at the column header and deselect Collation
4) Refresh Databases folder.

Courtesty of Stanislav Chiknavaryan, SQL Server Software Design Engineer

Full details on these forum threads:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354291&wa=wsignin1.0
http://forums.microsoft.com/msdn/showpost.aspx?postid=3531315&isthread=false&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0