Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

Windows Group Access and SQL Server 2005 Management Studio

Yesterday, a developer sent me an e-mail indicating he was having problems creating a table in SQL Server Management Studio.  He was using the GUI rather than the CREATE TABLE T-SQL statement.  When he tried to save his changes, he encountered the following error:

Property DefaultSchema is not available for Database '[DatabasName]'.  This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (SQLEditors)

We add developers to the db_owner role in each of the development databases, so I didn't think that permissions was the issue.  I did some googling and found this.

You'll encounter this error when you try to use the GUI to create a table, are not sysadmin, and your access to the SQL Server 2005 database is from a Windows group.  See Raul Garcia's post in the thread for a workaround.

The thread indicates that Microsoft is aware of the problem.

We already have service pack 1 installed, so it must not be included in it.  Hopefully, service pack 2 has the fix for this bug.

Print | posted on Wednesday, May 24, 2006 4:31 PM | Filed Under [ SQL Server - Database Administration ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET