Re: Permissions on SQL Express 2005
I've had R6 running for sometime and been using it myself but it would not let other users logon. There was and Eole Exception: Can't access NBNData message.
Well on reviewing it I had found that through learning curve necessity I had bypassed suggested security and made myself a user directly rather than using a group. I had set up the groups but newbie status and the documentation being based on SQL Server 2003 meant some bits were hard to see a way through.
I went back to the documentation [thanks by the way] and made sure I had done all that could be based on what I could see and the difference on my 2005 Express system. Still I had the problem. I disabled my SQL logon and that just complained that it was disabled. I deleted it and got the same errors as my colleagues. A few adjustments to membership and check on roles and it all seems to work.
I now have an Admin group and a User group. I'm already forgetting what it was I did of course which seems to be the case with so many choices and boxes to tick as well as the interrelationships.
I just thought I'd pass on a note some success where once there was a minefield.;)
Somerset Environmental Records Centre