November 5, 2008 at 2:35 am
We're wishing to allow users the rights to attach databases through SSMS. We've made them a member of the dbcreator server role and given them a folder (where they have full access) which will contain the data and log files of the databases they wish to attach. However they are getting the following error:
User 'public' does not have permission to run DBCC checkprimaryfile. (Microsoft SQL Server, Error: 2571)
November 5, 2008 at 3:33 am
Hello,
Does this thread help?
http://www.codeplex.com/MSFTDBProdSamples/Thread/View.aspx?ThreadId=24515
It seems they solved the issue by running SSMS using a Windows Administrator account.
Regards,
John Marsh
PS: Nice Avatar 🙂
www.sql.lu
SQL Server Luxembourg User Group
November 5, 2008 at 3:47 am
Tried running SSMS as localadmin but it didn't help. 🙁
November 5, 2008 at 4:30 am
Hello Again,
There are a couple of threads around (like the one below) that seem to suggest it is an issue with Windows rather than SQL permissions. Can you check an example file to see if the users have full access rights to the DB file i.e. not just the folder?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
November 5, 2008 at 4:42 am
Will do. Thanks for your help on this 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply