Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 User 'guest' does not have permission to run DBCC

Author  Topic 

go9189
Starting Member

1 Post

Posted - 2015-01-15 : 00:52:27
Good day to you.
I try to attach a database mdf file to Microsoft SQL server 2014 on Amazon Elastic Computing Cloud, EC2, but fail with the following message,
"User 'guest' does not have permission to run DBCC checkprimaryfile. (Microsoft SQL Server, Error: 2571)"
The ID I use to REMOTE login has administrator rights and I have chosen to "run as administrator"
Please help, and thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-15 : 12:28:47
This was a bug in earlier versions, so I would contact Microsoft to see if it's a bug in 2014: https://support.microsoft.com/kb/2268122?wa=wsignin1.0

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -