March 3, 2011 at 2:38 pm
Hi all i am getting this error when adding a windows login in sql server 2008
The SELECT permission was denied on the object 'configurations', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)"
any help is appreciated.
March 6, 2011 at 10:15 pm
Hi,
Has someone been messing around with the public permissions? Can you run dbcc checkdb on the database 'mssqlsystemresource'. This database is another system database that is hidden in SQL so you don't see it in SSMS.
March 9, 2011 at 4:58 am
sean.massey (3/6/2011)
Hi,Can you run dbcc checkdb on the database 'mssqlsystemresource'.
How to run ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 9, 2011 at 9:19 am
hi,
How do you execute a DBCC command on a database which is hidden....
March 9, 2011 at 11:15 am
bbsr (3/9/2011)
hi,How do you execute a DBCC command on a database which is hidden....
You can't run.
How your are create the login gui or script.
What permission do you have ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 9, 2011 at 11:21 am
i log in using my windows credentials and have read and write permission.
March 10, 2011 at 4:21 am
bbsr (3/9/2011)
i log in using my windows credentials and have read and write permission.
You don't have permission to do this.
You didn't replied my 1st question
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
March 10, 2011 at 10:01 am
use the gui to create logins.
March 10, 2011 at 11:29 pm
bbsr (3/10/2011)
use the gui to create logins.
What the GUI shows . Attach me the screen shot.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply