Migration from SQL 2008 to 2017

Question

Migration from SQL 2008 to 2017

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

skaggs.andrew SSCrazy Points: 2476 More actions · Answer 1

Lj Burrows - Thursday, April 12, 2018 6:09 AM
Go through the following link. It will resolve your issue:
https://blog.sqlauthority.com/2018/03/14/sql-server-database-attach-failure-msg-2571-user-guest-not-permission-run-dbcc-checkprimaryfile/

Yeas, thank you Lincoln. I am able to successfully attach the databases to the new environment.

skaggs.andrew SSCrazy Points: 2476 More actions · Answer 2

Thank you all for the feed back and info. My issues were resolved by adding my user to the sysadmin group. Once this was done, I was able to successfully attach the DB.