Blogging about SharePoint

4/20/2009

Need More Permissions than Sec Admin and DB Creator to Attach Content Database in SQL 2008

So I decided that the best way for me to get some content into this new MOSS farm that I created was to attach a content database.

I logged into my farm server (it’s a demo environment so it’s all on one box). I logged in as my Farm Admin account.

I went into SQL Server Management Studio, right clicked the Databases folder, and then clicked Attach. Got this:

That’s not what I was expecting. After asking one of our SQL gurus to take a look and having him tell me that he’d never seen this one before, I feared my install of SQL Server 2008 was broken and I’d have to reinstall…. But one last thing came to mind – I was logged in as my Farm Admin account, not the box admin/domain admin (machine is a Domain Controller so box admin is domain admin), so I only had Security Admin and DB Creator roles, not full control / system admin. Sure enough, when I logged into the machine as domain admin, the Attach dialog worked.

Hopefully, the attach will achieve what I want as well…

--Michael

Posted at 10:52 AM by Michael Blumenthal | Category: MOSS 2007 | Permalink | Email this Post | Comments (0)

Comments

There are no comments yet for this post.

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title

Body *

Please put your name at the end of your comment as the Name field doesn't display in the main view of the comments.

Name: *

Your name. If you first name is Michael, please provide initials or the like to clearly distinguish your name from Michael Blumenthal's.
Also, this field does not appear in the main view of the comments.

Need Paid Consulting Services?

Yes

Are you interested in engaging a SharePoint consultant for fee-based consulting services? If so, I can have an Account Executive from my employer contact you. Other site visitors will not see this column.

Additional Contact Information

Please provide additional contact information if you need a direct response. Other site visitors will not see this column.

What is tomorrow's date? *

This is a weak CAPTCHA based on advice from a tweet from @ToddKlindt.

Attachments