Wednesday, December 27, 2017

SQL Server Management Studio might need to be run as administrator

Today I needed to attach a database to an SQL Server instance. When I had it attempt the attachment, the operation failed, claiming that there was an access denied error about the database file. That seemed strange because my user account was the one that had extracted the database file, so I clearly had the rights to modify it. Nevertheless, restarting the management tool elevated made the operation succeed.

No comments:

Post a Comment