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.
| Author |
Topic |
|
ankit_anshu1
Starting Member
3 Posts |
 Posted - 2010-08-26 : 03:20:50
|
| Hi all,I created SQL authentication and logged in to the MS SQL server 2005 succesfully.but when ever i am trying to right click to the database and see the ptoperties. i see theis error.TITLE: Microsoft SQL Server Management Studio Express------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------User 'public' does not have permission to run DBCC showfilestats for database 'master'. (Microsoft SQL Server, Error: 7983)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=7983&LinkId=20476------------------------------BUTTONS:OK------------------------------I tried giving all permision to my sql authentication through windows authentication . but it didnt help.. Please reply to this asap. my lot of work is halted due to this.Regards,Ankit |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ankit_anshu1
Starting Member
3 Posts |
Posted - 2010-08-26 : 04:16:17
|
| I granted all the permission to Sql authentication.Ie:Alter connectionAlter databaseView definationView databaseView server stateAutnenticate serverIs there an specific grant to be prvided for this? |
 |
|
|
ankit_anshu1
Starting Member
3 Posts |
Posted - 2010-08-26 : 04:33:54
|
| Problem is resolved. I did not set the correct permission to my sql authenticated database.I set all the permision in sever role and it was good to go..thanks for help Tara Ankit |
|
|
|
|
|
|
User 'public' does not have permission to run DBCC