in

Dot Net Mafia

Group site for developer blogs dealing with (usually) .NET, SharePoint 2013, SharePoint 2010, Office 365, SharePoint Online, and other Microsoft products, as well as some discussion of general programming related concepts.

This Blog

Syndication

Archives

Corey Roth [MVP]

A SharePoint MVP bringing you the latest time saving tips for SharePoint 2013, SharePoint 2010, Office 365, SharePoint Online, MOSS 2007, ASP.NET, LINQ, and Visual Studio 2012.

Remember to set SQL permissions before doing a database attach upgrade

For some reason, I always forget to set permissions on the database in SQL Server when I am doing a database attach upgrade in SharePoint 2010.  I figure if I forget it a lot maybe other people do, so I thought I would post a quick tip on it.  Before even trying Test-SPContentDatabase or Mount-SPContentDatabase, make sure you open SQL Server and set the right permissions.  You need to edit the permissions on the account that you are running the PowerShell commands with and make this account a db_owner on the content database.  If you don’t, you will get an error stating that you don’t have the required permissions and you will look silly in front of your client.  :-)  It’s not a big deal to resolve, but I figure if I write this maybe I won’t forget to set it next time I do an upgrade.

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About CoreyRoth

Corey Roth is an Applications Architect at Infusion specializing in ECM and Search.
2012 dotnetmafia.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems