September 13, 2006 at 5:39 am
While working on some SP's yesterday for an Access project I started running into some errors. The symptons on the server were that when I went to Enterprise Manager to check permissions, all the permissions I had set for Users and Roles were gone. The only permissions showing were for my login on a couple of objects I created and never changed to dbo owner. I am in the db_owner role.
Another sympton is when I try to debug my SP's the debug dialog does not show my parameters and therefore I can't set them before debugging. I talked to one of our DBA's late yesterday and he saw no permissions and also couldn't see the parameters in the debug dialog. Hopefully when he gets in today he will have a solution. But in the meantime has anybody seen this problem and know how to correct it?
September 13, 2006 at 7:28 am
What edition & version are you using? Run this:
SELECT SERVERPROPERTY('edition'),
SERVERPROPERTY('productversion'),
SERVERPROPERTY('productlevel')
Thoughts: it could be an evaluation edition and your use time has expired. It could be SQL Server 2000 and not have the latest patch (it should be either SP3a or SP4). Those are quickly fixed issues. If it's not one of those, then someone or something (malicious code) may have gotten at your system.
-SQLBill
September 13, 2006 at 7:35 am
Enterprise Edition 8.00.2039 SP4
It's the latest, greatest in the 2000 version. The DBA said he thinks the Master DB may have gotten corrupted.
September 13, 2006 at 10:52 am
If the server is running I would have doubts about a corrupt master. Does dbcc checkdb run clean?
If it passes dbcc checkdb, the data loss is probably human error. Either way recovering from backups is your best bet.
Good luck,
September 13, 2006 at 11:31 am
It was something in Master, but they just fixed it. You could run a query on permissions in Query Analyzer and see them, but if you tried to look at permissions in Enterprise Manager you would not see them. If you tried to set permissions in Enterprise Manager they would not stay even though they gave you no error when you submitted them.
September 13, 2006 at 12:11 pm
So help others out here.....what was the solution?
-SQLBill
September 13, 2006 at 1:23 pm
The DBA didn't make it clear what the problem was. I know somebody made some change that messed things up, but he didn't say exactly what it was. I do know that they had to do a restore from a backup that was made before the change.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply